Index Black Ops Part 2 – Page IO Latch, Page Latch
As I mentioned in my TSQL2sDay index summary post, the I am writing a few posts on the information that...
2010-09-16
3,101 reads
Blog Posts
Let PASS help you get a job!
With so many folks out there struggling and loking for new opportunities you may want to take some time away...
2010-09-16
331 reads
Notes from the Sep 13, 2010 oPASS Meeting
Jack led the meeting tonight, spending a good amount of time on SQLSaturday, and Kendal Van Dyke did his marketing...
2010-09-16
588 reads
Ready Set Go
I thought I would pass along something I learned this week about batches in TSQL. I always knew about the...
2010-09-16
375 reads
Rights for one table
I ran across a thread that was asking how to grant rights to a person for one table only, and...
2010-09-16
1,337 reads
See You at SQL Saturday #46 - Raleigh
EDIT: Updated to include a picture of me.
I'm headed up this weekend to speak at SQL Saturday #46 - Raleigh. This...
2010-09-16
827 reads
What is all that hot air? Oh I'm speaking all over the place!
Many of you have been wondering where I will be speaking next. So I apologize for not replying to you...
2010-09-16
487 reads
Baton Rouge SQL Server User Group Tonight
Last Night (9/14/2010) I had the opportunity to present to the Wisconsin SQL Server User Group. My topic was SSIS-...
2010-09-15
522 reads
Book Review: Blink: The Power of Thinking Without Thinking
I read Blink: The Power of Thinking Without Thinking by Malcolm Gladwell on a recommendation by Andy Leonard. Easy recommendation...
2010-09-15
939 reads
Index Black Ops Part 1 – Locks and Blocking
As I mentioned in the my TSQL2sDay index summary post, the next few posts will be on sys.dm_db_index_operational_stats and the...
2010-09-15
1,395 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