7,296 reputation
1157
bio website brentozar.com
location Chicago, IL
age 40
visits member for 3 years, 7 months
seen 13 hours ago

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

Stuff I'm proud of:


Aug
18
answered Optimized Way of Scheduling a Differential Backup
Aug
18
answered SQL Server SSL connection
Aug
18
answered Why is an additional filtered statistic being ignored (EAV schema)?
Aug
18
answered Microsoft SQL Server Connection Coloring
Aug
17
answered Database events that will cause deletion of index
Aug
16
comment SQL Parameter Sniffing Possible Workaround
@ShaunBowe Hahaha, awesome. Jes Schultz Borland has a really good one there about parameter sniffing called The Elephant and the Mouse. "Very frequently" is a little tricky - my general rule is if it's happening more than 10-100 times a second, then you want a good long term fix.
Aug
16
answered SQL Parameter Sniffing Possible Workaround
Aug
6
awarded  Revival
Aug
6
revised MongoDB read performance
Fixing title from MongDB to MongoDB
Aug
6
comment “Arithmetic overflow” when initializing SQL Server 2012 replication from backup
By chance, does it have billions of rows in the replicated tables? If so, it's a known bug: connect.microsoft.com/SQLServer/feedback/details/723133/…
Aug
6
answered Execute T-SQL Only If AlwaysOn Database Is Primary
Aug
6
answered Extremely Slow StatMan query issue with #SP2010 farm
Aug
6
reviewed Approve suggested edit on How to tell what invoked a trigger in SQL Server?
Aug
2
comment What's the maximum number of tables that can be referenced in a query in MySQL?
Just FYI - that 256 table limit was for SQL Server 2005. It's now limited only by server resources: msdn.microsoft.com/en-us/library/ms143432.aspx
Jul
30
comment Cluster Size Configurations for SQL Server at RAID Level
@serverimeco You're welcome.
Jul
29
reviewed Approve suggested edit on What is the cost to create Materialized View log
Jul
29
awarded  Mortarboard
Jul
29
comment What happens during “big” inserts on a table with a clustered composite key?
You're welcome!
Jul
29
awarded  Enlightened
Jul
29
awarded  Nice Answer