SQL2k8, if the above didn't help you, can you make that into a CREATE TABLE and INSERT statement for us, so we can see exactly what you're seeing?

Jeff Moden (7/14/2011)

---

I...

Since sargability and index seeking are pretty much out the window, this should work for your join:

REVERSE( RIGHT( REVERSE( AddressCode), 9)) = ID

EDIT: Misplaced a parentheses.

Ignore this, massive blonde moment.

Jim Murphy (7/14/2011)

---

Instead, I think they should learn how to be an Operational DBA quick. Backups, test restores, disk basics/raid, checking logs, and then deeper and deeper. Eventually...

Find the missing...

Hey guys, does anyone know of boot camp training session(s) for SQL Server for practical skills (not certifications). I'm talking real basics here. I didn't see much when...

Um, no? It's against the NDA to provide dumps, and a braindump makes you useless to us because you don't grok the material.

Just an odd question, why would you do this?

If you're licensing by processors, like most do, and you're sharing space on the same system, you most likely have licensed the...

Eric M Russell (7/14/2011)

---

Yes, I can enforce any type of business rule inside a trigger, and I could also have my trigger make CLR function calls to authorize credit card...

Eric M Russell (7/14/2011)

---

If a primary key occurs in another table, then I most always create a foreign key relationship, and if there is a simple business rule that can...

You've looked at the software, now time to investigate the hardware.

There are four bottlenecks: Network, CPU, Memory, and Disk.

Network is unlikely here.

CPU is possible, especially if you're in VMs.

Check your...

I'd have to say I'm middle of the road for RI. I don't use it for every lookup under the sun, simply because of the secondary hits that are...

The old Raid 5 reads faster then 10 debate got squashed a bit ago. It's no longer the amazing gain it used to be. This is twofold. ...

bopeavy (7/12/2011)

---

I figured I would throw my 2 bit sense in here too. I do not think that the post are getting worst. What you have to remember is that,...

dhearne 25776 (7/9/2011)

---

You are right. SIMPLE mode certainly breaks the log chain. However, there is no reason to log 10 million deletes. Let's say I have taken my...