Understanding the MERGE DML Statement in SQL Server 2008
This article about MERGE DML Statement in SQL SERVER 2008 and how to implements it and several examples
2008-12-08
4,161 reads
Articles
2008-12-08
488 reads
2008-12-08
736 reads
2008-12-08
518 reads
TechEd: 80 minute video of Corruption Survival Techniques presentation
A great presentation from Paul Randal of SQL Skills from TechEd 2008. Definitely worth the time to watch.
2008-12-08
5,046 reads
Using SQL Server DMVs to Identify Missing Indexes
I can run the Database Tuning Advisor or examine the query plans, but is there any easier way to determine which indexes may be needed?
2008-12-08
2,297 reads
Getting Close to Physical - Database Weekly (Nov 8, 2008)
The performance of virtual machines is getting closer and closer to that of physical machines with better software like Hyper-V.
2008-12-06
495 reads
Getting Close to Physical - Database Weekly (Nov 8, 2008)
The performance of virtual machines is getting closer and closer to that of physical machines with better software like Hyper-V.
2008-12-06
732 reads
Getting Close to Physical - Database Weekly (Nov 8, 2008)
The performance of virtual machines is getting closer and closer to that of physical machines with better software like Hyper-V.
2008-12-06
754 reads
Combine BottomCount() with Other MDX Functions to Add Sophistication
Discover, through a hands-on practice exercise, a more sophisticated business use for the MDX BottomCount() function, in combination with the Generate(), Descendants(), Ancestor() and other functions we have explored within our series. Join BI Architect Bill Pearson in this, the second part, of an extended examination of the MDX BottomCount() function.
2008-12-05
1,889 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