Will -

It won't work in 2000 (thus my "for those on 2005" warning). I am just leveraging the pseudo-graphical editor they built into SSMS to do that. ...

I don't know about what your process is - but all of the built-in encryption functions, even the ones in 2005, are wholely inadequate for storing Credit card info.

You're going...

here's another trick for those in 2005.

1. write the statement with SELECT * in it

2. highlight the code for that one statement, then right-click on it and pick "design query...

Are index rebuilds really necessary nightly? As Paul Randal pointed out in another thread recently, nightly is usually WAY overkill, and just creates a lot of activity for little...

What is up with having this in your WHERE clause?

(-1 = 3)

That's always FALSE - so why include it?

Here's an UNPIVT example:

select iasmtID, sum(case when answer=1 then 1 else 0 end) as countOfOnes,

sum(case when answer=2 then 1 else 0 end) as countOfTwos

from

(

select iasmtid,question,answer

from...

good one - no doubt about it. I hadn't yet seen the merry-go-round in action, but it does make sense now.

From what I've seem, the OVER syntax, and the...

Keep in mind - the various methods mentioned aren't necessarily contradictory/ or exclusive. In cases where DRI is paramount for me, and I want to make SURE I don't...

Business Intelligence Platform is a BusinessObjects product - not Microsoft. Are you referring to BIDS (Business intelligence Dev Studio?)? If so - yes - you should be...

The issue is - it is allowed because certain "legal" queries require the ability to use values from the outer query in the inner query. They're called correlated subqueries.

for...

Well - now that you have SQL server doing your file maintenance - any chance you can figure out how it can turn the coffee on in the morning?...

you're essentially right in how it works, but it's by design.

During the resolve phase, it's going to try to resolve the field names in the sub-query by itself. Once...

Holly Kilpatrick (1/30/2008)

---

Yes, at that link it does give the 4/8/08 date for the various editions, but for SQL 2000 SP4 it does not, it says until next service pack...

Well - it's likely not going to use the clustered index to do seeks because of the <>. That being said - you may get it to use a...

Kill the cursor - no doubt about that. multiple updates launched against a 48M row table, should more than likely be avoided.

Also - looks to me that you'd end...