Reputation
9,385
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
20 74
Newest
 Good Answer
Impact
~352k people reached

Aug
27
awarded  Good Answer
Aug
19
awarded  Revival
Aug
14
awarded  Nice Answer
Aug
4
awarded  Nice Answer
Jul
24
answered when can AG primary replica be a different host to WFC primary?
Jul
24
answered Why are these two HADR DMVs reporting different states?
Jul
22
comment SQL Availability Group restore database to standalone server
You're welcome, glad I could help.
Jul
21
answered SQL Availability Group restore database to standalone server
Jul
2
comment Is there a cool way of performing CU updates for SQL Server on hundreds of machines?
What are your allowed outage windows on those machines? Can you take outages anytime you want, or do you have to do schedules for specific machines? Are clusters involved? Mirroring and replication? AlwaysOn Availability Groups? Batch jobs that might need to be stopped, like backups or ETL load jobs?
Jun
29
comment How can I add a rowversion column to a large table with minimal downtime
@datagod yep, look at the number of rows in the deleted/inserted tables in the trigger, and skip the activities if they're near to the number of rows in your batch.
Jun
1
awarded  Enlightened
Jun
1
awarded  Nice Answer
May
31
revised Partitioning visitor logs database
Fixing tags
May
26
awarded  Enlightened
May
13
awarded  Revival
May
11
awarded  Necromancer
May
11
awarded  Revival
Apr
23
comment What are valid usage scenarios for HEAP tables?
One slight tweak - if you do a SELECT INTO in order to create a quick backup of a small table before you make a change, a heap gets created by default. I'd say that's a valid use - but that's just nit-picking. I'd want to get rid of that heap as soon as I knew my work was done.
Mar
18
comment Which databases can meet these replication requirements?
@dc2 exactly, speghettidba is right on. There's no one "right" way to do a design like this in MSSQL. It's like asking, "Can I build an app that does ___?" Modern RDBMS's have all kinds of features built in, including the replication features we're describing, but it's still up to you to combine those features, architect them, and load test them with your loads and hardware in order to get to the right answers. In theory, this design works great. In practice, it's a multi-million-dollar project. (I've been on these.)
Mar
15
comment Which databases can meet these replication requirements?
No, publishers are the original source of the truth, and they pass the list of replicated data off to distributors. Can MSSQL support all these things? Sure, but think about licensing: Standard Edition is ~$2k USD per CPU core. The project you describe would be millions of dollars just for licensing alone, even before hardware.