Photo by rawpixel.com on Unsplash
Here's a word for word transcription of a conversation I've had a hundred times over:
"Hi I'm Bert. What do you do?"
"I'm ____ and I'm a SQL developer."
"That's cool,...
2017-10-24
8 reads
Photo by Fischer Twins on UnsplashYou probably tune your queries for maximum performance. You take pride in knowing how to add indexes and...
2017-10-17
198 reads
Photo by Fischer Twins on Unsplash
You probably tune your queries for maximum performance. You take pride in knowing how to add indexes and refactor code in order to squeeze out every last...
2017-10-17
7 reads
Photo by James Sutton on UnsplashNote: the problem described below applies to all SELECT queries, not just those adorned with NOLOCK...
2017-10-10
386 reads
Photo by James Sutton on Unsplash
Note: the problem described below applies to all SELECT queries, not just those adorned with NOLOCK hints. The fact that it applies to NOLOCK queries...
2017-10-10
10 reads
Watch this week’s interview with Drew on YouTube.
Have you ever had to perform repetitive tasks in SQL Server?
Maybe you’ve had...
2017-10-03
145 reads
Watch this week's video on YouTube
Have you ever had to perform repetitive tasks in SQL Server?
Maybe you've had to manually verify backups, script out all of a server's logins/groups/permissions,...
2017-10-03
4 reads
Photo by Patrick Tomasso on UnsplashHow many times have you known that adding an index would improve query performance but you weren’t exactly sure which type of...
2017-09-26
1,493 reads
Photo by Patrick Tomasso on Unsplash
How many times have you known that adding an index would improve query performance but you weren't exactly sure which type of index to add?
This happened to me all the time...
2017-09-26
7 reads
Photo by Chad Kirchoff on Unsplash
Prefer watching on YouTube?
In the ideal world, you fully test how your SQL Server will handle upgrading to...
2017-09-19
185 reads
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
I need to delete rows from both the temporal main and history tables. The...
Comments posted to this topic are about the item When SQL Server Central Went...
Comments posted to this topic are about the item The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers