Pad String
Pads a string on either with either leading or trailing characters. You specify the direction, the tolal string length and the character to pad with.Error conditions return null
2005-08-19 (first published: 2005-08-10)
2,070 reads
Scripts
Another data dictionary
Pulls relevant information including col. names, keys, and the description (if the description field is filled out).This makes a good source for a data dictionary report.
2005-08-17 (first published: 2005-08-12)
498 reads
Disable foreign keys
Ever need to disable some foreign key during the load of new data in some tables? (Eq: for a snapshot). The following just does that using a parameter (0 for disable and 1 for enable)
2005-08-15 (first published: 2005-08-05)
1,270 reads
Script to Generate DataDictionary for Database
This Procedure is used to generate the datadistionary for a database.It gives following columns : table_id, table_name,column_order,column_name, column_description Usage: Create the Procedure in the database where the datadisctionary need to be generated.Call : Execute Generate_getDataDictionary Return the result in Tabular format.
2005-08-12 (first published: 2005-08-05)
568 reads
Procedure to Search any sql Object
So many times I do not remember the name of table or stored procedure I have created, and it becomes time consuming to search object by firing query on sysobjects or search using Enterprise Manager.It is a simple Stored Prodeure where the Parameter is the Hint of the Object name and Object Type.It will fetch […]
2005-08-11 (first published: 2005-07-26)
168 reads
Finding All Index Info for Small Databases
This is a simple script which would list sp_helpindex information for all the tables in the database. You dont have to provide any table name or anything. Just run it on the database from which you want to retrieve the information.This is helpful when you have several servers running the same form of DB, and […]
2005-08-10 (first published: 2005-07-26)
202 reads
Index Information with column name in whole databs
Through this script we can fetch on regular index information with whole database. Here i am use temporary tebale concept show no procedure so its run quickly and also fetch information from production database in uptime. No sytem generate index information not send me.
2005-08-09 (first published: 2005-07-27)
214 reads
Remove decimal places without rounding
There was a script here not too long ago which showed how to 'truncate' a number to two decimal places without rounding. This used a lot of casts to varchars and back.The solution worked, but I knew there had to be a way of doing exactly this without having to go back and forth between […]
2005-08-08 (first published: 2005-07-27)
1,473 reads
usp_ToggleDatabases
usp_ToggleDatabases is a simple procedure that will switch the names of two databases.One of the main problems with using sp_renamedb to switch databases is that the procedure will wait until the database is free before the rename can be completed. If the new live database is also in use then there is a likelyhood that […]
2005-08-04 (first published: 2005-07-28)
504 reads
Replication PreScreen for proper Primary Keys
THIS TABLE WILL HODL YOUR TABLENAME AND UP TO THREE KEY COLUMNS FOR CREATING YOUR PRIMARY KEYSTHE OTHER COLUMNS ARE USED IN PROCESSING THE KEY'S AND GENERATING THE ALTER TABLE ASTATEMENTS TOCREATE THE PRIMARY KEYS FOR YOUR DB. THIS TOOL IS HANDY FOR PREPPING FOR A REPLICATION STRATEGY TO HELP YOU QUICKLY INDENTIFY IF YOU […]
2005-08-03 (first published: 2005-08-01)
386 reads
Blogs
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Asynchronous Replication of Snapshots from an ActiveCluster Pod to a Third Array
I’ve been rebuilding my three-site SQL Server demo lab, and I ran into something...
Forums
STRING_AGG DISTINCT
Has anyone written a wrapper function (or similar) around STRING_AGG() to allow the retrieval...
In-place OS upgrade or migration to new OS?
Putting this here as we're currently on SQL Server 2019 installed on Windows Server...
Never is Not the Policy
Comments posted to this topic are about the item Never is Not the Policy
Question of the Day
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_CustomerPhone
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.CustomerContact rebuildAfter I do this, what will I see for the index status? See possible answers