Using Excel As A Reporting Services Datasource
It’s been said that Excel is the poor man’s database. I don’t know about that, but I can tell you...
2010-09-15
907 reads
Blog Posts
An Index on Indexing #TSQL2sDay
Here we are with another T-SQL Tuesday and time for my entry into the fray. This month we are talking...
2010-09-14
717 reads
Brief Intro to Indexes and INCLUDE – TSQL Tuesday #10!
Content rating: Beginner
This blog was originally posted on December 17, 2009. I’ve pulled it out of the closet for...
2010-09-14
676 reads
Broken or Just Bent? #passvotes
Though things have died down a bit since the initial backlash, the recent development in the PASS board election process...
2010-09-14
693 reads
Common SQL Server Mistakes - Shrinking Databases
I don’t like there being an easy command to shrink databases, and I especially don’t like seeing the shrink option...
2010-09-14
5,633 reads
Failing Fast
I’ll have a longer post next week about my own risk strategy, but I wanted to write this first, both...
2010-09-14
613 reads
How is Fill Factor Impacting My Indexes?
The theme for this month’s T-SQL Tuesday is indexes so it seemed like the perfect excuse to blog about a...
2010-09-14
844 reads
How is Fill Factor Impacting My Indexes?
The theme for this month's T-SQL Tuesday is indexes so it seemed like the perfect excuse to blog about a script that I have written to see what choices...
2010-09-14
34 reads
How is Fill Factor Impacting My Indexes?
The theme for this month's T-SQL Tuesday is indexes so it seemed like the perfect excuse to blog about a script that I have written to see what choices...
2010-09-14
5 reads
One wide index or multiple narrow indexes?
Or “If one index is good, surely many indexes (indexes? indices? indi?) will be better”
This is a question that comes...
2010-09-14
1,575 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