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...

Since their current log drive is full, they are in a tough situation.

Without a DBA there, to me the safest thing to shrink is a temp db.

It could try to...

Possibly.

Since it is the Reporting temp db, if you have a lot of free space in it, I would go...

GSquared (8/2/2012)

---

Scott, as a post-script:

Don't assume that your opinion, unbacked by data, is going to convince people of anything. Repeatedly asserting "Erwin>Visio" without any sort of analysis at all...

Yes, I did. To repeat, separate...

GSquared (8/1/2012)

---

ScottPletcher (8/1/2012)

---

Stefan Krzywicki (8/1/2012)

---

ScottPletcher (8/1/2012)

---

I didn't think Visio even offered a logical data model (i.e. Entity modeling vs table modeling),...