I'd be inclined to ask those that insisted on a 'loop' for an explanation of what they mean. An example from them would be even better.

A place I used to work at had user-defined tables within the database, so users could expand the reporting beyond what was supplied as a default. So I've encountered the...

Don't worry about asking simple questions - we all ask questions at some point...

muthyala_51 (4/29/2015)

---

I tested with one distribution database with AG and mirroring. Everything is working as expected before and after mirror failover or AG failover. I think there's no need to...

muthyala_51 (4/22/2015)

---

BrainDonor (4/20/2015)

---

Gianluca is correct (not that anybody should doubt that!), so for such situations here we have scripts ready that will remove Replication and set it up again with...

We have three environments for Dev/Test/QA before anything hits Live.

Another DBA reviews all SQL code by the time it is in QA and it isn't given final approval for a...

Gianluca is correct (not that anybody should doubt that!), so for such situations here we have scripts ready that will remove Replication and set it up again with the new...

Because Replication only copies data from individual tables (each article is effectively a table) the Subscriber can have additional tables that Replication has no knowledge of.

We have Subscribers here that...

We have a couple of tables here where we create new partitions like that, but I haven't had to play with them yet.

One thing you may need to watch when...

Recently I had to change the partition schemes for several large tables (replicated too, just to add to the fun), so have done some of the things you'll probably have...

The Primary Key has to have the PartitionID column within it, as you've discovered.

I don't understand why you need to drop any Foreign Keys before the Partition Switch, or are...

It's OK - it took a while for me to understand it too - hence the blog article. I had to write it all out to understand it and see...

Matthew Darwin (4/1/2015)

---

Does that scheme not mean that data is actually required to be moved between partitions, rather than just the partitions themselves remaining static and then being binned off...

Matthew Darwin (4/1/2015)

---

Archiving and index maintenance are the two reasons I've been given, though I have an inkling the real reason might simply be wanting to try it out.

However, I...

We remove multi-million rows after a variety of time-periods on several systems using partitioning.

It isn't an easy thing to create for an existing system that already contains a lot of...