Demon correct, but you can use the $Action on the output statement will show the action that was performed for that row of data.

You might get away with changing this to use a Recursive CTE for the Parent Child Relationship rather than a Join to iterate through the tree.

But I think the...

No problem, let me know how it turns out.

Its a nice script, I have a question wont scheduled Index Maintenance plans have the effect of showing up in the last_user_update?

You could also change the nested CTE to simply...

You can do a targeted Update Statistics on single tables, the BoL should help lookup the UPDATE STATISTICS TSQL page.

You can I beleive run an EXEC sp_updateStats in line as...

in a nutsehell yes, or at least look trying to split up the query so that its more manageable, I often find that complex queries will perform better if they...

Posted in error

Personally I would have thought...

Sounds like a badplan query plan or a case of Paramater sniffing not selecting the optimal plan for the paramaters.

Theres a simple way to test if its parameter sniffing,...

read the MS white paper located here http://msdn.microsoft.com/en-us/library/dd578580(v=sql.100).aspx (Page 43) for details on the sliding window concept that it appears you want to introduce.

As for moving the initial data over...

Ignore, mis read at the end of the day.

In the original example it may also because you have a round bracket instead of a square one at the end of the INTEGER key word.

CREATE TYPE [XyzUDT] FROM...

I would personally format the data in the front end tool as you are more likley to have better functions (pre 2012) to handle this, such as the vb/c#/RS, FORMAT...

I've heard the Accidental DBA is a very good book and frequently mentioned on these forums, Kalen Delaney's SQL Server 2008 Internals is another good book, and worth having ont...

Michael,

Sorry I meant the way you wrote the query, will over write the NULL value, if you do

Select Sum(1)

From Master.sys.objects

where 1=0

You will get a NULL cell returned, however...