Oh, I absolutely agree! Seems like MS has been making a lot of changes to things, lately... most of them boil down to removing some "feature". Case sensitivety...

Actually, I don't think it was a "simple mistake"... I think it was a cost cutting measure. It doesn't take nearly the code to make something case sensitive at...

15 million rows per month isn't much. Instead of looking for a hardware solution to a software problem, the best thing to do would be to follow the suggestions...

My first question would be, why do you have a join to the Location table when you're not selecting anything out of it? Are you just using that as...

I've found Zero applications that actually require case sensitivity... If I ever do, I'll change the collation on the columns that do rather than setting the whole database for it....

Heh... you live on a "farm", Steve... you know what it means to "close the barn door after the cows got out."

Without knowing what the 7 tables are, I'd say that's the better choice than trying to store it all as XML both from a design/maintainability aspect and a performance aspect.

Try this link... also, do a search on "SQL SERVER TUTORIAL" and "T-SQL TUTORIAL"...

http://answers.yahoo.com/question/index?qid=20080229151637AAfb5Gu

Thanks, Anirban!

I absolutely agree. Steve Jones recently wrote an article asking the quesiton "Why do you write"? One of the reasons I pointed out was the incredible amount...

Actually, "It Depends". You can trick it... see the following...

http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

The problem is that the stored procedures you're calling have been written to only handle 1 section at a time. Usually, the only way to use such a thing...

Actually, the real reason why I write is because... I can't remember stuff no mo'. 😛

Carl Federl (5/10/2008)

---

Tried Jeff Moden's suggestion to use "context switching" but I cannot get this to work based on three schemas and a dbo schema stored procedure, where the schema...

Thanks for the feedback and the code you posted. What version of SQL Server are you using? I might be able to turn a treat for you...[/quote]

Jeff,

We're...

ALZDBA (5/10/2008)

---

Jeff Moden (5/9/2008)

---

Mine's a nice little ol' man's bike... Honda VTX 1300 S (retro with spoked wheels) and something I love dearly... shaft drive. Took me a long...