I had this happen once, but when I tried to replicate it in a dev environment to try to trouble shoot it, I could not force it to repeat.

I was...

Hey Allin,

As it was previously mentioned if you are not storing PII and Credit Card#'s your requirments go way down.

...

My Bad, I was thinking Non-Clustered and Typing Clustered.

Jeremy was right.

and maintaining indexes does not change, what you would do for non-compressed you would do for compressed.

Here are...

Like Steve said the only disadvantage is if you are CPU bound, decompressing the pages when they move from the storage engine to the relation engine is where the CPU...

For Windows 2008 Clusters, Go to Failover Cluster Manager, Under the Virtual Cluster Name open Services and Applications, under that select your virtual SQL Server, Take a look...

Whate are your SLAs (service level agreements) - RTOs (recovery time objectives) and RPOs (recovery point objectives) for the databases?

I.E.

What kind of outage can they handle?

If...

I've used MOM and SCOM, as well as CMS with Policy Based management for some reporting aspect.

Unicenter, Netbackup, I3, and a little PDW.

I like Policy Based Management and SSIS, and...

Hey Shawn,

Your absolutely right. I didn't notice it till I scrolled down into the description a little further.

We use several 3rd party vendor app's here at Publix, because I...

It was DBA VC - Top 10 SQL Server Mistakes and Mis-steps. I'm sure the portion when Tim Ford actually presented would have been great.

http://www.sqlpass.org/Events/ctl/ViewEvent/mid/521.aspx?ID=484&KeyWord=&ChapterID=0&StartDate=8/31/2010&EndDate=&City=&Region=&LanguageID=0&CountryID=0&EventTypeID=0&TechnologyID=0&EventCategoryID=1

I've set up...

you need the witness for automatic failover.

Setting up the witness on the same instance as the mirror sets up a single point of failure. You must have a quorum...

Your right should have specified, HA. Mirroring is available in Standard however it is single threaded and High Saftey, the automatic failover option which would make it on par...

Server Level VS. Database Level Solution

Clustering is a Server Level Solution, if one node fails, reboots, shuts down, or is taken offline the resources owned by that node (if any)...

Here is the 1st link that appears on google when you search under "sql 2000 restore the master database"

http://msdn.microsoft.com/en-us/library/aa173515(SQL.80).aspx

it is the MSDN article from Microsoft.

In sql 2000 you must put...

Sourav-657741 (7/22/2010)

---

Hi Bradley B,,

Not sure, whether I need to reply to your response in front of the vast majority of users, however, kindly don't type such kind of questions. This...

Interview Question, Test Question, or do you actually have to do a restore?