Script lists all overlapping jobs that ran on selected server within last @Hoursback hours.Basically, idea behind this is to find jobs that are running at the same time, because that might significantly slow down server, especially if you have jobs that are running during business hours. You can do the same by looking into Jobs […]
2004-01-02
556 reads
Lists objects from database. Similar to 'dir' command from DOS 🙂Typical usage sp_dir 't' 'order*', 1 - returns list of all tables whose name start with 'order' plus their columns and data typessp_dir 'p' 'custom*_sp' - returns list of all stored procedures whose name start with 'custom' and end up with '_sp'For list of […]
2002-07-19
416 reads
By SQLPals
Recently I have had to troubleshoot quite a bit of SQL login issues and...
By SQLPals
If your organization uses a password policy (there are very good odds these days...
Anecdotally any session_id that’s 50 or less is going to be a system session...
Comments posted to this topic are about the item Numeric and Decimal, which is...
I have been tasked with finding a new tool for Database Activity Monitoring. We...
Ask SSC