8,337 reputation
1465
bio website brentozar.com
location Chicago, IL
age 41
visits member for 3 years, 11 months
seen Dec 12 at 12:59

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

Stuff I'm proud of:


Jul
16
comment How to get output from trigger on linked server
Putting logging in the trigger is the way to go here, but the danger is setting up a big distributed transaction where the insert fires, plus the output table is read, all from a transaction done across servers. Recipe for concurrency problems there.
Jul
16
answered Database/Storage engine suggestion for a project involving heavy inserts?
Jul
16
comment How can I interpret the results of these DMVs to help me evaluate our partitioning strategy?
@swasheck You bet! Glad I could help.
Jul
14
awarded  Revival
Jul
13
answered How can I interpret the results of these DMVs to help me evaluate our partitioning strategy?
Jul
5
comment All queries on the server have slowed down, cpu is normal, plenty of free memory but SQL is using very little
Interesting. Looking forward to seeing those troubleshooting results.
Jul
4
comment All queries on the server have slowed down, cpu is normal, plenty of free memory but SQL is using very little
@MaxVernon Hahaha, thanks sir!
Jul
4
comment All queries on the server have slowed down, cpu is normal, plenty of free memory but SQL is using very little
It only uses the memory that is required for your queries. What's the root problem that you're trying to solve? Low memory usage isn't a problem end users complain about. Do the heavy operation, and then do the troubleshooting while it's running.
Jul
4
answered Use SQL or NoSQL?
Jul
4
answered All queries on the server have slowed down, cpu is normal, plenty of free memory but SQL is using very little
Jun
2
comment SQL Server “TOP 101” much slower than “TOP 100”
@PaulWhite I mostly just read your stuff for the pictures.
May
27
comment SQL Server “TOP 101” much slower than “TOP 100”
HAHAHA, thanks!
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 Database design and Technology
May
10
awarded  Revival
May
10
awarded  Revival