2020-01-21
615 reads
DMVs
2020-01-14
617 reads
2019-12-30
584 reads
2019-12-23
710 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,045 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,163 reads
Blogs
Synapse Analytics and .NET for Apache Spark Example 4 - JOINS
By Ed Elliott
This is a bit of a longer one, a look at how to do...
Recovering Data from a Backup with SQL Data Compare
By Steve Jones
I had a customer recently ask about how to recover data from a backup...
Data Lakehouse defined
By James-Serra
As a follow-up to my blog Data Lakehouse & Synapse, I wanted to talk...
Forums
Median Processing time, Average Procesisng time for created/closed date
We have sharepoint as the data source and we have 2 dates created...
Live versus Stored Data
Comments posted to this topic are about the item Live versus Stored Data
Setting the Date
Comments posted to this topic are about the item Setting the Date
Ask SSC