SQLServerCentral: Scripts

Credit Card Number Validation Escalar Function

Evaluate credit card numbers based on ISO 2894 algorithm. Read more...

By thor the viking 2010/03/24 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 37 reads

Index usage overview

This view reports almost everything you want to know about your indexes Read more...

By Wilfred van Dijk 2010/03/23 | Source: SQLServerCentral.com | Category: index

Rating: (not yet rated) |

Discuss |

Briefcase | 210 reads

Password to Phonetics converter script

This script will display phonetics for a given password Read more...

By Vijay Anisetti 2010/03/22 | Source: SQLServerCentral.com | Category: phonetics

Rating: (not yet rated) |

Discuss |

Briefcase | 79 reads

Check status of HEAP tables

This SP reports the status of your heap tables. It gives you an overview of fragmentation, ghost record counts and forwarded record counts. Another reason to create a clustered index! Read more...

By Wilfred van Dijk 2010/03/18 | Source: SQLServerCentral.com | Category: administration

Rating:

|

Discuss |

Briefcase | 547 reads

Truncate Table Partition command in SQL Server

This script helps with the truncate Table Partition command in SQL Server Read more...

By Adeoye Omoboya 2010/03/19 | Source: SQLServerCentral.com | Category: partition

Rating: (not yet rated) |

Discuss |

Briefcase | 308 reads

Automated T-Log Restore

Sequential transaction log restore Read more...

By Tony Savoie 2010/03/15 | Source: SQLServerCentral.com | Category: t-log

Rating:

|

Discuss |

Briefcase | 503 reads

EXECute SQL Commands over entire sets of parameters!

A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas. Read more...

By RBarry Young 2010/03/16 | Source: SQLServerCentral.com | Category: admin

Rating:

|

Discuss |

Briefcase | 1,112 reads

Script to check current identity of Tables

Used to check all current identities on all user tables Read more...

By Sean Kotze 2010/03/17 | Source: SQLServerCentral.com | Category: identity

Rating:

|

Discuss |

Briefcase | 622 reads

Rebuild partition

Rebuilds online a table partition with all indexes Read more...

By fediori 2010/03/12 | Source: SQLServerCentral.com | Category: rebuild

Rating:

|

Discuss |

Briefcase | 481 reads

Clustered Index Analyser

Analysing clustered indexes on user tables by looking at the columns that comprise them Read more...

By Cameron Wells 2010/03/11 | Source: SQLServerCentral.com | Category: indexing

Rating: (not yet rated) |

Discuss |

Briefcase | 983 reads

Backup or Restore progess

This procedure provides you the progess of the database backup or restore. We can execute the procedure to find the remaining time for completion of the backup or restore. Read more...

By Purushotham Kumar Katakam 2010/03/05 | Source: SQLServerCentral.com | Category: backup/ restore

Rating:

|

Discuss |

Briefcase | 723 reads

ServerProperty query with case function

Returns all properties from ServerProperty, also has a case function for EditionID and EngineEdition. Read more...

By Jon McGhee 2010/03/08 | Source: SQLServerCentral.com | Category: administration

Rating: (not yet rated) |

Discuss |

Briefcase | 537 reads

Unused Objects in the Server

This Script is used to List out the objects lying in the box which were un used from the day of the sql server recycled. Read more...

By Purushotham Kumar Katakam 2010/03/09 | Source: SQLServerCentral.com | Category: administration

Rating: (not yet rated) |

Discuss |

Briefcase | 888 reads

Track database growth

Script to keep track your database growth - Works with SQL 2000, 2005 & 2008 Read more...

By Irwan Tjanterik 2010/03/10 | Source: SQLServerCentral.com | Category: database growth

Rating:

|

Discuss |

Briefcase | 1,687 reads

Retrieve numbers from a string

This function will take a string parameter and find all numbers in it. Read more...

By Boyd Tyrrell 2010/03/04 | Source: SQLServerCentral.com | Category: string manipulation

Rating:

|

Discuss |

Briefcase | 1,279 reads

SQL Server Access Restriction

Restrict Access to SQL by HostName, IP, Application Name, etc... Read more...

By Gregory Ferdinandsen 2010/03/03 | Source: SQLServerCentral.com | Category: security

Rating:

|

Discuss |

Briefcase | 1,015 reads

Missing PK and Clustered indexes

This script will find missing PK and Clustered indexes Script or Heap Tables Read more...

By G T 2010/02/25 | Source: SQLServerCentral.com | Category: clustered indexes

Rating:

|

Discuss |

Briefcase | 854 reads

Changing Foreign key names to standard naming convention across the DB

Rename the Foreign keys to standard notation - FK_childTable_ParentTable Read more...

By Vidyadhar Pandekar 2010/02/24 | Source: SQLServerCentral.com | Category: change foreign key name

Rating:

|

Discuss |

Briefcase | 700 reads

Changing Primary key names to standard naming convention across the DB

This script will rename the Primary keys to standard notation - PK_TableName Read more...

By Vidyadhar Pandekar 2010/02/26 | Source: SQLServerCentral.com | Category: rename primary key

Rating:

|

Discuss |

Briefcase | 754 reads

Serial ID Auto Generation

Scripts used to create the functionality to auto-generate your very own customized serial IDs. Read more...

By Larry Sumuri 2010/02/22 | Source: SQLServerCentral.com | Category: serial id

Rating:

|

Discuss |

Briefcase | 1,037 reads