Tour
About Us
Meta
Loading…
Log in
current community
Stack Exchange
chat
Meta Stack Exchange
your communities
Sign up
or
log in
to customize your list.
more stack exchange communities
company blog
Stack Exchange
All Sites
Top Users
Digests
Jon of All Trades
Austin, TX
top
accounts
reputation
activity
bookmarks
subscriptions
Top Questions
25
votes
What steps are necessary to safely restart a machine hosting Microsoft SQL Server?
sql-server
best-practices
shutdown
asked Aug 26 '13 at 20:05
dba.stackexchange.com
23
votes
Is data retrieved from SQL Server compressed for transmission?
sql-server-2008
compression
asked Feb 22 '13 at 23:25
dba.stackexchange.com
18
votes
Why might a table's data space take up 4x the size of the raw data?
sql-server-2008
disk-space
asked Sep 6 '11 at 20:43
dba.stackexchange.com
18
votes
Why does this query become drastically slower when wrapped in a TVF?
sql-server
sql-server-2008
asked May 24 '11 at 18:50
dba.stackexchange.com
11
votes
How do I grant the privilege of connecting to SSIS?
ssis
privileges
dtexec
asked Sep 22 '14 at 20:28
dba.stackexchange.com
10
votes
What are the performance considerations between using a broad PK vs a separate synthetic key and UQ?
database-design
primary-key
index-tuning
unique-key
asked Oct 4 '11 at 2:09
dba.stackexchange.com
10
votes
What are best practices for safely permanently deleting a database?
maintenance
delete
sql-server
asked Jun 2 '11 at 23:18
dba.stackexchange.com
8
votes
Query pauses after returning a fixed number of rows
sql-server-2008
asked Jun 4 '12 at 19:59
dba.stackexchange.com
6
votes
What causes “attribute key cannot be found when processing” errors?
sql-server
sql-server-2014
ssas
asked May 15 '15 at 15:48
dba.stackexchange.com
6
votes
Can I calculate ROW_NUMBER() for only consecutive records?
sql-server
sql-server-2017
window-functions
gaps-and-islands
asked Jul 19 '18 at 21:25
dba.stackexchange.com
1
2
next
Top Answers
60
Can I write portable SQL statements?
dba.stackexchange.com
17
How do I grant the privilege of connecting to SSIS?
dba.stackexchange.com
16
Showing both your answer and the correct answer on UI
ux.stackexchange.com
11
Composite Primary Key efficiency as a Foreign Key
dba.stackexchange.com
9
What are valid usage scenarios for HEAP tables?
dba.stackexchange.com
7
Are two indexes needed?
dba.stackexchange.com
7
On Amazon RDS, what consumes storage space beyond the database files?
dba.stackexchange.com
6
Index optimization for table that is truncated every day
dba.stackexchange.com
6
Design star schema for many-many relationship
dba.stackexchange.com
5
Is select * still a big no-no on SQL Server 2012?
dba.stackexchange.com
5
Should I drop a foreign key if I use a soft delete?
dba.stackexchange.com
5
SQL Server commands to clear caches before running a performance comparison
dba.stackexchange.com
5
SQL Server Data Warehouse stored procedure location
dba.stackexchange.com
Stack Exchange works best with JavaScript enabled