sqlservercentral-622386 (9/15/2011)

---

If you want to avoid the perfromance problems of using GUIDs as keys, and you do your security properly, then use sequential GUIDs which are already built into SQL...

Thanks, after reading up on READ COMMITTED I ran into the table hints READPAST and UPDLOCK. Based on BOL it sounds like these hints were created for "work queue" scenarios...

If you're referring to the comment by...

Nice article! A suggestion to improve readability. If you have a table valued function which can split a delimited string then you could do the following at the top of...

That seems to work. All the same tests work after making that change and removing my workaround.

Yes, I meant to say the problem was with the parser. I tried words ending in OR like "Victor" and it seems to work fine.

Very cool. It's exactly what I needed. I'm implementing a search and didn't want users to have to learn FTS syntax. Thanks for your work.

I'm running into a problem with...

Adam Machanic (9/23/2008)

---

Just keep thanking your lucky stars that they didn't choose EF... Here's a thread someone sent...

Thanks, I tried reporting this last November when it was released, but I didn't know how to report an issue. I tried...

David Reed (9/19/2008)

---

Adam Machanic (9/19/2008)

---

developmentalmadness (9/19/2008)

---

The only shortcoming here with LINQ is they didn't go quite far enough, because the don't properly parameterize strings and numeric (decimal etc) types which...

I am a developer, but I have also worked as a dba (eg. you're good at coding SQL - the database is yours) on a high traffic site (1.2 million...

GSquared (6/18/2008)

---

I figured it out! On the describe_cursor_columns one, you don't get the number of rows in the original cursor, but you can count the number of rows in...

For 7 years I was a salaried employee, I worked no less than 9-10 hours a day for a small company that was growing. During the birth of my third...

First off, I thought the QotD was great. I've read about this attack, but hadn't yet seen an example of how it was executed.

scott (6/9/2008)

---

Hmmm, interesting topic. Definitely...

James Goodwin (5/20/2008)

---

I think everyone is missing the point of what is happening.

What is occuring is an automatic type conversion. If I do this:

Declare @Tmp datetime

set