Grant Fritchey (6/13/2013)

---

Stefan Krzywicki (6/13/2013)

---

The Dixie Flatline (6/13/2013)

---

Sean Lange (6/13/2013)

---

Steve Jones - SSC Editor (6/13/2013)

---

The Dixie Flatline (6/13/2013)

---

Brandie Tarvin (6/13/2013)

---

The Dixie Flatline (6/13/2013)

---

Don't talk to me about time. ...

The Dixie Flatline (6/13/2013)

---

Brandie Tarvin (6/13/2013)

---

Dixie, I could kiss you for this. @=)

By the way, does...

SQLRNNR (6/5/2013)

---

Sean Lange (6/5/2013)

---

Jack Corbett (6/5/2013)

---

SQLRNNR (6/5/2013)

---

Sean Lange (6/5/2013)

---

Jeff Moden (6/4/2013)

---

Brandie Tarvin (6/4/2013)

---

My Recovery Plan

1) SCREAM really loudly so everyone knows there is a problem.

2) Run out of...

SQLRNNR (6/5/2013)

---

Sean Lange (6/5/2013)

---

Jeff Moden (6/4/2013)

---

Brandie Tarvin (6/4/2013)

---

My Recovery Plan

1) SCREAM really loudly so everyone knows there is a problem.

2) Run out of the building as fast as possible.

3) Update...

I haven't used it, but based on TST1's answer you might want to look into Idera's SQL Virtual Database.

Sounds like there is a custom DLL referenced in the reports that aren't working the need to be upgraded to use the 2012 SSRS DLL's.

I used environment variables to set the connection string to my SSIS configuration database in my different environments (dev/qa/uat/prod). This is the most common type of use.

rodjkidd (6/4/2013)

---

Just got off a conference call, and the subject of DR came up.

The reply?

"well it would be nice, but we've never had any problems so far"...

I'm sure we've all...

Brandie Tarvin (6/1/2013)

---

Jack Corbett (5/31/2013)

---

Have I mentioned these 2 things lately:

1. I can't stand ORM tools and the queries they create

2. I can't stand when developers...

GilaMonster (6/1/2013)

---

Jack Corbett (5/31/2013)

---

So once we get a good amount of data in that table I'm pretty sure any index that doesn't have columnA as the leading column...

Here's part of the reason why I hate ORM tools and developers designing databases.

I'm trying to do some tuning, via indexing and I'm fighting with why a query that has...

Jack Corbett (5/31/2013)

---

Have I mentioned these 2 things lately:

1. I can't stand ORM tools and the queries they create

2. I can't stand when developers create databases...

Have I mentioned these 2 things lately:

1. I can't stand ORM tools and the queries they create

2. I can't stand when developers create databases without a data professional...

So you open the Table Designer, make your change, Script out the change to a new query window, and leave the table designer open?

My best guess would be that it...

Okay, then I'd go with something like what Nick has suggested.

If the report is calling a stored procedure I'd handle the logic for which query parameter is set in the...