sp_what
Better* than sp_who2, with less re-checking data to get answers. Also, it is SnaZy. With a capital Z.
*Dont you just love totally non subjective assessments like this?
2018-11-01 (first published: 2018-10-22)
2,554 reads
Better* than sp_who2, with less re-checking data to get answers. Also, it is SnaZy. With a capital Z.
*Dont you just love totally non subjective assessments like this?
2018-11-01 (first published: 2018-10-22)
2,554 reads
Will take a stored procedure and email the results in a dynamically generated embedded HTML table or as an attachment.
2016-12-05 (first published: 2015-05-29)
2,757 reads
This script returns the date for the most recent log/full backups and checks if a DBCC CHECKDB has ran within a week.
2015-07-23 (first published: 2015-06-23)
1,292 reads
This script simply returns the most recent restore information about databases for a server.
Returns the destination database name, the device used to perform the restore and the restore date.
2015-07-15 (first published: 2015-06-10)
710 reads
2013-12-06 (first published: 2011-01-31)
4,673 reads
This script uses the backup tables to get info on the growth of your database files.
2013-05-07 (first published: 2009-02-03)
12,894 reads
By Steve Jones
It’s been a good week at SQL Bits. This is my favorite conference, and...
V Joyful Craftsmen máme skvělý bonus (tzv. SGP), v rámci, kterého se můžeme vzdělávat v...
By HeyMo0sh
I love KQL so much I even made a video and if you compare...
Please suggest practice on SQL Server RLS On the database level, defined users with...
Hello, I have 3 SSIS packages having connection manager defined with a userA. These...
Hi Experts, What is 'optimize for ad hoc workloads' do mean in short? I...