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...

Capt. Sigerson (1/10/2012)

---

A great little hidden gem, and thanks for pointing it out. One bonus of using synonyms (I've just learned) is the ability to GRANT or DENY privileges...

Great...

tommyh (1/9/2012)

---

I have never needed to store information about Timezones so excuse me if this is a stupid question. But wouldnt it be easier to store this in a separate...

A couple questions:

When you say refreshed, do you mean that all changes (ins/upd/del) at the source are transferred to the secondary site? Is it one shot, just apply the updates,...