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)
789 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)
497 reads
By Steve Jones
It’s been a good year for me. With my sabbatical, I felt like I’ve...
By alevyinroc
In less than one month, I will be speaking not once but twice at...
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Powershell script to generate SQL...
Comments posted to this topic are about the item Database Ledger in SQL Server...
When Azure SQL Database was originally released, the MAXDOP was set to 0 for each new database. In Oct 2025, what is the default value for Azure SQL databases?
See possible answers