8,029 reputation
1362
bio website brentozar.com
location Chicago, IL
age 41
visits member for 3 years, 10 months
seen yesterday

I make SQL Servers faster and more reliable. I'm a Microsoft Certified Master and Microsoft MVP.

Stuff I'm proud of:


May
27
revised SQL Server “TOP 101” much slower than “TOP 100”
Adding reference to Paul White post on SELECT TOP 100
May
27
comment SQL Server “TOP 101” much slower than “TOP 100”
That is so awesome! I hadn't seen that before - I'm going to edit my post around that, because that's a killer find.
May
27
answered SQL Server “TOP 101” much slower than “TOP 100”
May
27
comment SQL Server “TOP 101” much slower than “TOP 100”
Post the execution plans. If you need to anonymize them, use SQL Sentry Plan Explorer.
May
27
answered Building A SQL table horizontally VS vertically
May
17
reviewed Approve suggested edit on Database design and Technology
May
10
awarded  Revival
May
10
awarded  Revival
May
1
awarded  Nice Answer
Apr
16
reviewed Approve suggested edit on How do I restore a SQL backup, while excluding a specific table?
Apr
4
awarded  Revival
Mar
30
reviewed Approve suggested edit on UPDATE CONCAT without duplicates
Mar
28
reviewed Approve suggested edit on How To change the column order?
Mar
27
awarded  Custodian
Mar
27
reviewed Approve suggested edit on Best practices in securing Oracle Standard edition one
Mar
26
comment Purpose of Nonclustered indexes in SQL Server 2012
Cool, glad I could help.
Mar
25
answered Purpose of Nonclustered indexes in SQL Server 2012
Mar
7
answered SQL Server Memory Issues
Feb
24
awarded  Revival
Feb
22
awarded  Nice Answer