| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Count rows in all tables | SQL Server 2000, SQL Server 7.0 | Advanced /
russell dalton | 23731 since
3/7/2003 12:14:45 PM |
By 5 Users
4 Excellent Ratings
|
| |
It provides a row count of each table in your current database (or if you want, it can do the server). When you are tuning, this gives you a good start on where to focus attention. Also, for 3rd party products, it shows the tables that are not in use and ...(description truncated) |
| |
| |
| |
|
 Find out when a SQL Server Instance Started with udf_SQL_StartDT | SQL Server 2000 | Intermediate /
Andrew Novick | 8720 since
5/21/2003 8:33:27 AM | Unrated
|
| |
Sometimes you need to know when the Instance of SQL Server started. There are manual methods to find out but this article shows you a UDF that gets the information. |
| |
| |
| |
|
HELP SQL SERVER2000 | SQL Server 2000 | Advanced /
Assersoft | 6684 since
5/2/2005 1:57:50 PM | Unrated
|
| |
HELP IN SQL SERVER 2000. I'M FACING PROBLEM IN SQL SERVER 2000. CAN ANYBODE HELP ME.
|
| |
| |
| |
|
How to reindex all tables in DB in one statement | SQL Server 7.0 | Advanced /
Eli Leiba | 44462 since
11/1/2001 8:40:49 AM |
By 5 Users
5 Excellent Ratings
|
| |
reindex all indexes of all tables in one TSQL statement |
| |
| |
| |
|
Multiple VALUES insert | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
Fernando Pires | 179554 since
9/1/2004 4:45:50 AM |
By 12 Users
8 Excellent Ratings
|
| |
Use this little trick to INSERT MULTIPLE row values instead of using multiple INSERT statements to improve performance and typing. |
| |
| |
| |
|
sp_CatchProcesses | SQL Server 7.0 | Advanced /
Keith Henry | 14924 since
8/6/2002 4:44:46 AM |
By 5 Users
4 Excellent Ratings
|
| |
I wrote this for a bottlenecked SQL box working with some badly written 3rd party code that my company was unable to change. It quickly gives a breakdown of all waiting/blocked processes and what they are waiting for |
| |
| |
| |
|
SQL Database Defrag | SQL Server 7.0 | Advanced /
philip hannent | 19599 since
2/6/2001 8:36:31 AM |
By 10 Users
3 Excellent Ratings
|
| |
This code will organise the indexes on your database to improve speed. (Simple) (ScreenShot) |
| |
| |
| |
|
Stored Procedure to Reindex All Indexes With All DBs or Single DB | SQL Server 7.0 | Intermediate /
James Travis | 16965 since
5/22/2001 6:32:41 AM |
By 3 Users
2 Excellent Ratings
|
| |
The purpose of this procedure is to reindex all indexes in any given or all databases. |
| |
| |
| |
|
 The Best Columns to Index | SQL Server 2000, SQL Server 7.0 | Advanced /
Sherenato | 9060 since
12/23/2003 7:24:51 AM | Unrated
|
| |
Select all columns primary keys from <<table>> and return the best column index order.(ScreenShot) |
| |
| |
| |
|
To Re-index all tables in a database | SQL Server 2000, Other | Advanced /
Dinesh Mishra | 5590 since
9/19/2010 8:32:56 PM | Unrated
|
| |
In SQL SERVER 2005 due to continuous inserts and deletes in a table the index of tables gets slow (it gets fragmented). So to keep up the performance of index ok one needs to reindex all the tables in the database periodically. Here is the simple way. You ...(description truncated) |
| |
(ScreenShot)
(ScreenShot)
