2020-01-21
643 reads
DMVs
2020-01-14
622 reads
2019-12-30
587 reads
2019-12-23
715 reads
DMV’s for the Beginner
I give performance presentations at many different events to all levels of SQL Server professionals. Over time I’ve noticed that some DBAs and developers have never looked at the...
The...
2019-05-15
Find Top 5 expensive Queries from a Write IO perspective
Top 5 expensive Queries from a Write IO perspective
2013-10-03 (first published: 2013-09-09)
2,219 reads
Find Top 5 expensive Queries from a Read IO perspective
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,313 reads
Blogs
Understanding Microsoft Purview Pricing
By Mr Fox SQL
Ever since its official launch around October 2021, Microsoft Purview has been one of...
Why I tweet about work and personal topics from the same account
Over the last few years, I’ve had a few people ask me why I...
Daily Coping 26 Sep 2022
By Steve Jones
Today’s coping tip is to enjoy photos from a time with happy memories. On...
Forums
things to do
In our lifes, we have manys things to do, many places to visit, many...
cursor to do update for multiple tables of a specific field
I am trying to scramble ID field in multiple tables in database. I created...
3616 Trigger Error when Calling Stored Procedure on Linked Server
I am updating a proprietary database using an SSIS package. From a web UI...
Ask SSC