Phil, I believe the key here is what you're allowed to put after the "AS OF".
"dd" is not a reserved word, as far as I know, and wrapping it...

whenriksen (12/21/2016)

---

Tally table provides the power of a rocket launcher with the labor of a pop cap.

I've put some comments inline. However, I don't have any temporal tables in...

This feels a bit dirty, but here's what I came up with:

DECLARE @Sql VARCHAR(max)

DECLARE @DateStart DATETIME

DECLARE @DateEnd DATETIME

SELECT @DateStart = MIN(SysStartTime)

,@DateEnd = GETDATE()

FROM SchemaName.TableName

SELECT @Sql =...

This certainly looks like it would facilitate what I'm trying to do. Thanks!

Also, great point on the UNION.

Vlad-207446 (8/17/2015)

---

I have a better question.

what if you go through all of this trouble and still need more space?

let say you know what you are doing, and before...

WOW !!!!

Talking about sparking ideas! I did not know you could do that with the calender control 🙂

Your printscreen made me think of some uses of my own!

If the code...

Theo Ekelmans (7/28/2015)

---

As requested, i made a quick standalone port of my Cpuload Warning graph query as a base for tweaking by you guys.

http://www.ekelmans.com/FTP/Web/GoogleCpuLoadInfoV1.0.sql

And a new version of the script...

I'd also love to see how you pulled in CPU/Disk I/O. Our current server host is having some disk issues, so it would be nice to show them when...

Thanks, Jeff, I'll be sure to look into these.

Thanks for the reply.

How would you filter out pertinent statistics so that only those which really need to be updated are affected?

I've ran successful backups before, and luckily our SQL...