Gives you a list with name of all the tables, number of rows, row length of each table, total reserved space, space used by data, space used by index and unused space.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2003-04-02

173 reads

Discuss

Script to create a standby database server(V 3.0)

by bodhayansharma

SQLServerCentral

Backup and restore

Use this script to create a warm standby database server for all your user database. This new version has a new feature to allow the standby database to be in a ready-only mode so that users can access it. You can change the job schedule to suit your requirement. One bug has been fixed that […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2002-10-31

278 reads

Discuss

Script to create a standby database server(new).

by bodhayansharma

SQLServerCentral

Backup and restore

New feature to relocate files on the secondary server has been added to this script. If you don't need this feature please use my other script that is posted on this website.Run this script on a secondary SQL Server to replicate the data of all the user databases from the primary server every 15 minutes. […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2002-08-09

265 reads

Discuss

Script to montior ErrorLogs every 3 hours.

by bodhayansharma

SQLServerCentral

Maintenance and Management

This script monitors your errorlogs every 3 hours for the past 3 hours. It notifies you by email for all types of errors and by pager for all critical errors with severity type > 16. Saves lot of time when you have to monitor several servers every day 24x7. Run this script on a dedicated […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

1 (1)

2002-08-09

1,171 reads

Discuss

Script to create a standby database server.

by bodhayansharma

SQLServerCentral

Backup and restore

This script will do a full backup and transaction log backup of all the user database on the primary server and restore it over to the secondary server. The full backup/restore runs once every day and the transaction log backup/restore runs every minutes. Just provide the name of the primary and the secondary server and […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2002-07-12

328 reads

Discuss

Concatenate Rows without a cursor

by bodhayansharma

SQLServerCentral

T-SQL

You might come accross a situation where you want to retrieve the values of all the rows concatenated and stored in one variable. Here is the solution. Lets say you have a table called tblCustomerOrders which has CustID and OrderID. You now want all the OrderIDs for a particular Customer to be stored in one […]