This script will allow you to find all instances of a column name, or partial column name, in all user tables in the database in which it is run. This is sometimes helpful during upgrades, etc. There is no error checking in this script. You can modify it to add, if needed.Run this by simply […]
2004-06-21
200 reads
This script will help in removing the duplicate values from a table.
2004-06-15
326 reads
This SP gets all the table names with the column names and data types, datalength. All the existing constrains on the table and column levels along with the Primary and foreign keys and table references
2004-06-01
253 reads
Captures all SQL Logins at the server level with password and spid unchanged into a sql script. Nothing fancy just needed it to do a server move and load into QA.
2004-05-25
2,076 reads
If we give SP_HELP , we'll know to which File Group the table belongs.If we give SP_HELPFILEGROUP , we'll know the logical and physical file names along with other information that belong to the given File Group. But have you ever tried that, given a file group, how to find all the tables that belong […]
2004-05-10
145 reads
This script can be used as a trigger to limit the number of versions for a particular document
2004-05-07
125 reads
This procedure, sp_who3, is based on the system-supplied sp_who2, but is modified to return the actual text of the commands executed by each spid. Very helpful for troubleshooting! In addition, I have added a @hostname parameter to allow the user the option of viewing activity originating from only one computer, if desired.
2004-05-06
673 reads
While the other methods for calculating holidays ect use a table to store the holidays, this inline UDF goes the opposite route, by returning 1 if the given date is a weekday that also does not fall on a number of holidays. Examples shown allow for easy extension to other holidays as deemed necessary.
2004-05-02
208 reads
For greater information of this tool can obtain it inhttp://www.dimac.net/Mail in format HTML or TEXT can be sent can be sent attached archives. It is a tool to send and to receive electronic mail from any PC or SERVER without the use of a program of mail or a mail server as Eudora, Exchange or […]
2004-04-20
1,418 reads
This script backs up all databases or a specified database to a disk location. Databases can be explicitly excluded from backup as well. Can be used for Full, Differential or Transaction Log Backups. Can also dynamically create sub directories for each database, as well as perform DBCC and restore verify operations. Includes LiteSpeed support for […]
2004-04-15
1,503 reads
If you spend your days tuning queries, managing pipelines, or keeping a production database...
I’ve been rebuilding my three-site SQL Server demo lab, and I ran into something...
By SQLPals
SQL Server gMSA: Why DBAs Still Aren't Using It in 2026 ...
Comments posted to this topic are about the item Never is Not the Policy
Comments posted to this topic are about the item Automating SSAS Multidimensional Security Audits...
Comments posted to this topic are about the item Rebuilding All Indexes
I have added a few indexes to one of my tables in SQL Server 2025:
ALTER TABLE dbo.CustomerContact
ADD CONSTRAINT PK_CustomerContact
PRIMARY KEY (CustomerID);
-- Create index on CustomerEmail
CREATE INDEX IX_CustomerContact_CustomerEmail
ON dbo.CustomerContact (CustomerEmail);
CREATE INDEX IX_CustomerContact_CustomerEmail
ON dbo.CustomerContact (phone);
I then do this to disable one index:
alter index IX_CustomerContact_CustomerPhone on dbo.CustomerContact disableI see this when I check the index status:
I decide to rebuild all indexes with this command:
ALTER INDEX ALL ON dbo.CustomerContactAfter I do this, what will I see for the index status? See possible answers