Yes. I was referring to the delta...

It amazes me that many folks forget about such things as the load on backups and maintenance plans and that just because you have memory and blazing disk speeds that...

Robert Frasca (10/12/2010)

---

Other than for merge and updatable transactional replication, I've yet to hear an argument as to why an identifier has to be globallyunique. Sure, it sounds grand...

1) DISK SPACE isn't what is important, it is THROUGHPUT, and that is dramatically affected by the quadruple-int-sized GUIDs. MEMORY is a precious commodity (on most systems) for the buffer...

Anyone that has tried to merge two databases that use identity values would have paid their year's salary to have had the original designers use guids for PKs. A COMB...

Tom.Thomson (7/24/2010)

---

Thomas-282729 (7/24/2010)

---

With due respect to Alex, it is not as elastic as you think. A good barometer for whether a given piece of logic belongs in the database is...

With due respect to Alex, it is not as elastic as...

4. To be more constructive, let me introduce real life example. Let's say you are stockbroker's progammer. Let's say that your clients make 100000 deal per day by 10000 clients...

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...

Tom.Thomson (6/26/2010)

---

Thomas-282729 (6/25/2010)

---

Nick Walton (6/25/2010)

---

I'm really looking forward to this series, as there's been a higher than average number of "Cursors are baaaaaad" posts on SSC recently. Your...

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...

Michael Jenck (6/25/2010)

---

I have been trying to figure out a way to eliminate the following cursor. I figure this would be a good place to post this seeing the...

Nick Walton (6/25/2010)

---

I'm really looking forward to this series, as there's been a higher than average number of "Cursors are baaaaaad" posts on SSC recently. Your article seems...

David.Poole (6/10/2010)

---

There seems to be an assumption that there is a single field acting as the PK. This isn't necessarily true.

As to calling things ID because its easier for...

RichB (6/9/2010)

---

Thomas-282729 (6/8/2010)

---

Again, what you are suggesting is a poorly written query where the developer uses the wrong alias (A.Id instead of B.Id). How does that improve clarity in the...