Should be in Zip.

I wouldn't mind doing so but I don't have a host for the file at the moment and trying to paste a 249KB, 5005 line XML output of the plan...

When looking at the execution plan, clicking on the index spool, and viewing properties - is it the output list that should be used to construct the index, or is...

Beh, got what I needed - tried to avoid using this method but seems like only thing could find reference to work. Opened SSMS, opened object explorer, connected to SSAS,...

Something like this: http://bennyaustin.wordpress.com/2011/03/01/ssas-dmv-queries-cube-metadata/

Only for 2005. $system cube does not exist. When trying to manipulate to put information about my cube in I am running into failure after...

Prices are evil, but the product is priceless 😉

Price goes up, the more you want to protect that product you purchased and get the most out of it. Thanks for...

Just a bit curious if there are any changed thoughts on this based on price known now.

I am looking to go from 2005 to 2008 R2 (before the 1st) for...

.

The best DBA out there cannot account for other people. Even if a DBA does not know what is going on, this would present a learning ability to push to...

Not sure if the "Just ask" approach was used at all, but it has its' place. Sometimes a non-technical approach will get results. Hopefully there is a limited list of...

Table valued functions, yes, not scalar/inline.

Thanks for the thoughts on it. The devil is in the details, and unfortunately this is more strategics for what could potentially come. The...

I do live dangerously but not carelessly, and the reason for re-architecture is as such:

The current data warehouse is made up of two tables. DimDate, and a flattened out "Item"...

Could skim through SQL agent jobs execution time for anything that ran around that time if applicable. There might be a 2 day trend in activity for one job that...

Sorry, must have missed. Lots of stuff to read through! Probably glazed over a few.

A table variable is not always used the same way for the rest of the query. Maybe you have the 10K row count or maybe 2 row count in memory,...