There are plenty of scripts out there that find duplicate indexes, but they all seem to use cursors. I didn't want to use a cursor so I ended up creating a few that could handle the duplicates and decided to share this one. This will return the table name and the names of the two […]
2003-12-04
2,721 reads
This script will generate a set of DBCC DBREINDEX commandsthat can be executed to rebuild the indexes. Additional information is provided to assist with sizing of the fillfactors.
2003-10-03
611 reads
I use this script on some (not all) databases to backup the Logs when they reach a certain level of being full. For example, when the log is 60% full the log will be backed up.Change the ????? values and this script is ready to go.
2002-10-03
564 reads
This script can be used on SQL Server 2000 databases. Some minor modifications are needed for SQL Server 7.0. This will report the DBCC SHOWCONTIG values for all the user tables, in all the databases on the server.
2002-10-03
470 reads
An Improved version of GetFileInfo that now includes the space utilization of each datafile. Provides more detail per file. Predict when your files are going to grow!! Both data and log files. This script organizes information about the database files on the server. A cursor is used to get the information from each database. The […]
2002-06-28
554 reads
This script organizes information about the database files on the server. A cursor is used to get the information from each database. The information is reported in Megabytes, including the next allocation from disk. No bells and whistles...and if I can find how dbcc showfilestats works I will add the amount of space used in […]
2002-06-24
1,100 reads
By Steve Jones
I was experimenting with a local model (article) and as a part of this,...
By Steve Jones
Redgate Monitor has grown tremendously from its early days and I find many customers...
The post Data Governance: The Invisible AI Accelerator appeared first on Joyful Craftsmen.
SQL Server 2022 16.0.4165.4 Windows Server 2022 Datacenter 21H2 20348.2849 Our Extended Stored Procedure...
We have a publication with three subscribers; it's basically a part list with around...
Hi Experts, I have database about 300GB in size with ADR enabled but after...
What types of database operations does the Data API Builder support?
See possible answers