Stack Exchange

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

Top Answers