Greg Edwards-268690 (1/11/2012)

---

Although the PI shirt, and knowledge to know the precision of the visual, and the ability to verbalize it accurately to such aforementioned precision, whether you bought it...

Yes, my apologies. This was scheduled last week and apparently I wasn't on 2012 time yet :w00t:

I had to choose between the "This statement is false" t-shirt, the...

Jeff Moden (1/10/2012)

---

Steve Jones - SSC Editor (1/10/2012)

---

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

Not sure, maybe one that can't be customized. You can't change rights on a server role.

I don't think so. This is a logged operation, so you can't do something out of band and then restart mirroring.

Role - Group in AD. It's a way of assigning permissions to an object, and then assigning particular users to the role/group and having them receive permissions.

In terms of securityadmin...

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