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.

are you running in mixed / nt / sql security mode ? (check in Enterprise manager / server / properties / security) If nt-security is enabled or mixed-mode , you...

dbo = dust between objects 😉

It is annoying that members of the db_owner group don't create dbo-objects by default. They are not adapted to always mention the object-schema, but if...

I guess problems with schema started when ms introduced a "everyone" schema : DBO.

Making a "transparant" option is a terrific way to mistify objects.

Backside of this implementation is (of course)...

my first impression :

"SELECT @sSQL = 'EXEC ' + @srvName + '.master.dbo.DatabaseSummaryInfo'" would mean you have defined all @srvName-servers as linked server on the server where you run the script.

I...

Use clustering indexes so a dbcc dbreindex also affects your datapages. check your fillfactor settings. run sp_statistics and updateusage to get correct numbers. check BOL.