User Brent Ozar

148 votes

Is adding the ‘tbl’ prefix to table names really a problem?

answered Nov 5, 2016 at 14:42

123 votes

How do I get back some deleted records?

sql-server sql-server-2008 recovery

answered Jan 31, 2011 at 14:21

70 votes

Accepted

DBA first day in a new job - check backups and security - How? what else should be checked?

sql-server sql-server-2014 backup restore security

answered Feb 15, 2017 at 12:33

69 votes

SQL Server Error 8632 due to over 100,000 entries in WHERE clause

sql-server configuration limits

answered Aug 8, 2017 at 13:22

53 votes

Accepted

Why is it a bad practice to allow everyone to use the sa login?

sql-server security

answered Aug 8, 2011 at 11:55

52 votes

Accepted

SQL Server's "Total Server Memory" consumption stagnant for months with 64GB+ more available

sql-server performance sql-server-2016 memory sp-blitz

answered Apr 16, 2018 at 16:10

48 votes

Is it bad to have index space larger than data space?

sql-server index

answered Feb 13, 2019 at 13:35

37 votes

Accepted

Pagination in SQL Server

sql-server pagination

answered Nov 4, 2016 at 10:32

36 votes

Stop SQL Server from ordering results?

sql-server group-by order-by nonclustered-index

answered Sep 25, 2017 at 6:47

34 votes

SQL Server clears plan cache and execution stats periodically

sql-server sql-server-2016

answered Jul 31, 2017 at 11:08

33 votes

Accepted

Find Queries that Are Causing Waits

sql-server-2008 waits

answered Mar 4, 2011 at 23:50

30 votes

Accepted

Understanding varchar(max) 8000 column and why I can store more than 8000 characters in it

sql-server varchar max

answered May 18, 2017 at 6:33

30 votes

Can SQL Server's crash resilience be improved?

sql-server crash

answered Jul 17, 2018 at 14:13

30 votes

Accepted

Why Do My Nonclustered Indexes Use More Space When I Delete Rows?

sql-server sql-server-2014 nonclustered-index

answered Feb 14, 2019 at 22:10

29 votes

Does restarting SQL Server speed it up?

sql-server performance maintenance

answered Oct 26, 2011 at 17:11

28 votes

Accepted

How can I add a rowversion column to a large table with minimal downtime

sql-server sql-server-2008 alter-table

answered Mar 21, 2012 at 17:55

28 votes

Why are queries causing spill to tempdb?

sql-server sql-server-2012

answered Jul 16, 2014 at 7:15

25 votes

How to resolve RESOURCE_SEMAPHORE and RESOURCE_SEMAPHORE_QUERY_COMPILE wait types

sql-server performance sql-server-2005

answered Feb 15, 2017 at 21:33

24 votes

Accepted

Join tables in two databases make query slow? is better to partition db?

sql-server sql-server-2008-r2 join partitioning

answered Aug 30, 2014 at 17:19

22 votes

What are the top 3 performance Issues that you encounter with your SQL Servers?

sql-server performance

answered Aug 8, 2011 at 11:40

22 votes

What does the word "SARGable" really mean?

terminology

answered Jan 25, 2017 at 21:51

21 votes

Estimate projected database growth

sql-server sql-server-2008 size

answered Jul 24, 2014 at 22:52

21 votes

Does backing up a database shrink the transaction log size?

sql-server transaction-log

answered Apr 10, 2018 at 10:33

21 votes

Accepted

Is it possible to scale-out with Microsoft SQL Server?

sql-server

answered Mar 14, 2018 at 8:25

20 votes

Accepted

What happens during "big" inserts on a table with a clustered composite key?

sql-server

answered Jul 29, 2014 at 13:07

20 votes

Accepted

Does anybody know what this tool is called?

sql-server

answered Jul 27, 2016 at 23:48

19 votes

What reasons are there to stop the SQL Server?

sql-server sql-server-2008-r2 shutdown

answered Jan 7, 2017 at 21:18

19 votes

Accepted

Is "AlwaysOn" not always "Always On?"

sql-server availability-groups sql-server-2016 failover

answered Mar 2, 2017 at 19:22

18 votes

Are there standard SQL functions with side effects?

functions sql-standard

answered Feb 25, 2017 at 14:41

18 votes

Accepted

Should a multi tenant system with SQL Server 2016, Shard or have Tenant isolation via separate database per tenant?

sql-server database-design sharding scalability multi-tenant

answered Feb 11, 2017 at 20:40

Stack Exchange Network

current community

your communities

more stack exchange communities

531 Answers

Is adding the ‘tbl’ prefix to table names really a problem?

How do I get back some deleted records?

DBA first day in a new job - check backups and security - How? what else should be checked?

SQL Server Error 8632 due to over 100,000 entries in WHERE clause

Why is it a bad practice to allow everyone to use the sa login?

SQL Server's "Total Server Memory" consumption stagnant for months with 64GB+ more available

Is it bad to have index space larger than data space?

Pagination in SQL Server

Stop SQL Server from ordering results?

SQL Server clears plan cache and execution stats periodically

Find Queries that Are Causing Waits

Understanding varchar(max) 8000 column and why I can store more than 8000 characters in it

Can SQL Server's crash resilience be improved?

Why Do My Nonclustered Indexes Use More Space When I Delete Rows?

Does restarting SQL Server speed it up?

How can I add a rowversion column to a large table with minimal downtime

Why are queries causing spill to tempdb?

How to resolve RESOURCE_SEMAPHORE and RESOURCE_SEMAPHORE_QUERY_COMPILE wait types

Join tables in two databases make query slow? is better to partition db?

What are the top 3 performance Issues that you encounter with your SQL Servers?

What does the word "SARGable" really mean?

Estimate projected database growth

Does backing up a database shrink the transaction log size?

Is it possible to scale-out with Microsoft SQL Server?

What happens during "big" inserts on a table with a clustered composite key?

Does anybody know what this tool is called?

What reasons are there to stop the SQL Server?

Is "AlwaysOn" not always "Always On?"

Are there standard SQL functions with side effects?

Should a multi tenant system with SQL Server 2016, Shard or have Tenant isolation via separate database per tenant?