For such scenarios, I also do the updates with a join only. I would be interested to see whether this approach has any performance implications, and what are other recommended...

You can go for the sliding window partitioning. See the whitepaper by Kimberly Tripp on this - http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx

you wouldnt have visited the advanaced options screens.

Try this -

create table #blah

(col1 int,

col2 varchar(100),

primary key (col1, col2)

)

check whether the service is up abd running and your server name or IP address etc.

see if this helps you http://rajanjohn.blogspot.com/2008/04/using-database-mail-in-sql-server-2005.html

How come "Yes" a wrong answer?

welcome SQL Server 2008, to our lives!! 🙂

Try using this one

http://rajanjohn.blogspot.com/2008/04/using-database-mail-in-sql-server-2005.html

I guess you mean to avoid the popup and take the login as whoever has logged into the machine. If so, work on the security settings of the browser you...

Good one!

then, where will the procedure cache come in?

Is there a way to run the configuration manager remotely?

if thats for buffer pool, how can we configure the max memory for the entire service?

I had near to 50 instances where SSRS and DB worked together. Nothing crashed in the last couple of years just because they are together.