I can find it if it was restored, but not if it was made...

rewrite the query to NOT use views and only the minimum amount of objects and the optimiser will most likely pick a better plan (if possible).

P.S. Check the default trace, I think it holds that information (except maybe who did it).

SELECT

DATEADD(D , 0 , DATEDIFF(D , 1 , GETDATE())) AS CreatedSince

, create_date AS CreatedOn

, *

FROM

sys.databases

WHERE

...

SQLRNNR (11/14/2011)

Ninja's_RGR'us (11/14/2011)

SQLRNNR (11/14/2011)

Ninja's_RGR'us (11/14/2011)

SQLRNNR (11/14/2011)

Ninja's_RGR'us (11/14/2011)

SQLRNNR (11/14/2011)

Ninja's_RGR'us (11/14/2011)

SQLRNNR (11/13/2011)

So, i checked my email and...

SQLRNNR (11/14/2011)

Ninja's_RGR'us (11/14/2011)

SQLRNNR (11/14/2011)

Ninja's_RGR'us (11/14/2011)

crookj (11/14/2011)

Adds a whole new meaning...

You mean aside from ddl change, performance, network overuse, column order change, performance, indexes being useless, not seing the list of columns when working on the code?

so aside from bad...

SQLRNNR (11/14/2011)

Ninja's_RGR'us (11/14/2011)

SQLRNNR (11/14/2011)

Ninja's_RGR'us (11/14/2011)

SQLRNNR (11/14/2011)

Ninja's_RGR'us (11/14/2011)

SQLRNNR (11/13/2011)

So, i checked my email and the blog...

SQLRNNR (11/14/2011)

Ninja's_RGR'us (11/14/2011)

crookj (11/14/2011)

Adds a whole new meaning to lip...

Those are estimated plans, we need to real (actual) plans. There's critical info in there to debug this.

SQLRNNR (11/14/2011)

Ninja's_RGR'us (11/14/2011)

SQLRNNR (11/14/2011)

Ninja's_RGR'us (11/14/2011)

SQLRNNR (11/13/2011)

So, i checked my email and the blog and didn't...

Any news? I thought this was urgent! 😉

Drop both reports on the server and redeploy. There's a bug about parameters in 2K5. I don't know if or when it was fixed.

Any reason why they can't do a copy of the db overnight (backup / restore).

Then during the day do everything AS begin tran, rollback tran so that they keep it...

Classic demand / mistake.

Either return the date of the first of the month or return YEAR and month in 2 separete columns.

Then sort by those values, but present the month...