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
By DataOnWheels
My first time at SQL Saturday New York City was an absolute blast! Thank...
By Chris Yates
Businesses rely on data for decision-making and strategy, but data silos hinder productivity. These...
Hi, I have a workstation with SQL Express 2019 installed and I have a...
Hello - I have attached a Word document here with details about my issue....
I am having trouble writing linking the MAX query that I created back to...
If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?
See possible answers