7,849 reputation
1361
bio website brentozar.com
location Chicago, IL
age 40
visits member for 3 years, 9 months
seen 2 days ago

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

Stuff I'm proud of:


Oct
22
awarded  Necromancer
Oct
16
comment Unexpected results with random numbers and join types
Right, exactly - that's what's happening, but it's definitely not expected. The results don't match the T-SQL that's being passed in, and thus the question.
Oct
3
awarded  Revival
Sep
17
answered Weird deadlock graph
Sep
12
answered SQL Server is caching query plans with the same query when using parameterized SQL
Sep
12
revised Amazon: How to change database name in Amazon RDS MySQL?
Clarified MySQL in tag and title (since RDS is available w/MSSQL, MySQL, Oracle)
Sep
11
comment How do I tactfully bring up database shortcomings?
@James exactly, I'm saying let them believe it used to be a best practice. That lets them escape with dignity. There's no need to rub their face in what they did - as long as you can get the result you want an easier way, do it.
Sep
10
awarded  sql-server
Sep
9
awarded  Nice Answer
Sep
9
answered How do I tactfully bring up database shortcomings?
Sep
5
answered SQLIO and its Flags
Sep
5
awarded  Organizer
Sep
5
comment Domain name change of SQL servers involved in replication
Are they just renaming the domain, or are they moving servers between domains? If it's the latter, are there any trusts between the old & new domains?
Sep
5
comment SQLIOSIM fails to run when using UNC path
Try adding a folder inside the share, like \\c16\vol1cifs\sqliosimtests, and grant full read/write access on that share to the public. (Just making sure it's not a permissions problem.)
Sep
5
revised comparing values between two tables
Removing SQL Server tags
Aug
31
awarded  Nice Answer
Aug
30
answered Join tables in two databases make query slow? is better to partition db?
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)?