| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Count rows in all tables | SQL Server 2000, SQL Server 7.0 | Advanced /
russell dalton | 23653 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 | 8670 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 | 6656 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.
|
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
How to reindex all tables in DB in one statement | SQL Server 7.0 | Advanced /
Eli Leiba | 43687 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 | 179068 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 | 14873 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 | 19518 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 | 16818 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 | 9015 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 | 5507 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)
