SQL Server 2008 Diagnostic Information Queries (May 2013)
Here is the May 2013 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-05-08
708 reads
Blog Posts
SQLSaturday #209 – Rochester
Welcome to the Roc!
Just a quick note that I’ll be presenting this weekend, Saturday May 11th, at SQLSaturday in Rochester,...
2013-05-08
796 reads
Starting with Git for Database Development
One of the tools that Red Gate Software makes is SQL Source Control. It’s a plug in to SSMS that...
2013-05-08
8,479 reads
An Alternative to SELECT COUNT(*) for Better Performance
Sometimes rapid code development doesn't always produce the most efficient code. Take the age old line of code SELECT COUNT(*)...
2013-05-07
5,296 reads
Attach Database with Missing NDF File
I wonder if you’ve had the situation that I had before where you have to attach a database with one or few missing .ndf files. It seems pretty common...
2013-05-07
14 reads
Billing rates – other side of the fence, part 2
Here is another response to my blog “Should a placement firm tell you what they are billing the client?” (the...
2013-05-07
1,112 reads
Books On The Desk
I read quite a bit and it’s rare that I don’t have a book or magazine with me in case...
2013-05-07
680 reads
Find Duplicate Indexes on SQL Server (Script)
Like other mainstream commercial database systems, Microsoft SQL Server allows you to create multiple indexes on the same column of...
2013-05-07
1,217 reads
I'm Giving a SQL Server Security Webinar on May 9, 2013
On May 9, 2013, at 3 PM EDT I will be presenting on 5 Steps Every DBA Should Take to...
2013-05-07
1,202 reads
Installing SSMS 2012 all by it’s lonesome
SQL Server Management Studio (SSMS) is not offered as a standalone download on MSDN.
Installation requires the user to download the...
2013-05-07 (first published: 2013-04-30)
26,614 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Designing for Teams
Comments posted to this topic are about the item Designing for Teams
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers