We just treat it like any other database, so whatever maintenance routines there are will also happen to ReportServerTempDB...

I would also get several coffees and a sandwich, and read Tony Davis & Gail Shaw on...

Eric M Russell (10/25/2016)

---

Marcia J (10/25/2016)

---

I remember in the late 80's saying that the 2-digit year would be a problem and getting the message from other programmers, "So what? ...

BLOB_EATER (10/24/2016)

---

jasona.work (10/24/2016)

---

Ed Wagner (10/24/2016)

---

Ed Wagner (10/24/2016)

---

Jeff Moden (10/23/2016)

---

Man, the spam is getting worse. The other morning, 41 out of 50 posts were spam. This morning is almost...

And then there are those that buy in third-party...

AIRWALKER-375999 (10/24/2016)

---

Hello,

I am using the code below to generate a list of current ages and the age in 6 months based on the date of birth:

SELECT PERSON_ID,

DOB,

DATEDIFF(YEAR,DOB,GETDATE()) AS [CURRENT_AGE],

year(dateadd(MONTH,6,GETDATE()))...

Luis Cazares (10/20/2016)

---

That's a weird requirement. What's the story behind this?

Here's a shorter alternative which I expect that might be a bit faster (not much).

WITH numbers AS

(

...

20 years ago...

...especially a 100MB network between two DCs a hundred+ miles apart...

Finally got the migration...

You could prevent that data from coming back to the report in the first place by doing something like:

WITH numbers AS

(

SELECT

...

Brandie Tarvin (10/19/2016)

---

ThomasRushton (10/19/2016)

---

Brandie Tarvin (10/19/2016)

---

ThomasRushton (10/19/2016)

---

rodjkidd (10/19/2016)

---

are...

Brandie Tarvin (10/19/2016)

---

ThomasRushton (10/19/2016)

---

rodjkidd (10/19/2016)

---

are you sure it...

Brandie Tarvin (10/19/2016)

---

Oh, oh, oh.

May I steal this...

rodjkidd (10/19/2016)

---

are you sure it wasn't ... would...

In other news, today I overheard m'colleague saying "maybe the DBA team would be a beacon..."

at which point I lost the plot.