user avatar
user avatar
user avatar
Brent Ozar
  • Member for 11 years, 7 months
  • Last seen this week
148 votes

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

123 votes

How do I get back some deleted records?

70 votes
Accepted

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

69 votes

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

53 votes
Accepted

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

52 votes
Accepted

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

48 votes

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

37 votes
Accepted

Pagination in SQL Server

36 votes

Stop SQL Server from ordering results?

34 votes

SQL Server clears plan cache and execution stats periodically

33 votes
Accepted

Find Queries that Are Causing Waits

30 votes
Accepted

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

30 votes

Can SQL Server's crash resilience be improved?

30 votes
Accepted

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

29 votes

Does restarting SQL Server speed it up?

28 votes
Accepted

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

28 votes

Why are queries causing spill to tempdb?

25 votes

How to resolve RESOURCE_SEMAPHORE and RESOURCE_SEMAPHORE_QUERY_COMPILE wait types

24 votes
Accepted

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

22 votes

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

22 votes

What does the word "SARGable" really mean?

21 votes

Estimate projected database growth

21 votes

Does backing up a database shrink the transaction log size?

21 votes
Accepted

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

20 votes
Accepted

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

20 votes
Accepted

Does anybody know what this tool is called?

19 votes

What reasons are there to stop the SQL Server?

19 votes
Accepted

Is "AlwaysOn" not always "Always On?"

18 votes

Are there standard SQL functions with side effects?

18 votes
Accepted

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

1
2 3 4 5
18