Will this be hosted on enterprise edition? Alternatively phrased, can you use compression?

I would probably pre-size another filegroup to the correct size then rebuild the clustered and non-clustered indexes into...

You need to bear in mind that snapshots are almost a "temporary" backup. I wouldn't bother taking them in addition to normal backups unless there was likely to be...

Looks like you're trying to remove replication after having problems ( perhaps incorrectly doing something).

You can try these procedures to manually...

Normally after you add a new subscriber which needs initialising or you add additional articles to the publication. In the second case, only the new articles will be in...

That is pretty common and is down to some barely acceptable code (in my opinion) in the clean up procs. In many cases some of this code isn't even...

Different collations shouldn't be an issue.

What could be an issue is newer datatypes in use in the tables being replication. These cannot be replicated. Otherwise, I don't see a...

It depends a little on how much data is building up and if its causing an issue. In a high throughput distribution db you can have the replication cleanup...

r.dragoi-1095738 (10/31/2013)

---

Yes, and that's because your replication was setup to Replicate schema changes !

Just take a look to the properties of the replicated table and under Subscription Options you will...

Why can't you use a stored procedure or TSQL? What are your restrictions and why are they imposed?

It would appear to me that there is some misunderstanding somewhere.

Replication isn't really high availability and is probably the most complicated to maintain.

I've quickly scanned this thread and I'm surprised that no one has mentioned that this is one of the prime reason partitioned tables exist.

In this kind of situation I would...

Perry Whittle (1/9/2013)

---

DBA in Unit 7 (1/8/2013)

---

One node in our cluster had a hardware failure and comepletely down and need to rebuild. I am asking for advices/suggestions to get back...

How?

If you did this by TSQL using sp_addarticle then you still...

mrichardson 57577 (11/8/2012)

---

I am getting this error:

Error 15335 - is already in use as a object name...

when trying to rename a view in sql2005.

The view name does not appear in...

Brandie Tarvin (11/8/2012)

---

Koen Verbeeck (11/7/2012)

---

Lee Crain (11/7/2012)

---

I'm between jobs right now. I had an interview today for a contract position. The first question out of the Lead DBA's mouth was:

"Can...