the 2008 links to MS' "what's new in 2008" seem to be broken. That said - here's a reasonable inventory of the changes by version:

http://www.c-sharpcorner.com/Blogs/15967/differences-between-sql-server-2005-2008-2008r2-2012.aspx

While I certainly find time calculus fun - I usually find it a LOt more readable to simply get there using date substraction, and pulling out the parts I need,...

and one last thing - none of your DROP TABLE statements are firing because there's an extra space in front of the name in the EXISTS.

as in

IF EXISTS (SELECT...

Typonese is causing your issue (look for the bolding):

-- #3 Table ------------------------------------------------------------------#3 Table

/****** Object: Table [dbo].[Orders] ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Orders](

[OrderID] [Int] IDENTITY(1,1) NOT NULL,

[CustomerID] [int]...

To add on to Lynn's comment: the two queries you posted aren't calculating the same thing. Let me give you a hint;; the FIRST query you posted...

Grant Fritchey (6/30/2015)

---

DBA From The Cold (6/30/2015)

---

Hey guys, going a bit off topic here but would like some advice please as I know pretty much all of you are writers/bloggers.

I've...

GilaMonster (6/26/2015)

---

The 'exit' statement that I made when I left the bank (after 4 years of working there and ~2 weeks of being intermittently belittled and insulted by some of...

here's ONE way to take on selectively "moving" certain subtrees. I am showing you a select version for you to compare - would be easy to flip it to...

a4apple (6/24/2015)

---

Matt Miller (#4) (6/24/2015)

---

well - I am not sure why you need to reload the entire table. The structure column can be built recursively, so pointing a given...

By the way - this smells a lot like an adjacency list, so I'd look at some of the fine work put together by Jeff Moden on this topic:

http://www.sqlservercentral.com/articles/Hierarchy/94040/%5B/url%5D

well - I am not sure why you need to reload the entire table. The structure column can be built recursively, so pointing a given node to a new...

Your view is apparently returning duplicate diagnoses. Not strange since you're looking at multiple activity dates, each of which might create a separate description of the diagnoses (thus duplicating...

sorry - just could not help myself 😉

Dave62 (1/28/2011)

---

Should scheduled maintenance be counted against your downtime SLA?

I try to avoid any controversy by making sure the vendor has included language in the SLA that specifies whether scheduled...

This is an optimization of what Steve was going after. The main insight is this: while you certainly could scan every 72-hour timeslice ever for this content (or every...