Brandie Tarvin (10/22/2010)

---

Hey,...

Well, that sucks.

We are coming from...

Here's the DelimitedString8k function that's been heavily worked on round these parts. Modify to suit your needs. I didn't create it, didn't work on it, and have copy/pasta'd...

WayneS (10/21/2010)

---

Craig Farrell (10/21/2010)

---

Ahhh, Cheap fun...

Going up to the SAN on Monday morning just before everyone starts needing to crank out work and hotswapping one drive in every RAID 5...

Alvin Ramard (10/21/2010)

---

That's not...

Ahhh, Cheap fun...

Going up to the SAN on Monday morning just before everyone starts needing to crank out work and hotswapping one drive in every RAID 5 array... just to...

You'll really want to get logs and tempdb off the same physical spindles if possible. There will be some heavy contention there if you don't.

By preference, data/logs are on...

fowl language

Of course, you could always have some fun with it...

Change the collation to Hebrew_CI_AI, Cyrillic_General_CI_AI, or Japanese_CS_AS.

Use a replacement cypher that only swaps to characters at CHAR(500) +...

Found the problem.

This specific line:

,ROW_NUMBER() OVER(ORDER BY p.PortfolioCode) AS POSN_KY_POS_ID

is causing the entire problem. Remove that line (and only that line, the converts were not causing an issue), and...

The attachment has flown the coup. Please reattach. 🙂

Both excellent ideas, and unfortunately went there already.

In regards to the first one I tried using count(*) instead of any column list to make sure I wasn't dealing with a...

Um, wha? What are you trying to do? As already mentioned, the answer is no, not exactly, though kinda yes, because non-clustered will include the clustered as a...

Oh good grief, my brain already hurt today. Now it's making a run for the border. Tequila, anyone?

A bit of additional information I neglected to include in the above discussion:

If I take the select statement directly out of the view and append the where clause directly to...