Clustering will take care of the issues you are facing with performance. however you could consider setting database mirroring to high performance mode than high safety. Clustering is expensive but...

Assuming you want to learn, the best free book out there is MSDN.

SQL Server internals is great to understand the under the hood workings of SQL Server and http://www.tomcarpenter.net/2009/09/25/sql-server-2008-book-title-change/ for...

My guess is your not going to find a lot of people answering this post. Please do your own research and get back in case you have some areas you...

Try using a DDL Trigger.

http://msdn.microsoft.com/en-us/library/ms186406.aspx

Yes

the only scenario I can think of where you would face performance issues after a trace if the Trace has taken up a lot of disk space as part of...

The 2 editions are worlds apart. Express edition is the free downloadable version and enterprise editions is the fully functional ( all bells and whistles) version.

Depending of what your trying...

I ve had a good week if it leaves me relaxed and looking forward to the next one. As long as things r moving in the same direction...

I wud go with the instead of trigger if this wasnt a frequent activity. else i wud create a new column called is modifiable. and update it with 0 just...

http://sqldb.wordpress.com/2006/06/23/deploying-an-analysis-services-database-into-the-production-environment/

this wud be a good place to start. you should understand each option and decide which is best for you.

have u tried refreshing the service , the status doesnt always automatically change

what does the service show when look at from the services.msc console

Which service is this , mssqlserver or...

divide by zero , and two different servers .... what happened to basic tshooting skills ?

If your syncing the two table...

I have used redgate source control , TFS and SVN

TFS, -- not very user friendly but extremely powerful , links sourcecontrol to other aspect of s/w dev like...

TempDB can grow to such levels but shouldn't remain at this level. All temo tables are dropped at the end of the session that created it

If your temp table is...