SQLServerCentral - Scripts by Prashanth Jayaram

Drive space checking monitoring procedure

This procedure can used to monitor the disk drive space details and we can set threshold and it can be enhanced to send an alert incase of reaching the threshold. Read more...

By Prashanth Jayaram 2009/07/07 | Source: SQLServerCentral.com | Category: disk space

Rating:

|

Discuss |

Briefcase | 1,831 reads

Splitting the string with unique delimiter.

The statement is splited into columns according the delimter and it has been captured in the table datatype. Read more...

By Prashanth Jayaram 2009/06/29 | Source: SQLServerCentral.com | Category: function

Rating:

|

Discuss |

Briefcase | 1,088 reads

Finding Execution Time of a SQL Statement

Capturing the execution time for rebuilding an index for set of tables. Read more...

By Prashanth Jayaram 2008/12/26 | Source: SQLServerCentral.com | Category: indexing

Rating:

|

Discuss |

Briefcase | 1,514 reads