There's not really much of a practical difference between the two except that many tools you work with will consider the primary key to be "king". Certainly linking your...

I'm with James except that I don't bother prefixing with sp, usp or anything 🙂 I have procedures such as

TC_Sheets_Get

which is for the theatre costing system to retrieve...

These are my favourite kind of discussion. I'd be happy to say that 99% of SQL Server users probably couldn't have come up with either approach. The use...

It will definitely be some sort of index rebuild. Another thing it could be is if you run a command similar to (but much larger in scope)

update myTable

set colA...

Please format your code 😀

SELECT

COUNT(tblConferences.Division) AS Total, tblConferences.Subdivision, tblConfAtt.ConfDate,tblConfAtt.CustomerID

FROM tblConfAtt

INNER JOIN tblConferences

ON tblConfAtt.Conference = tblConferences.Room AND

...

Are you seeing anything extra in the SQL Server log?

Unfortunately SQL 2k5's over clause is missing that little bit of magic present in the SQL standard and other SQL products. The full functionality is also not present in...

I have to agree with the naysayers unfortunately. It's great at the moment and really does seem to work (I haven't seen it fail yet either). I was...

I'm looking forward to the rest of the series. It's a nice departure from the usual (although still useful and definitely not mundane) stuff we all read on here.

I...

Unfortunately the hybrid car is one of those things where you can find plenty of information for and against their use - just to confuse the consumer. I think...

Hmm, I have to agree. That's a LOT to read and decipher.

Are you sure the source data's not changing? By how much are your summaries changing?

It...

Great article. I must admit that we use BLOBs to store data in MS SQL, but the BLOBs (which are documents) are stored in a separate (or many separate)...

Do a search for and downloads a product (there's a free version) called TOAD for Oracle. It makes Oracle a LOT easier to use and more familiar for us...

Good article - great discussion 😀 When reading the article I thought "that makes sense". But the locking problems, coupled with the systems with which I'm associated not...

I did a couple of subjects at university on coding supercomputers, etc. Memory management was always one of those things that could severely impact on the speed of your...