To me that is vastly better than...

I think you avoid all the CROSS APPLYs, as below.

As written the code just ignores anything beyond 24 hrs, but if you needed to, you could add a check for...

?? Not sure I follow. Applications should be completely unaware of any filegroups in SQL...

Edit: Removed, repeat.

You should use a trigger to trim the data during INSERTs and UPDATEs -- NEVER let poorly formatted data be queried directly from the database.

Personally I don't see anything wrong...

Since the table already contains the previous year's YTD totals, would a simple LEFT JOIN suffice to get the prior year's YTD total?

SELECT

t1curr.cod, t1curr.[year], t1curr.[month], t1curr.value,...

GSquared (12/14/2009)

---

Even in cases where the data type precedence won't cause a problem, I find the Coalesce version below much easier to read, understand, and maintain,...

Any of that seems like overkill to me for the specific problem stated. Why not just?:

SELECT

name,

ISNULL(MAX(CASE WHEN type = 'typeB' THEN...

winston Smith (8/28/2012)

---

A clustered index is in reality the table, organized by the clustering key.

But you can make a clustered index based on only a small number of columns in...

Make sure the statistics on all tables are up to date -- obsolete statistics could cause SQL to choose the wrong type of join.

Of course SQL sometimes chooses the wrong...

You should be fine with a single table provided you cluster the table by:

( [Time], MnemonicId ) --if I understand Mnemonic id correctly, as the original telemetry data src

Uniqueidentifiers are...

Looks to me like there is an explicit DENY of CREATE VIEW permissions somewhere.

DENY will override/"cancel" an equivalent GRANT.

Kenneth.Fisher (8/20/2012)

---

Ya'll are making the assumption that the problem is ReportServerTempDB. It's entirely possible that 400 GB is the correct size for it and there are databases that are...

It should be, it's a temporary work db, just like tempdb :-).

You don't need to take a log backup if the db is in simple recovery model -- indeed, you can't: SQL doesn't allow a log backup to occur while the...