SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Kraai

SQLServerCentral.com profile

   Items 1 to 5 of 5   
 

SQL server Agent - Status

As part of the application to monitor SQL health I created. The procedure returns status of the SQL server Agent  Read more...
By Kraai 2016/04/29 | Source: SQLServerCentral.com | Category: sql server agent
Rating: (not yet rated) |  Discuss |   Briefcase | 538 reads

Get Space on SQL hardrive

I was recently asked to monitor the Database size on the SQL server, and display the results in a report.   Read more...
By Kraai 2016/05/05 | Source: SQLServerCentral.com | Category: space on hardrive
Rating: |  Discuss |   Briefcase | 716 reads

Pad length

Pad string with a lenght of characters at front or back  Read more...
By Kraai 2016/04/28 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 458 reads

Determine Easter Sunday

Determine what day easter sunday will be based upon the year you pass the function   Read more...
By Kraai 2016/04/25 | Source: SQLServerCentral.com | Category: easter sunday
Rating: (not yet rated) |  Discuss |   Briefcase | 386 reads

Format Date Time Function

Function do return common datatime formats of a date. select dbo.[KDT_FN_FORMATDATETIME]('LASTDAY DDDD',getdate())   Read more...
By Kraai 2016/04/26 | Source: SQLServerCentral.com | Category: datetime
Rating: |  Discuss |   Briefcase | 913 reads
   Items 1 to 5 of 5