As Kimberly blogged about recently, SQLskills is embarking on a new initiative to blog about basic topics, which we’re calling SQL101. We’ll all be blogging about things that
This is something that came up recently on the Microsoft Certified Master DL, and is something I discuss in our IEPTO1 class because of the
I’m running this survey to help the SQL Server team at Microsoft, who would like to get a broad view of current tempdb configurations. I’ll
It’s well known that one of the common performance issues that can affect tempdb is allocation bitmap contention. I discuss this, and ways to alleviate
For the longest time the guidance around tempdb is that if you shrink it on a live system then it could cause tempdb corruption. A
(New for 2020: we’ve published a range of SQL Server interview candidate screening assessments with our partner Kandio, so you can avoid hiring an ‘expert’ who
(New for 2020: we’ve published a range of SQL Server interview candidate screening assessments with our partner Kandio, so you can avoid hiring an ‘expert’ who
Earlier this morning I noticed a discussion on the SQL MCM distribution list (that all the original MCM instructors are part of) that was trying
This is a question that came up today on Twitter, and is actually something I’ve been meaning to blog about. One of the biggest space
A few weeks ago I kicked off a survey about tempdb configuration – see here for the survey. I received results for more than 600
In this week's survey, I want to know how you've got tempdb configured compared to the number of processor cores SQL Server thinks it has.
I’m starting a new blog category to talk about some of weird and confusing stuff I see while query tuning. First up is the case
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
Last week I posted in-depth about how checkpoints work and what exactly goes on (see How do checkpoints work and what gets logged). About a
[Edit 2016: This trace flag is required in all version of SQL Server up to and including SQL Server 2014. Every instance of SQL Server
The April edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A column. This month's
Over the last few weeks Sunil Agarwal (from the SQL Storage Engine team) has posted a great series of blog articles about tempdb and the version
(Quickie post #2 while it's Kimberly's turn to lecture this morning…) Greg asked a question regarding the script I posted to examine buffer pool contents (paraphrased)
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.