Resource Governor clamps down on Greedy Reports
One of the things I run into every now and then is this provincial idea that reports can and should...
2011-10-10
1,301 reads
Blog Posts
Sometimes temp tables can be your best friend
Here is a quick example of when using temporary tables will give you a big performance gain. I recently was...
2011-10-10
881 reads
SQL Saturday 98 Follow-Up
I’ve been meaning to follow-up with links to the presentations that I delivered at SQL Saturday 98. It’s a few...
2011-10-10
580 reads
SQLBits9
SQLBits9 – “Query across the Mersey” was held in the majestic Adelphi hotel. This was my first SQLBits experience and was...
2011-10-10
895 reads
sys.dm_os_loaded_modules
sys.dm_os_loaded_modules is a SQL Server OS Dynamic Management View (DMV).
When executing the t-sql statement below – a recordset is returned . I’ve...
2011-10-10
2,413 reads
The PASS Summit is HERE!
Watching the twitter sphere it is apparent that many of the SQL Nation are in route to Seattle WA today....
2011-10-10
467 reads
PASS 2011 Countdown – Starting Now
Seriously, the clock is ticking and you should be in your car or a plane for PASS Summit by now. ...
2011-10-09
732 reads
An Informal Compendium of SSAS Errors, Part 4: SSAS Object Design
This is the third in a series of posts on some SQL Server Analysis Services (SSAS) errors for which there...
2011-10-08
2,190 reads
DBCC checktable
Instead of using DBCC CHECKDB , which checks on consistency and allocation across the whole database, an alternative is DBCC CHECKTABLE...
2011-10-08
2,701 reads
#SQLGive Update - New Dropoff Locations
Since announcing #SQLGive earlier this week I'm happy to report that two additional vendors have agreed to host dropoff boxes...
2011-10-07
841 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