Extract default & Named Instance from @@servername
Extract default & Named Instance from @@servername.
Print all characters before and after \ to find default and named instance name.
2019-05-03 (first published: 2015-04-15)
1,129 reads
Extract default & Named Instance from @@servername.
Print all characters before and after \ to find default and named instance name.
2019-05-03 (first published: 2015-04-15)
1,129 reads
Extract SQL Server Name, Instance Name, Service Account details, startMode and ServiceState details with Powershell.
2019-05-03 (first published: 2014-10-13)
6,085 reads
If you want to extract only deadlock details, use the script.
2019-05-03 (first published: 2014-12-03)
3,786 reads
If you want to find TotalPages, Usedpages,datapages,totalspaceMB,UsedSpaceMB,DataSpaceMB then can use this query.
2019-05-03 (first published: 2014-12-26)
1,491 reads
2019-05-03 (first published: 2016-11-22)
771 reads
2019-05-03 (first published: 2015-03-29)
1,724 reads
Easy way to get the TLOg space Usage details
2019-05-03 (first published: 2015-11-19)
1,345 reads
If you have a requirement to carefully have the output file against each sql agent job step, you can use this script. If incase, there are many sql agent jobs and by any reason if any of the step does not have proper o/p file, this script can automatically create the o/p file.
2019-05-03 (first published: 2016-05-20)
1,417 reads
If you have a requirement to Kill all USer Sessions before starting to restore a Database, you may use this script
2019-05-03 (first published: 2015-07-08)
2,089 reads
The script will be helpful to kill all the user sessions before performing the refresh of the database.
2019-05-03 (first published: 2011-03-29)
2,615 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers