SQL Saturday #200 - Philadelphia
If you read my post from yesterday you will know I will be spending some time on the US east...
2013-05-08
780 reads
Blog Posts
SQL Server 2005 Diagnostic Information Queries (May 2013)
Here is the May 2013 version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-05-08
846 reads
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
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,478 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
12 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,111 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
678 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,216 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers