I have a requirement deploy transactional replication for an existing database which wasn't designed with replication in mind. I need to script/deploy based upon PK's, identity columns and timestamp columns. This query allows me to gather and save the information enabling me to generate the various scripts to replicate my database, replication through T SQL […]
2007-07-12 (first published: 2006-10-10)
786 reads
In real world production tuning sometimes a "quick fix" is required. This script will generate index create scripts for any column ending ID which doesn't have an index. It's dirty and its quick but you might just be amazed by the results when run against your database!
2007-07-11 (first published: 2006-10-10)
493 reads
In this post, I will guide you on how to deploy a dockerized simple...
By Kevin3NF
Everything in SQL Server is waiting for something…this is by design. And most people...
By DataOnWheels
Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...
SELECT * FROM sys.dm_db_persisted_sku_features If the result set has no records is it conclusive...
Comments posted to this topic are about the item The Subtle Differences Between COALESCE...
Comments posted to this topic are about the item SQL Server Collations
At what levels can we set the collation in SQL Server 2022?
See possible answers