Dynamic Management Views and Functions aren't always easy to understand. However, they are the easiest way of finding out which of your stored procedures are using up the most resources. Greg takes the time to explain how and why these DMVs and DMFs get their information. Suddenly, it all gets clearer.
2011-01-31
5,532 reads
Use sysindexes\DMVs insead of select count(*) to retreive table row counts
2011-01-28 (first published: 2009-09-02)
57,816 reads
31 Days of SSIS
It’s Sunday afternoon and a good time to be putting up post twenty-three for the 31 Days...
2011-01-28
2,863 reads
At last, my blog is starting to pay real dividends. Not only do I get the opportunity to publish my...
2011-01-28
2,054 reads
When Fabiano agreed to undertake the epic task of describing each showplan operator, none of us quite predicted the interesting ways that the series helps to understand how the query optimizer works. With the Merge Interval, Fabiano comes up with some insights about the way that the Query optimizer handles overlapping ranges efficiently.
2011-01-28
3,071 reads
A new series of courses is available from SQLskills to help you better learn to manage and tune your SQL Server instances. These classes are designed to help you complete the MCM certification, but are also valuable for anyone that wants to become a better SQL Server DBA.
2011-01-27 (first published: 2011-01-10)
2,064 reads
The next webinar from SQLServerCentral will look at backups and how you can create faster, smaller, and verified backups. Join Steve Jones and Rodney Landrum for this presentation on SQL Backup Pro and SQL Virtual Restore
2011-01-27 (first published: 2011-01-18)
1,926 reads
31 Days of SSIS
Today, we continue on with the 31 Days of SSIS blog series. Yesterday’s post was on the...
2011-01-27
2,042 reads
Learn how you can connect to a SQL Azure database.
2011-01-27
1,945 reads
This question comes up constantly in different venues. I see it sometimes 2-3 times a day on SQL Server Central....
2011-01-27
3,653 reads
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Comments posted to this topic are about the item Have you done a Mid...
Comments posted to this topic are about the item From SQL Server On-Premises to...
Comments posted to this topic are about the item Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers