hope you performed the sp_statistics after the restore/load in sql2000. Do you perform the "SELECT max ()" using an index ?

the ultimate wet dream would be getting this one sub-second 😉 I'd recomment on matching the indexes (clustered ? ) and trying to get them in ram (more than 2gb)....

the ultimate wet dream would be getting this one sub-second 😉 I'd recomment on matching the indexes (clustered ? ) and trying to get them in ram (more than 2gb)....

Pass conference (november) is very good. Almost no sales-blabla. Very good technical presentations and THE place to meet your peers and exchange ideas and experiances. Hope to go back this...

use this way to find out what exactly the problem is. Outerjoins in where clauses have troubled me more then once. Using the JOIN-sintax it solved my problems most of...

Jon,

be aware of the fact that UNION sorts out duplicate rows ! So if you know (like you said) "Records can exist in either table but won't exist in both...

If data does not exist in both tables on [year_month] basis you can avoid the outer-grouping from jpipes solution.

btw could you give a litle feedback on the percentage of...

Maybe if you replace columns thismonth and thisyear by convert(int, convert(char(6),getdate(),112)) as ThisYearMonth you could gain on grouping/sorting. You could also test performance with full-outer-join. (might be bit messy select-clause)

...

If you change db_owner, EM needs a full refresh (i.e. disconnect/connect) to get the correct info. EM is nice, but it has some leaps.

I guess this is a nice on where there is no functional need for NULL and a the (space) might be defaulted to (zero).

Supposing there is a tablescan needed...

views are mainly there for security reasons. I prefer to use views for frequently (to be) used joins, so join-predicates are predefined. Stored procedures on the other hand can provide...

OK, this all said. The quizz question was regarding EM. So for most of us points not won. btw that's not equal to points lost

It depends on the role the dba is supposed to perform. I my case I'd describe it as firefighting. Every day is a supprise.

I manage +- 60...

don't position yourself (with EM) at the model-db when you want to create a new db.

I guess because groups don't have a loginname. Add it to the ms-sql-wishlist.