SQL Server and Evil Greedy Data Types
In a recent post, I talked about SQL Server reads and how the data is stored in pages. One of...
2018-03-02
45 reads
Blog Posts
Use Filtered Statistics to Improve Performance on Very Large Tables
Let’s say you have a very large table on a SQL Server 2012 Standard Edition instance. This means: old cardinality...
2018-03-02
380 reads
Using a gMSA with SQL Server
As you already know, SQL Server runs as a service. And services require a service account to run under. While...
2018-03-02 (first published: 2018-02-19)
17,061 reads
Using SWITCH On A Single Partition
Several months ago, I was looking at a question posted on ask.sqlservercentral.com. I discovered an answer to a question regarding...
2018-03-02
150 reads
What is the CXPACKET Wait Type?
This wait type indicates that parallel plans execute on the server. This wait type doesn’t necessarily means there is a...
2018-03-02
827 reads
YouTube Channel Update
Hey! Here’s the latest on my YouTube Channel. Click on through and subscribe. I’ll be doing lots of stuff on...
2018-03-02
315 reads
A Swiss Army Knife Might Not Make the Best Shovel
You might have noticed that I’ve been pretty quiet as of late. We’re working on a super top secret internal...
2018-03-01
762 reads
An overview of SQL Server backup-and-restore process
In a manner of speaking, planning and implementing a SQL Server backup design is an art. Backup, Restoration, Recovery, Business...
2018-03-01
841 reads
Backup & Restore Script with a Move
Ok, I’ll admit it. I like scripts that are handy and do things. Especially if the scripts make my life...
2018-03-01 (first published: 2018-02-16)
2,300 reads
Database Superhero Adventures, March 2018 Edition
I had two SQL Saturdays this month SQLSaturday Cleveland (which was very cold) and SQLSaturday Tampa (which had very nice...
2018-03-01
200 reads
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers