There's no specific "binary search", since a search which uses an index IS a binary search (that's what a BTree structure...

Perhaps I am being dense, but the entire purpose of TRY...CATCH is to change behavior. Now, I could understand if you don't like HOW it changes behavior, but I...

GPO (7/3/2010)

---

So (sorry for sounding dumb) how do you handle situations where the data has a significant level of sensitivity and you want the DBA to manage it, but not...

The answer IS one. Each table can only have one in SQL Server.

The underlying reason for it is that the clustered index becomes the logical storage order (logical...

Brandie Tarvin (7/1/2010)

---

Thanks, everyone. I appreciate your assistance. Looks like I'm stuck with cursors still, but I'm well on my way to a solution.

Soon as I verify it, I'll write...

Steve Jones - Editor (6/28/2010)

---

Officials will make mistakes, and that's acceptable. We deal with that on a weekly basis as adults playing baseball, and accept it. It happens.

However when you...

It's hard to even support that claim (the "dodgy...

Sorry to say, but from what I am reading here, you won't be able to build CLR using this edition:

Features in the Visual Studio Premier Partner Edition

The Premier...

dbatodd (6/14/2010)

---

Dang, How did I know that "Depends" was coming. The main reason to store on SQL is so our clients can do some data mining looking for key...

Jeff's got the whole swiss army knife on this approach:

http://www.sqlservercentral.com/articles/T-SQL/63003/%5B/url%5D

Jeff Moden (6/12/2010)

---

randy rice (6/12/2010)

---

Matt - yes, that would work, and now that I think about it, for what I'm doing may be a more appropriate way than RPCs. ...

A simple DTS package would do it. Seed a SQL source with the stored proc, point it at the remote DB's table, and hten - schedule it.

Matter...

You're going to need the speed...

CirquedeSQLeil (6/10/2010)

---

Grant Fritchey (6/10/2010)

---

Whoa! Hold on a sec... you got a ring? I didn't get a ring. If I had a ring...

ditto