MeltonDBA (6/7/2010)

---

So to prevent heavy deadlocking they simply add (NO LOCK) on their SELECT queries since they are reading from a few tables that are consistently being updated or inserted...

This is my first time reading the article and although you do state,

The deadlock in this type of scenario is completely timing based, and it can be difficult to...

It seems like everyone is replying in terms of the end user, which is definitely one side of the equation (and what was asked for in the Editorial). And...

Steve, how big is the SQLServerCentral.com database?

Yeah, indexes are good. There is a clustered index on the id column of each table and there is an index on the trackID column of the TrackPoint and...

Thanks, guys. There is no problem per se, just wondering if it could be better. Using Dave's query, with 5 trips in the list, we get the attached...

Thanks guys. I'm sorry, I did have the wrong value in my desired output. I've edited my post to correct it.

Kingston, I appreciate the help. Your first...

GSquared's comment is a good one, but I'm still waiting for Microsoft or someone else to write a plug-in that warns you if you try to execute a query without...

In Steve's editorial from a couple weeks ago, Code Writing Code, he makes reference to Buck Woody's blog post, which made reference to NHibernate, which is a very popular "ORM"...

Nobody here has mentioned NHibernate, which is partially what the referring blog post was about. I left a comment on that blog post last month. Does anybody else...

Steve, you should totally get yourself a movie clapper (clapper board, clap slate, whatever you want to call it) instead of counting down. 🙂 (Not that you have...

Thanks, Kingston! It makes perfect sense when I see it, but I just couldn't think of it on my own.

Thanks, Kingston, but no, that only gives me one row. The one for userID 72379 (who has the max last_used date for that application version of all users). ...

Steve, does the forum software limit the length of the post at all? I don't run a technical site, but we limit our forum posts to 7,000 bytes (text...

To answer Steve's question about the technical differences between the languages and what makes one better than the other I've listed some things that I've come across in my time....