sp_dropserver should help you

http://msdn.microsoft.com/en-us/library/ms174310.aspx

Do you mean that you want to take all data to a two digit value? What do you do with 1.5 or 0.6? I assume that 20000 becomes 200, or...

calvo (1/10/2012)

---

My second point would be that performance enhancers not only ... enhance performance (sorry) but they also improve recovery time (I have no hard data for this claim. It...

calvo (1/10/2012)

---

That's a good discussion. Pete Rose's ban from the hall of fame was justified (in their minds at that time). Now the real can of worms comes when you...

sjs-36273 (1/10/2012)

---

Steve - I like where you are going with creating a snapshot of a mirror but isn't a snapshot read-only? How can I make it writeable? This...

cengland0 (1/10/2012)

---

mtassin (1/10/2012)

---

Oracle supports storing timezone with dates.

http://docs.oracle.com/cd/B14117_01/server.101/b10759/functions179.htm

Using the portability defense really isn't a good idea... each DB server is different enough, that queries that can run on all of...

As Richard mentioned, check sp_spaceused and perhaps manually run dbcc updateusage.

Also, don't depend on autogrow. Monitor and grow the db as needed, in large chunks that will get you through...

If you want your secondary reset, then replication is not the choice, nor is SSIS. My misunderstanding of the refresh was the way it was worded with other choices being...

Heard back that it's these operations online.

- Index rebuild with LOB

- Adding a non-null column with a default

No, it does not. Active - Active provides two instances working on separate databases that are in no way...

I'd have to dig around, and it's hard to even know what the current version of the bill might change, but in one of the revisions there was a place...

Good for Larkin.

BTW, we report for first practice Sun. For once we're ahead of the big leagues!

No idea, I'll ask around.

Mark-101232 (1/10/2012)

---

Ninja's_RGR'us (1/10/2012)

---

Gianluca Sartori (1/10/2012)

---

Very annoying. I think the random words are meant to trick search engines.

I don't know which countermeasures can be taken, if any. I would be extremely...

SQL Kiwi (1/10/2012)

---

The site is usually pretty good at handling spam reports so my personal view is we don't need moderators, in general. Judging from an automated out-of-office email...