GetSizeOfAllTables
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
172 reads
Script to create a standby database server(V 3.0)
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
276 reads
Script to create a standby database server(new).
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
264 reads
Script to montior ErrorLogs every 3 hours.
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 […]
2002-08-09
1,156 reads
Script to create a standby database server.
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
308 reads
Concatenate Rows without a cursor
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 […]
2002-07-02
1,006 reads
Take a Cold Backup without shutting down SQL.
Set the Autoclose database option to True and perform a cold backup of your data files without even shutting down the SQL Server Services.
2002-04-25
782 reads
Blogs
Containers: Create a Custom Container
Creating a custom container is where things get truly exciting. There’s actually a ton...
Mini-Rant: Spoofed Phone Numbers and Trust
By Brian Kelley
I’ve seen this more and more over the last year: I receive a phone...
Speaking at SQL Saturday Dallas
Speaking at SQLSaturday Dallas! I’m proud to announce that I will be speaking at SQL...
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
SQL Server health check
If I want to do a SQL Server health check, which aspects should be...
CPU?Memory and IO bottleneck check
Which indices will show cpu bottleneck?memory bottleneck and IO bottleneck? for example: which indices...
Ask SSC