8,329 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:


Dec
16
awarded  Revival
Dec
11
comment What is a deterministic method for evaluating a sensible buffer pool size?
James - generally speaking, I don't want to make changes that cause users to complain. If you do want to do that, you could gradually step down the amount of memory for each server until the users start to complain, but when I'm already overworked, I generally don't have time to take those steps. I have to focus on the tasks that will make unhappy users happy - rather than trying to make happy users unhappy. ;-)
Dec
11
awarded  Revival
Dec
11
answered What is a deterministic method for evaluating a sensible buffer pool size?
Dec
8
awarded  Necromancer
Dec
8
answered AlwaysOn Availability Groups log_send_rate
Dec
8
answered Clustered columnstore indexes and foreign keys
Dec
8
answered Offsite Log Shipping
Dec
2
awarded  Announcer
Nov
25
comment DBCC DBINFO showing wrong information
HAHAHA, if it makes you feel better, I do have a new pair of glasses waiting for me at the optometrist today. Have a good week.
Nov
25
answered How to make distributor highly available in Always On Configuration
Nov
25
answered DBCC DBINFO showing wrong information
Nov
13
awarded  Revival
Nov
5
answered Has the guidance on the setting for 'cost threshold for parallelism' changed with the advent of columnstore indexes?
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)