I believe that you will need to compress the nonclustered indexes separately to the tables.

Infact, just checked BOL:

The compression setting of a table is not automatically applied to its nonclustered...

Banzai

Congrats, really good score. I'm hoping to sit this soon, will really need to swat up on the XML side of things first.

Kyle Freeman (11/4/2010)

---

What do you recommend for study materials for

70-432

70-433

70-450

70-451

And I may look into the BID certifications as well....

I believe way back when I took the tests for 7.0,...

UMG Developer (11/8/2010)

---

Nice question, I would have gotten it wrong had the option for the problem with + not been there. (I didn't see the computed column so once I...

I can't believe people have actually clicked on "None of the above" 😀

Hi there,

I've amended your query to run across all databases on a particular instance:

/*Create a temporary table to hold all result sets*/

CREATE TABLE #Table

(TableID int IDENTITY(1,1) PRIMARY KEY CLUSTERED

,DatabaseName VARCHAR(20)

,LoginName...

Pretty sure it's just the one, out of interest why would you want two?

The following link explains about the role of the witness server http://msdn.microsoft.com/en-us/library/ms175191.aspx

I'd suggest that you ask this in the SQL 2005 replication section of the forum 😀

Orange book

Great article SS

Oracle?

Da-Zero, glad you found the question useful!

Hugo Kornelis (10/18/2010)

Oh, one final remark - if I should copy and paste your script in SSMS and execute it, I would actually get...

No problem

sp_configure will still work, it will be interesting to see what is disabling it, are there any startup stored procedures?