Hadn't thought...

I figured something along those lines, and agree it wasn't ideal to have it be a CHAR type to start with,...

Advertising aside, isn't it pretty irresponsible to...

Shouldn't you also disable the user in SQL? (making sure you aren't dropping the only sysadmin)

stebennettsjb (3/2/2011)

---

Does anyone know the release date of the book yet? Ive been excitedly waiting all though Feb for the book to come out in some format and here we...

I tried to rebuilt it, and it just sat there seemingly doing nothing for a couple of hours. I finally got to poking around and the folder/files that made...

Anyone know when this will be officially published?

Yep, it's running.

Will granting VIEW DEFINITION permissions work?

From BOL:

SQL Server 2005 collations can be specified at any level. When you install an instance of SQL Server 2005, you specify the default collation for that instance. Each time...

It has SA rights in SQL server, but are sure it has necessary rights/configuration to hit the Oracle data?

Geoff A (11/16/2010)

---

Why it is good is for performance. An index rebuild on a paused mirror will be faster than on an active mirror. And the replay of the log...

Jeffrey Williams-493691 (11/16/2010)

---

If your mirroing is setup in asynchronous mode, there is no reason to pause mirroring and resume it later.

However, if you are running in synchronous mode - you...

Just keep in mind thing like index rebuilds on large tables can cause a large amount of data to change, which in turn causes a large volume of data to...

Why do you think you need to suspend mirroring before you rebuild indexes?