Unexpected truncation in FETCH
Yes I’m talking about FETCH as in a cursor, yes everyone hates cursors. But you know cursors are like anything...
2013-10-23
717 reads
SQLStudies
A look at comments
Everyone knows that we should include comments in our code right? On the other hand the vast majority of us...
2013-10-29 (first published: 2013-10-21)
1,737 reads
Query to compare indexes between two tables
We have a set of databases at my office that use the load and swap method of loading data with...
2013-10-16
1,205 reads
Why you should know how to script as well as use the GUI
Personally I’ve always enjoyed learning the T-SQL for any given task. The GUI is usually pretty easy to figure out...
2013-10-14
1,007 reads
I’ve refreshed a test database from prod but now the users can’t access it.
This happens to me all the time. I get a request from a developer to overwrite the test copy of...
2013-10-16 (first published: 2013-10-09)
2,665 reads
T-SQL Tuesday #47: Your Best SQL Server SWAG
It’s time for T-SQL Tuesday again and this time Kendal Van Dyke is asking for Your Best SQL Server SWAG....
2013-10-08
747 reads
Use TOP instead of SET ROWCOUNT
Both TOP and SET ROWCOUNT are both valid methods of limiting the result sets from a query. They are however...
2013-10-10 (first published: 2013-10-07)
3,974 reads
Filtering Object Explorer
I absolutely love learning new tricks that can be done in SSMS. Everything from opening initial connections to both the...
2013-10-02
893 reads
The MERGE statement doesn’t have a WHERE clause.
What the heck? Even indexes have WHERE clauses these days. I can’t remember what I was reading when I saw...
2013-09-30
1,354 reads
Detaching a database
In my general quest to figure out the T-SQL to do common GUI tasks I did some browsing through BOL...
2013-10-01 (first published: 2013-09-26)
1,659 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
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