A gotcha when switching partitions
When working with partitioning the SWITCH operation has to be my favourite. The ability to move a large amount of...
2018-02-28
3,154 reads
Dates and Times in SQL Server: SMALLDATETIME
Last week I spoke about a world wary data type for storing dates and times in a single column, with...
2018-02-28
1,069 reads
Blocking Locks and Deadlocks
Situation Your query is waiting for another query and the other query is doing nothing. Blocking Locks A blocking lock...
2018-02-28
249 reads
Blocking Locks and Deadlocks
Situation Your query is waiting for another query and the other query is doing nothing. Blocking Locks A blocking lock...
2018-02-28
497 reads
Doing DevOPs for your Database? You need to start here…
I’ve been doing that thing called DevOPs for about 17 years – you know – before it had a name…
In fact it...
2018-02-28
1,270 reads
New Built-in Function STRING_AGG() – SQL Server 2017
SQL Server 2017 introduces a set of useful functions like STRING_AGG(), STRING_SPLIT(), TRIM()… and many more. In this tip, I am...
2018-02-28
9,379 reads
Typing Alternative Characters
I tend to work in the US English world. I’m somewhat embarrassed to note that I really only know one...
2018-02-27
472 reads
Adaptive Joins
I was surprised to find out that a lot people hadn’t heard about the new join type, Adaptive join. So,...
2018-02-27
1,151 reads
How to make a Database Request
You need something from the database admin. Maybe it’s permissions, maybe it’s code troubleshooting, or maybe it’s just that the database is...
2018-02-27
506 reads
Planning to Increase Cost Threshold for Parallelism – Like a Smart Person!
Planning to Increase Cost Threshold for Parallelism
When administrating a SQL Server instance with multiple CPU cores and heavy workload, it’s...
2018-02-27
1,156 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
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...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
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...
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