SQL – One Query to fetch SQL Jobs Details of All SQL Version – 2000/05/08/R2
Single Query to fetch complete details of sql jobs and you can run it across different version of SQL [2000/2005/2008...
2013-08-12
8,166 reads
Single Query to fetch complete details of sql jobs and you can run it across different version of SQL [2000/2005/2008...
2013-08-12
8,166 reads
This post is to find the database file usage details of all databases of an instance. The query runs on...
2013-08-06
1,923 reads
I’ve encountered a situation where I need to find out the database file,log file, total size and other useful information...
2013-07-25
4,601 reads
Most of the time we have been used to cmdlets and it’s various features but do not know about the...
2013-07-17
1,427 reads
This PowerShell script helpful in finding No of Processors, Speed and It’s current usage based on samples being gathered at...
2013-07-11
1,668 reads
Multi Server script to find OS and Memory details. It doesn’t require a text file as its input but you...
2013-07-09
912 reads
The requirement is to move the files to different server programatically and hence I’ve decided to use Robocopy in SQLCMD.
Robocopy...
2013-07-05
1,993 reads
Today I got a chance to retrieve configuration information of sql server 2005 instances. PowerShell provide a facility to read...
2013-07-02
1,142 reads
Different ways to find FreeSpace in all disk drives of a given server
T-SQLUsing WMIObjectCountersAll three methods are explained below
This post...
2013-06-27
1,513 reads
We had a situation where Application owners automatically notified whenever server restarts. The SP_PROCOPTION do have a facility to perform...
2013-06-24
1,601 reads
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Comments posted to this topic are about the item Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers