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,742 reads
New Author! Jeff had some questions about fill factors - but no answers! He did some work and came up with a set of recommendations for how and when to set your fill factors to something other than the default.
2003-11-20
10,343 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
619 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
573 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
476 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
573 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,129 reads
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Tlp/Wa_Cs:0817-866-887. Jl. Imam Bonjol No.18, RT.001/RW.003, Karawaci, Kec. Karawaci, Kota Tangerang, Banten 15115 @BCA...
Tlp/Wa_Cs:0817-866-887. Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa Barat 40261 @BCA...
Comments posted to this topic are about the item Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers