This article demonstrates how to use Extended Events to determine if a database is being used by someone or something.
Related Posts:
Finding Deprecated Uses in SQL Server November 7, 2016...
2019-07-22 (first published: 2019-07-03)
960 reads
This article demonstrates how to use Extended Events to determine if a database is being used by someone or something.
Related Posts:
Monitor Database Offline Events November 15, 2018
Audit Logons...
2019-07-03
10 reads
There are multiple ways of retrieving data from a table when you have a list of values. This article explores the use of the table value constructor.
Related Posts:
Correlate Trace...
2019-07-18 (first published: 2019-07-02)
631 reads
There are multiple ways of retrieving data from a table when you have a list of values. This article explores the use of the table value constructor.
Related Posts:
Finding Data...
2019-07-02
25 reads
I am humbled to be among so many great professionals and honored at the same time for having been chosen.
Related Posts:
How to be an MVP Book November 28, 2018...
2019-07-01
24 reads
I am humbled to be among so many great professionals and honored at the same time for having been chosen.
Related Posts:
Data Platform MVP 2020 August 12, 2020
How to...
2019-07-01
With this script, I have the ability to quick show which step is failing, what the command is for that step, what kind of process is running on that...
2019-06-27
42 reads
With this script, I have the ability to quick show which step is failing, what the command is for that step, what kind of process is running on that...
2019-06-27
Data professionals around the globe are frequently finding themselves occupied with figuring out why and when a file (data or log) for a database has changed in size. Whether...
2019-07-10 (first published: 2019-06-25)
303 reads
Data professionals around the globe are frequently finding themselves occupied with figuring out why and when a file (data or log) for a database has changed in size. Whether...
2019-06-25
154 reads
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Hello, I think I need a recursive cte query but unsure of the logic....
Comments posted to this topic are about the item The Security of Old Tech
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers