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
585 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
417 reads
By Rayis Imayev
(2020-Jan-28) This blog post is a followup to my previous post about DevOps (CI/CD) for...
I wrote a short blog post about the misperception that Profiler was easier than...
If you read the title to this post and your first thought was That’s...
Im an Oracle DBA by trade and been tasked with setting up transaction replication...
Hi Experts, Currently we are using SQL Server and Database Mail to send reports...
Hello Team, I am using DMV dm_db_index_physical_status to replace the DBCC is sql server...
Ask SSC