I wrote this query that helps us find executed queries with most number of execution counts. The DMV that we have used in this script is sys.dm_exec_query_stats and the function that we have used is sys.dm_exec_sql_text.
2015-03-04 (first published: 2013-09-23)
5,157 reads
This script finds the size of all indexes in a database along with the table and the filegroup on which the index resides.
2013-10-15 (first published: 2013-09-23)
1,877 reads
Top 5 expensive Queries from a Write IO perspective
2013-10-03 (first published: 2013-09-09)
2,365 reads
The below written query helps us find the most expensive queries from a read IO perspective. The DMV that we have used in this script is sys.dm_exec_query_stats and the function that we have used is sys.dm_exec_sql_text.
2013-09-27 (first published: 2013-09-09)
2,624 reads
Recently I was asked to find all the Primary keys that are not clustered Indexes in the database. I constructed the below script which will help us to locate the primary keys in the database which are not clustered index.
2013-09-18 (first published: 2013-09-04)
1,926 reads
Use this script to find all the Foriegn Keys and their details in a database
2013-09-11 (first published: 2013-09-02)
1,423 reads
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Team, I'm trying to figure out what will be the best recommendation to configure...
Comments posted to this topic are about the item A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers