Meme Monday January 2012
Meme Monday was pushed back this month to the second Monday of the month. That is a good thing or...
2012-01-09
561 reads
Blog Posts
Morning Checks - Forewarned is forearmed
It’s always handy to know if there any problems with your servers before you get into work in the morning....
2012-01-09
655 reads
Revised: Difference between collation SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS
This is a revised post of an original article that I first published in December. Even though I thought that...
2012-01-09
257,769 reads
S3OLV update and Reminder
We are now just a few days away from our first meeting of 2012. We have some good content lined up. Check it out here. I am looking forward...
2012-01-09
5 reads
S3OLV update and Reminder
We are now just a few days away from our first meeting of 2012. We have some good content lined...
2012-01-09
639 reads
SQL Server –WRITELOG and how to reduce it
SQL Server Books online defines the wait type WRITELOG as “Occurs while waiting for a log flush to complete. Common...
2012-01-09
1,270 reads
Surrogate Keys
When building a data warehouse, it is important that primary keys of dimension tables remain stable. To accomplish this, it...
2012-01-09
3,962 reads
What I Will Do For You in 2012
Many of you have first hand experience of our phenomenal sql community (affectionately labelled the #sqlfamily).
Your first encounter with it...
2012-01-09
600 reads
SQL Server - Global temporary tables
Global temporary table:- Global temporary table is created in the tempdb and it is visible to all other sessions as well. Global...
2012-01-07
48,465 reads
SQL Server - Local temporary table
Local temporary table:- Local temporary table is created in the tempdb and it is visible to the current user's session...
2012-01-07
8,716 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