Both #temp tables and table variables may or may not be created in memory or on disk - it's a matter of available resource.

Your use of one type of...

yes you can issue cross database commands -- I think you can handle the use command by executing script files using osql - which you can do from QA /...

There's no automated system to enforce change control on sql objects, whatever system you use will not stop someone making an edit to a proc through EM. It's a bit...

I'm not too sure you can do this.

Well I guess the application wasn't properly tested then ?

mail me direct and I can send some routines/code you can use to at least isolate your problems - the stuff...

This article should have been updated prior to re-publish as there are some errors and misconceptions contained within it. Sorry.

Your question is far too vague for a sensible answer. Try reading this book ( I know it's 2k but all principles apply )

http://www.compman.co.uk/scripts/browse.asp?ref=450145

To be honest if you don't...

I'd didn't think you could use express - but I see you can try this

http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

A DW will always be much larger than it's oltp database as it stores effectively point in time snapshots and is likely to be denormalised.

I disagree about dimension members -...

agreed .. never claim to be an expert .. you'll be immediately shot down - sql server is so vast you'll never know it all, and someone will always know...

absolutely, all depends. Star schema are easier to maintain and obviously less complex than a snowflake. I've used both , it's the end result that is important, if it requires...

yeah sorry I forgot the first column of my covered index was very selective, if the first column isn't selective enough then you're absolutely correct, the optimiser will ignore it....

Cool! if I get to attend, which is unlikely as I think I'll be on a new contract, I'll do my best to find you! I attended the one day...

excellent Jeff!

and a dba gains another grey hair !! 

Well originally covered indexes could be fussy about column order in the index matching column order in the select. It shouldn't make any difference and I've to date not found...