Obtaining Index Usage Information
This article shows how the sys.dm_db_index_usage_stats DMV can be used to tune your indexes, and maximize the performance of your database
2009-01-15
2,706 reads
Articles
Checkpoints in SSIS
Integration Services has a lot of features to enable to you perform ETL operations on data moving into SQL Server. Longtime author Dinesh Asanka brings us an article on
2009-01-14
12,208 reads
Configuring Anonymous Dialog Security in SQL Server 2005 Express Service Broker Conversation
Recent installments of our series have discussed configuring Service Broker full dialog level security, which required a mechanism to facilitate the exchange of certificates between communication partners. In this article, we will present an alternative approach, which eliminates this requirement by relying on anonymous dialog security.
2009-01-14
1,550 reads
Identifying Windows Volumes on a Clustered SQL Server Instance with the DMVs
I am trying to determine which of the logical volumes on the shared disk are associated with each SQL Server instance. Is there a simple method in T-SQL to determine this without having to fire up Cluster Administrator?
2009-01-14
2,392 reads
Open Source Pay
Steve Jones talks about salaries and whether or not there's value in disclosing them. Respond to this Friday poll.
2009-01-14
54 reads
Open Source Pay
Steve Jones talks about salaries and whether or not there's value in disclosing them. Respond to this Friday poll.
2009-01-14
90 reads
Open Source Pay
Steve Jones talks about salaries and whether or not there's value in disclosing them. Respond to this Friday poll.
2009-01-14
78 reads
The Hassles of Travel
As he prepares for a trip across the Atlantic, Steve Jones talks about some things he doesn't like about travel.
2009-01-14
64 reads
The Hassles of Travel
As he prepares for a trip across the Atlantic, Steve Jones talks about some things he doesn't like about travel.
2009-01-14
58 reads
The Hassles of Travel
As he prepares for a trip across the Atlantic, Steve Jones talks about some things he doesn't like about travel.
2009-01-14
71 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