Several months ago someone commented on a calendar thread that you should not even try to calculate Easter in SQL Server because the math was too hard. That got me to thinking and I decided to see if that was actually the case. I found that there are several well known algorithms available - but […]
2020-04-06 (first published: 2020-03-31)
5,111 reads
Know who all the individual group members are for a given WINDOWS_GROUP login. This script uses the sys.xp_logininfo procedure to find group members for each login on an instance. This is useful when attempting to remove orphaned WINDOWS_LOGINS. May have issues working across your logged in domain.
2020-03-23 (first published: 2020-03-13)
1,620 reads
Easily graph your storage needs based on msdb backup data recorded automatically, no matter what your backup solution is.
2020-03-17 (first published: 2020-03-10)
1,700 reads
This script will find all orphaned users on all databases on an instance, and generate a script to drop each user. Simply execute, copy the values from the DropScript column to a new SSMS window and execute. There are two risks with this script. Use with caution: This script attempts to take into account users […]
2020-03-16 (first published: 2020-03-13)
1,298 reads
The script searches through every column of every record in a database to find a value. It works with numbers too. Simply assign a value to @MyString. Indicate what datatype(s) you wish to search through, and indicate if you want wildcards, and execute. The search is smart and will only search through columns where @MyString is […]
2020-03-05 (first published: 2020-03-02)
1,173 reads
This script finds auto created statistics that duplicate existing stats generated by indexes, and may help to speed up your statistics maintenance. Copy the results from the DropScript column to a new SSMS tab and execute.
2020-02-21
517 reads
This script returns a list of all the fields of a table with it properties, primary keys and user defined types.
2020-01-21 (first published: 2014-04-30)
1,721 reads
Dropping database in RDS follows different method than dropping the database in local SQL Server. Below is the command to DROP the database in Amazon RDS EXECUTE msdb.dbo.rds_drop_database N'demodb' GO However when the SQL Server is configured with Multi-zone mirroring, then you need to set the partner to OFF and drop all active connections and […]
2020-01-17
3,801 reads
2019-12-20 (first published: 2019-12-10)
2,109 reads
T-SQL script to purge all the tables including foreign key references. The script has been made smart enough to use TRUNCATE wherever there is no foreign key reference and to use DELETE wherever there is foreign key reference.
2019-12-10
2,601 reads
By Vinay Thakur
Continued thinking about my Journey blog where we have to look back at the...
By James Serra
A ton of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
By SQLPals
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026) ...
Comments posted to this topic are about the item Identities and Sequences II
Comments posted to this topic are about the item Using PostgreSQL as a NoSQL...
Comments posted to this topic are about the item Is Your Time "Free"?
In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?
See possible answers