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
1,222 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
478 reads
By Steve Jones
immerensis – n. the maddening inability to understand the reasons why someone loves you...
In this post, I will guide you on how to deploy a dockerized simple...
You can now run powerful LLMs like Llama 3.1 directly on your laptop using...
Dear All, In one of the server its repeatedly restarting sqlserver services and not...
Comments posted to this topic are about the item Understanding CROSS APPLY and OUTER...
Comments posted to this topic are about the item Database Files on Shares I
I want to store database files on a file share for a SQL Server 2017 instance. Can I use \\fileserver\D$ as a location?
See possible answers