Technical Article

Find Top 5 executed queries ordered by execution count

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.

4.75 (8)

You rated this post out of 5. Change rating

2015-03-04 (first published: )

4,715 reads

Technical Article

Primary Keys which are not Clustered Indexes in a database

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.

4.2 (5)

You rated this post out of 5. Change rating

2013-09-18 (first published: )

1,909 reads

Blogs

Friday Flyway Tips–Quick Command Line Access

By

One of the things I had to do recently in a demo was access...

A New Word: Aesthosis

By

aesthosis– n. the state of feeling trapped inside your own subjective tastes – not...

A First Look at Redgate’s Subsetter

By

I have been a proponent of subsetting databases in dev/test for a long time....

Read the latest Blogs

Forums

Cyber Insurance for War

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Cyber Insurance for War

High availability group synchronization

By sqlfriend

For high availability group, is there an option like transaction log shipping that I...

How to merge first 3 rows when exporting to excel

By SSCNewbee

Hi All, I have a report when I export to excel must auto merge...

Visit the forum

Question of the Day

Writing to Clones

I run this code on SQL Server 2019:

DBCC CLONEDATABASE(imdb, imdb_dev)
I then change to the cloned database, imdb_dev, and run some queries. I then run this code while testing:
INSERT dbo.Title (TitleID, Title, DateReleased) VALUES (3234, 'Maestro', '2023')
GO
What happens?

See possible answers