I don't understand why a script to scan across all tables in a database would be needed. Generally speaking, we know ahead of time if we're looking for a customer...

Here is one technique I use when there is a need to perform bulk deletes on a large table. It is not an online operation, but it should be able...

That's a denial of service type attack that I hadn't expected, but it is an interesting attack vector. I wouldn't expect this to impact servers, but if servers are consuming...

paul.knibbs (3/5/2013)

---

I could be really smug because I always use Firefox, but instead I'll allow myself to be gobsmacked that such an obvious flaw has made it into three major...

Miles Neale (2/26/2013)

---

Dave62 (2/26/2013)

---

Definitely not.

I do .NET development and SQL Server development/administration. ...

pdanes (2/22/2013)

---

It's not obsolete if it still does the job it was designed to do. I've written my share of FORTRAN, RPG, COBOL and who knows what else over the...

Michael Valentine Jones (2/22/2013)

---

Eric M Russell (2/22/2013)

---

Michael Valentine Jones (2/22/2013)

---

I don’t see how this list could be complete without mentioning COBOL.

From the 1960s until about 1990 it was the language...

Michael Valentine Jones (2/22/2013)

---

I don’t see how this list could be complete without mentioning COBOL.

From the 1960s until about 1990 it was the language of choice for business programming with...

I think the average age for database developers and sysadmins must be like 40. Maybe a few years more for sysadmins.

My first computer was a Commodore 64, basically the same as a VIC 20, except it has a whopping 64 KB of RAM instead of the VIC's 5 KB. Like...

crazyEmu (2/21/2013)

---

Was confronted by a trigger just yesterday, wonderful use of nested cursors. Just had to post it as an example.

It is supplied by a vendor (Sage \ SalesLogix) so...

But I'm somewhat amazed how many fragmentation questions, posts, articles, and more that I still see on a regular basis. Shouldn't this be a low level feature of SQL Server...

After sitting around the office all day long, it's refreshing to get outside and either take a couple hour hike or mow the grass or something. As for shoveling horse...

keith.fearnley (2/20/2013)

---

Though wary of re-igniting the discussion (informative and lively though it has been), I wonder how this relates to the HL7 RIM model (look up RIMBAA) - as I...

Fortunately SQL Server is self documenting, at least in terms...