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,157 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,157 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,911 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,584 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,402 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,639 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
899 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,981 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,118 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,497 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,586 reads
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
This book was making its rounds on social media, and the concept seems interesting...
Comments posted to this topic are about the item Ingesting Data From REST API...
Comments posted to this topic are about the item Separate Reads
Comments posted to this topic are about the item The Hash Join I
What are the two inputs called to a hash join operation in SQL Server? (choose 2)
See possible answers