LSTR() and RSTR(): Enhanced LEFT() and RIGHT()

Quite often I need to cut off the first (or last) few characters of a string. To do just that I created two functions LSTR() and RSTR().Syntax: LSTR( @stringtocut, @length )Note: @stringtocut is trimmed in the functionWhen @length is equal or larger than zero, this function performs the same as LEFT( LTRIM(RTRIM(@stringtocut)), @length ).When @length […]

Server Up-Time Information

Calculates server uptime in days, hours, and minutes.  Also calculates the UTC date (smalldatetime) when the server was started.

Get all user def table info

Get space for all user defined table information like size and row counts.

Delete Duplicates using CTE

Delete duplicates with a CTE (common table expression).This script uses the same setup as the anonymous post using a cursor (http://qa.sqlservercentral.com/scripts/viewscript.asp?scriptid=1872).

Table row count using 3 different ways

Three different ways that you can get the count of the rows in a table.

Verify Errorlog

Hi this is my first post on sql....The below procedure will check the current errorlog(past one hour errorlog will be scanned)for the keyword "error" (you can include your own key word) .. If you run the procedure it will look for keyword error in the past one hour... it will be use full for some […]

Function to Split a Delimited String into a Table

This function splits a delimited string (up to 4000 characters long) into a single column table. The delimiter can be specified at the time of execution. If not specified, the delimiter defaults to a comma. The default length of each value is 100, but that can easily be changed.An example for usage:DECLARE @string NVARCHAR(4000)DECLARE @instruments […]

Send SMS from a trigger

SQL Server 2005: Script all Indexes

Since it is not possible to script all existing indexes with the SQL Server 2005 Management Studio, here a small script to do this.

SQL Server 2005: Script all Primary Keys

Since it is not possible to script only the primary keys of all tables with the SQL Server 2005 Management Studio, here a small script to get the create scripts for all existing primary keys of the current database.