Top Queries in SQL Server 2005
This article illustrates how to query dynamic management views to find the TOP queries based on average CPU and average I/O.
2008-04-09
6,335 reads
Articles
Inside The Question of the Day
A note from the editor on our very popular Question of the Day. Learn what it is, how it works, and what you can do to improve it.
2008-04-08
2,606 reads
SSIS – Transfer SQL Server Objects Debugged
A new SSIS developer finds a problem with the Transfer SQL Server Objects task. Join new author Stephen LaPlante as he digs through and discovers a bug in this task.
2008-04-08 (first published: 2007-04-26)
9,964 reads
Virtualization for Database Development
The trials and tribulations of our first attempt using Virtual Servers
2008-04-08
7,653 reads
How to Share Data Between Stored Procedures
Different ways of passing sets of data between stored procedures.
2008-04-08
7,906 reads
The Feature Debate
Is SQL Server keeping up with MySQL or is it the other way around. Steve Jones comments on a few of the differences in the platforms.
2008-04-08
43 reads
The Feature Debate
Is SQL Server keeping up with MySQL or is it the other way around. Steve Jones comments on a few of the differences in the platforms.
2008-04-08
30 reads
The Feature Debate
Is SQL Server keeping up with MySQL or is it the other way around. Steve Jones comments on a few of the differences in the platforms.
2008-04-08
38 reads
New Column Updates
What is the fastest way to update a newly created column in a large table? New author Bimal Fernando brings us a look at a technique he uses for just this situation.
2008-04-07 (first published: 2007-05-21)
7,756 reads
2008-04-07
1,800 reads
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
What's the Date?
Comments posted to this topic are about the item What's the Date?
Two New Shortcuts for Fabric Lakehouse Developers: The Fabric Modern Data Platform
Comments posted to this topic are about the item Two New Shortcuts for Fabric...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers