One really bad data modeling mistake that can appear to work fine fine for months or years in production, but then present a major headache down the road, is when...

A web browser is like an external door on a corporate building; it's where people enter and leave the network. Even if hackers found a way to biggy back an...

Reading articles related to the attack on Google, I am left with the impression that it was a security hole in IE6 that was exploited, not necessarily Windows. What is...

Thomas-282729 (6/9/2010)

---

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

You mentioned earlier that your application may on occasion be executing this procedure thousands of times per second. There are several different things that can cause blocking. One is blocking...

paul.corujo (5/26/2010)

---

... When this is happening I am running sp_who2 active and do not see any blocking. Can somebody please advise me how i can track these procedures to...

My reading and knowledge of SQL Server extends beyond the scope of what I actually do day to day on the job, and I enjoy maintaining little side projects outside...

spattah (5/31/2010)

---

I'm trying to create a query where I get aggregated rows for every project in a choosen time-interval (see query below). The problem lies in grouping the dates. If...

Paul White NZ (5/7/2010)

---

Hey...

If you're good at a job that most people won't do, then you'll earn an average income. If you're good at a job that most people can't do, then you'll...

I spend a good deal of time landscaping around our home; and it's always an enjoyable diversion to research some new project and going tot Lowes or a stone yard...

Stefan Krzywicki (5/26/2010)

---

eric_russell 13013 (5/26/2010)

---

Perhaps my biggest data modeling pet peve is when date/time values are contained in a VarChar column. Not only does this consume 20+ bytes, compared to...

We can debate about [customer_id], versus [CustomerNumber], versus [Cust_Num], but at a minimum the foreign key names should match the primary key names, and to do that, the primary key...

See if executing a CHECKPOINT updates your allocation stats.

Sometimes people make poor data type choices or implement redundant columns due to misguided notions about best practices. For example, I once was hired as a contractor to delevepe reports...