jeffwilson2 (6/25/2010)

---

Hi my name is Jeff.

I am new to this forum. About a year ago I started at a company and last year they upgraded to SQL 2005 and nearly...

Nick Walton (6/25/2010)

---

Thomas-282729 (6/25/2010)

---

DBA: A. Why is it my problem that someone else did not do a better job of planning ahead? B. why are you pulling one record at...

Everyone appreciates such specific criticism. It helps the author fine-tune his style, lists plenty of well-defined arguments that...

Steve-524674 (4/14/2009)

---

OK, the issue is simply one of coding style for the most part. The optimizer should handle "declarative" code [whatever that is] in much the same way that it...

Nick Walton (6/25/2010)

---

Thomas-282729 (6/25/2010)

---

There is an answer, but you probably won't like it: don't do it in a stored procedure.

If you cannot accomplish a given piece of work in...

I originally had two solutions to this problem...

Hi Mike

Nice change! I'll have to play around with it later. A couple of things to note:

* the - operator maps directly to the ifts AND NOT operator.

*...

Hi Marcelo,

The "or" issue was dealt with previously in this thread. If you go back a few pages you'll see the fix. The reason your query's returning nothing...

Interesting article. Apart from automating delivery of error messages and alerts, I've never considered using SQL Server as a mailing list server. I'm trying to think of a...

The focus on R2 seems to be more for BI-specific functionality, most of it peripheral to the database engine. I'd be willing to put the R2 database engine production...

Any day I can open my email and see a new David Poole article, I know it's going to be a good day!

Your comment made me think:

Jeff Modem made the...

Changing from VARCHAR(50) to VARCHAR(36) won't save space, but it will help keep people from inserting invalid strings that are 37+ characters into it. If you want to save...

Hey Barry

I'm going to play around with your code tomorrow -- looks cool. It almost sounds like you're describing a cross apply type operation for stored procs. That...

magarity kerns (4/19/2010)

---

Look, the question of what exactly to use for an algorithm is a far off tangent. The main idea of my article is to use the narrow...

Nadrek (4/19/2010)

---

Mike C (4/19/2010)

---

Nadrek (4/19/2010)

---

Mike C (4/17/2010)

---

Not sure how you calculated the probability of collision at 2^40 off the top of your head... You can engineer an MD5 collision...