I'll be up in the Boston area (Dedham) this weekend... any Threadizens up that way want to get together? Maybe lift a cold one somewhere?

Sorry for the late response... I'm just getting caught up on some newsletters where I've been too busy to read.

I think that you did a great job in this article,...

L' Eomot Inversé (6/20/2012)

---

Life has suddenly changed. Our daughter is in hospital and very unlikely to come out again. We originally thought it was something that that would...

Brandie Tarvin (6/19/2012)

---

WayneS (6/19/2012)

---

Brandie Tarvin (6/19/2012)

---

I am putting a team together to develop the next best thing in mobile computing. The device will be called Cheese and the OS will...

Brandie Tarvin (6/19/2012)

---

I am putting a team together to develop the next best thing in mobile computing. The device will be called Cheese and the OS will be called Wine...

Stefan Krzywicki (6/18/2012)

---

WayneS (6/18/2012)

---

Ladies, Gentlemen, and Threadizens of all shapes and sizes! Come one, come all for the latest news of the day!

Me, your humble dba, from out of the...

Evil Kraig F (6/18/2012)

---

WayneS (6/18/2012)

---

I'll be starting the new job in a couple of weeks. I'll be a DBA with a small company that some of you'll in the northeast...

Ladies, Gentlemen, and Threadizens of all shapes and sizes! Come one, come all for the latest news of the day!

Me, your humble dba, from out of the blue, happened to...

Thank you Patrick... It is due to responses like yours that makes me want to do this.

Qure link

I hope so, but you have me wondering... I show it as "upcoming"... are you seeing it somewhere?

10 billion rows... very impressive.

So, let's take a look at your where clause:

WHERE T1.REC_CODE <> 'O' AND T6.ENGINE_TYPE = 'J'

T6 = CAEP9_NOISE_STRINGENCY_ROUND2_S5.dbo.AIRCRAFT_REPLACEMENT_2020_05, and you're doing a table scan on...

Okay, I missed the "simple" ... I think Jared has it.

INSERT INTO #Backups

([CalendarDate], [ServerName], [DBName], [RecoveryModel], [IsTlogShipped])

SELECT TOP

(DATEDIFF(DAY,CONVERT(VARCHAR,@FirstBackupDate,102),GETDATE()) + 1) DATEADD(DAY,ROW_NUMBER() OVER (ORDER BY [CalendarDate]) -1, @FirstBackupDate) AS [CalendarDate]

,@ServerName

,@DBName

,'D'

,@IsTlogShipped

FROM [dbo].[Calendar]

WHERE @RecoveryModel IN ('D','L')

UNION ALL

SELECT TOP

(DATEDIFF(DAY,CONVERT(VARCHAR,@FirstBackupDate,102),GETDATE()) + 1) DATEADD(DAY,ROW_NUMBER()...

Lynn Pettis (6/13/2012)

---

WayneS (6/13/2012)

---

Gotta love it when my messed up solution (unused cte) actually worked and solved it.

... Actually, I just plain forgot to remove it. I think they...