SQL Server 2012 – Bug in sys.fn_xe_file_target_read_file?
So I finally managed to get my hands on a VM with Windows 2008 R2 SP1 so I could install...
2011-12-01
1,137 reads
Blog Posts
SQL Table variable and temporary table
Table variables and Temporary tables are used interchangeably – but they were designed for different purposes.
Temporary tables were designed for storage...
2011-12-01
1,757 reads
The Blocked Process Report
A few days ago, one of my customers asked if there is a possibility to get a notification
from SQL Server...
2011-12-01
5,590 reads
Using NOLOCK hint
Use NOLOCK hint to avoid block - this is what I have often heard/see in many forums I participate, during local...
2011-12-01
613 reads
Buffer Size in SSIS
Behind the scenes in SSIS, the data flow engine uses a buffer-oriented architecture to efficiently load and manipulate datasets in...
2011-11-30
16,621 reads
Convince me to read books (WHERE LEN(argument)
While you wait for my awesome upcoming blog on data exception notification with SSRS, let’s pursue a whim of mine.
I...
2011-11-30
1,671 reads
Day 30: More Fatal Errors and BUGs
Day 30 More Fatal Errors and BUGs
For sql server 2000 and earlier you may get 5242 and 5243 corruption in...
2011-11-30
2,127 reads
DBA in Space: Behind the Scenes—Question 8
Part 1 of Question 8—The question.Part 2 of Question 8—The follow up to the question.This is a continuation of my...
2011-11-30
1,846 reads
December 2011 LV UG Meeting
The Holidays are upon us. It is time to take a break from the hustle and bustle and come out to participate in the local User Group for SQL...
2011-11-30
4 reads
December 2011 LV UG Meeting
The Holidays are upon us. It is time to take a break from the hustle and bustle and come out...
2011-11-30
1,626 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