Very interesting approach. I never thought of using the templates. However from BOL

"The first time the template explorer is opened, a copy of the templates is

placed in the...

I would use msdb.dbo.sp_send_dbmail for mail within SQL Server. I've never heard of this being a security risk. Perhaps you dev team would like to clarify this.

We are currently building a new server with Windows Server 2008 whiich I believe will have 64 CPUs and 132 G of Memory. I think we maxed out. ...

The short answer is yes you can. But with respect to SSRS I would not install this on the cluster with SQL. I don't believe it is cluster...

I always ensure I am using Lock Pages in Memory. And if I was running a 32 bit version of SQL then I definiately would set max memory to...

What you need to know prior to the interview is what is the market is willing pay for someone of your skills in a position like what you are applying...

Make sure both databases have the same paramterization option (I assume that is FORCED)

Did you try to force parallelism like:

select a.empno,sdate,enddate,place

ecode1,ecode2,ecode3,ecode4,ecode5

into #dev2

from employee a inner join #empdts b

on a.empno=b.empno

inner...

You may find this useful: http://www.developer.com/db/article.php/3598891/User-Defined-Functions-Powerful-Alternatives-to-Views-and-Stored-Procedures.htm

Try using an inline function to paramaterize the view (pass in efdt and exdt for the 3rd select) For a sample search for 'predicate pushing' on

it is odd that your bad db is 1/3 the size of the good one and yet has worse performance. I keep thinkg SQL is generating a poor plan...

The statistics are based on the data so you can't "bring them from one database to another". You did say the tables were identical. To me this means...

Its interesting that its all tempdb work being done. I assume your tempdb is sufficeintly large. See http://msdn.microsoft.com/en-us/library/bb522472.aspx fro some help with BITMAP. You may...

if the databases are truly identical in terms of rows in each table and the defined indexes make sure that all statistics are up to date. SQL may generate...

Are both databases running in the same instance or are there 2 differnent instances? If they are 2 different instances then keep in mind they are both competing for...

do a search on this site for date formats and you find lots of entries that may help like:

http://www.sqlservercentral.com/scripts/Datetime+Manipulation/61393/

or in other sites like:

http://sqlserverplanet.com/sql/cast-date-with-no-time/

You may want...