TempDB in RAM needs a review of capacity, support and memory pressure. I compare those costs with the bottleneck it would address.
SQL SERVER – Add New Column With Default Value
A developer used three statements to add a column, fill it and make it NOT NULL. One ALTER TABLE can add a new column with default value in one step.
SQLAuthority News – TechED 2011 – Bangalore – An Unforgettable Experience – Day Next
The day after TechEd 2011 in Bangalore I still woke up at 5 AM out of habit. Here is the final part of my series, with a quiet day at home with Shaivi.
SQLAuthority News – TechED 2011 – Bangalore – An Unforgettable Experience – Day 3
Day 3 of my unforgettable experience at TechEd 2011 Bangalore was my big day, with two sessions to present after less than 6 hours of sleep in 3 days.
SQLAuthority News – TechED 2011 – Bangalore – An Unforgettable Experience – Day 2
Day 2 of my unforgettable experience at TechEd 2011 Bangalore, March 24, was a very eventful day that started at 5 AM and brought me to my MVP friends.
OFFSET FETCH Paging and Its Deep Page Problem
Use OFFSET FETCH with a unique sort order, compare early and deep page reads, and decide when a cursor based approach fits better.
SQL SERVER – MondayMeme – 11 Words or Less
Thomas LaRock started a MondayMeme of 11 words or less, and Amit Banerjee tagged me. My one-liner is about wait types and queues for quick tuning.