6,996 reputation
1156
bio website brentozar.com
location Chicago, IL
age 40
visits member for 3 years, 6 months
seen 3 hours ago

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

Stuff I'm proud of:


6h
comment Cluster Size Configurations for SQL Server at RAID Level
@serverimeco You're welcome.
1d
reviewed Approve suggested edit on What is the cost to create Materialized View log
1d
awarded  Mortarboard
1d
comment What happens during “big” inserts on a table with a clustered composite key?
You're welcome!
1d
awarded  Enlightened
1d
awarded  Nice Answer
1d
answered What happens during “big” inserts on a table with a clustered composite key?
2d
answered Incorrect result when you execute a query that uses WITH RECOMPILE option in SQL Server 2012
2d
reviewed Approve suggested edit on WHERE attribute having two relation lines in the same SQL
Jul
27
answered Cluster Size Configurations for SQL Server at RAID Level
Jul
26
reviewed Approve suggested edit on DBMS database management system
Jul
26
reviewed Approve suggested edit on Oracle program “lsnrctl” is missing after the installation of 32bit Oracle client
Jul
26
comment Estimate projected database growth
It depends on what people are putting into the database, yes.
Jul
26
comment INSERT/SELECT slow after TRUNCATE TABLE on table with 6 over mllion rows
When the query is running slow, run sp_WhoIsActive and see what the wait types are for the query. brentozar.com/go/active
Jul
25
awarded  Nice Answer
Jul
25
reviewed Approve suggested edit on Derive daily delta from total daily counts? Tsql
Jul
24
comment Should I shrink my database?
What's the problem you're trying to solve?
Jul
24
answered Estimate projected database growth
Jul
22
comment SQL server Index rebuild and restore not working
And start with Gail Shaw's excellent post, My Database is Corrupt, Now What: sqlservercentral.com/articles/Corruption/65804
Jul
21
comment Major Discrepancy Between SQLIO IOPS/Throughput Stats and DBCC CHECKDB Operations
Ah, typically I see people doing this in their development, QA, or staging environments as part of a data refresh, so there's no licensing incurred.