GilaMonster (2/9/2010)

---

Um.... Take a look at the comments on the first page, take a look...

I have just come back from an interview where the interviewer asked me about DBCC timewarp and wanted me to describe the full syntax of all 137 required parameters (he...

presuming this is SQL2000....

under tools-wizards you have the index tuning wizard, create a standard profiler trace of normal activity on your server and run it through the wizard see what...

Krishna Potlakayala (2/8/2010)

---

george sibbald (2/6/2010)

---

do yourself a big favour, move the master log file back where it was with the data file. Master database has very little log activity being...

BOL and Google\microsoft.com

As far as I am aware SSMS is not cluster aware and you have to do a separate install of the workstation components on the second node.

you don't need to...

Also, in full production mode EEI-for-SPC produces so many dmp files in so many different space-time continuums that it requires 3 Oracle DBAs concentrating on it full time.

DBCC Timewarp can...

John, thats just perapatetic exogmatism.

At least SQL server is fully heterogenous with Oracles electro-encephalagraphic interface for SPC ( a cost extra I might add) simply by using the -T666 flag.

CirquedeSQLeil (2/8/2010)

---

nigel. (2/8/2010)

---

Oh yeah, plenty of s*** round here :-). Gotta make sure I use the right sample, or...

thanks for the clarification.

to my mind MS should have gone the whole hog and called 2008 R2 SQL 2010, would have been more consistent with past practices.

I understand the various...

Its possible...

Steve Jones - Editor (2/8/2010)

---

Actually I think this is the way to do. So many people have complained about features in SPs, myself included. I prefer SPs to be just...

GilaMonster (2/8/2010)

---

Because it's not a service pack. It's a set of add-ons for...

at least we now know why it was called R2 and not just released as SP2!

perhaps dbid > 4 as well to omit the system databases?