Since we're into contratulating everyone - Barry, I GOT to say - love the new Avi pic! It reminds me of a skit by Eddie Izzard, called Jeff Vader...:)...

Grant Fritchey (11/22/2008)

---

Terribly late to the party, rude of me, I know.

I agree with Steve, it seems to come in waves. It is a bit shocking that people think that...

Lynn Pettis (11/20/2008)

---

Jeff Moden (11/20/2008)

---

Adrian Nichols (11/20/2008)

---

I wouldn't say that makes you...

Very nicely done indeed! Congrats Jonathan!

vp0401 (11/21/2008)

---

Once again thank you for your reply.

I would have loved to upgrade directly to Sql 2008, but my company has already purchased 2005 licenses, hence we are going...

I was trying to see if I could do this without using the running count trick, and here's the ugly thing I came up with:

with cte1 as (

select row_number() over...

I've seen instances where the garbage collection isn't aggressive enough, so some good old fashioned

disposal of objects before letting the garbage collection have to handle it....

There are also instances...

I think in a way - we as a community tend to (inadvertantly perhaps) encourage the behavior. On many other similar sites, ask even a well-formed simplistic question, and...

Well - depending on the reporting, you may not want to open the door up. For example - my "reporting" data is actually simply a restored version of production,...

I don't know if Steve's got some other magic link - but some of them look to be available via amazon.com:

http://www.amazon.com/s/ref=nb_ss_gw?url=search-alias%3Daps&field-keywords=%22SQLServerCentral%22

Strangely enough - the newest one seems to be marked...

I would try setting this up to use sp_executeSQL, and passing parameters to it. the passing of parameters makes it substantially harder to get away with something.

jcrawf02 (11/13/2008)

---

Peso (11/13/2008)

---

Chirag, even if there is a clustered index on the table, it doen't mean that records are stored physically in same order.

I know Itzik Ben-Gan has demonstrated this...

Now you're changing the type of question. The two can't be looked at separately, since you're trying to make sure the combination exists. It's not whether each vailue...

Graham.Okely (11/12/2008)

---

Would you expect any node of the cluster to be available during a failover?

Would you exepect that it tracks what is happening and processes that data once it is...

You're not applying the distributive logic rule correctly. the rule is:

NOT (X AND Y) = (NOT X) OR (NOT Y)

So your criteria is supposed to be:

WHERE

(myLetter <> 'A' OR...