Fair enough Rev.

L' Eomot Inversé (7/12/2013)

---

Evil Kraig F (7/12/2013)[hrFrustration in the southwest due to a horribly porous border (that isn't supposed to be, like the one with Canada). Most of our...

Steve Jones - SSC Editor (7/12/2013)

---

L' Eomot Inversé (7/12/2013)

---

Personally I find it very hard to understand why, some years ago, the USA government/administration decided to instill into operatives in its...

Glad to know this article is still helping people out. 🙂

It's failing during the metadata check in the pre-compile, not during actual runtime. This is usually ran into when you're dealing with altered #tmp tables in repeated script runs...

You're on target Luis. It's a CHARINDEX and right command usage confusion.

OP, let's say you have this:

1234|1234567890

CHARINDEX (|) will = 5.

When you RIGHT(string,5) you get 67890.

What you need to...

First, I'd start with the basics... have you done a maintenance run for index rebuilds and statistics updates? Your messing with maxdop allows queries to recompile. Something may...

Lynn Pettis (7/1/2013)

---

Just dropping by to let you know where I am.

I made it to Bagram last night but looks like I get to hang out here another day (at...

I agree with David here, since it's a relatively simple paradigm and a direct order of evaluation you've got. Anything more complex would be overkill, as well as non...

Aaron,

Just in case you're not aware, best practice when allowing adhoc queries is to enforce usage of sp_executeSQL, because you can parameterize it and avoid injection attacks that way without...

bill.lawler (6/21/2013)

---

It appears the best practice is to have a single package configuration file name with instances of the the package configuration stored on each server. This may have been...

Sean,

It's an orgchart chain with the upper root level removed. You want to find the sublevel's highest association. Highest Association is decided by the lowest ID.

I just wanted...

Dird (6/21/2013)

---

Hi,

At work today I noticed that most of our SQL Server environments have the same setup:

2 disks in RAID 1

4 disks in RAID 5

The database config also follows this...

ekant,

If you continue to get stuck, one of the things that will help us the most is the .sqlplan. If you take a look in my sig, there's a...

Don't allow ad-hoc querying and restrict the...