Tips for Minimizing Deadlocks
Deadlocks are caused by poor database design, inappropriate isolation level, inefficient code etc.
Checkout my article (Tips for Minimizing Deadlocks) on...
2013-05-07
911 reads
XML Support and SQL Server (Part 6)
Checkout the sixth part of my XML support and SQL Server article series here.
In this part, you will learn about...
2013-05-07
562 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
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
SQL Server 2008 R2 Diagnostic Information Queries (May 2013)
Here is the May 2013 version of my SQL Server 2008 R2 Diagnostic Information Queries, with some minor tweaks and...
2013-05-07
753 reads
SQL Server 2012 Diagnostic Information Queries (May 2013)
Here is the May 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-05-07
764 reads
SQL Server – How to Best Remove Extra TempDB Data Files and Log Files
One of the Microsoft’s recommendation for optimizing the tempDB performance is to make each tempdb data file the same size. Today,...
2013-05-06
946 reads
May 2013 – Monthly SQL Server Checklist
It’s the start of the month of May, or at least the first Monday in May. Hopefully you aren’t nursing...
2013-05-06
693 reads
SQLSaturday Atlanta #220–May 18th
I am pleased to be selected to present a session on Analysis Services at the Atlanta SQLSaturday this May 18th...
2013-05-06
555 reads
Donating for a little kid
One of my authors sent me this note:
“
I know you only know me as a writer for SQLServerCentral, but I...
2013-05-06
700 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