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

Dave Schutz (5/24/2010)

---

A "smart' system that monitors my movements makes me think of the movie Minority Report. I don't really want to be tracked all the time. The more data...

ehamouda (5/24/2010)

---

sorry

this is the right query i need to be converted..

SELECT exxonTesting.[SP Company Name], exxonTesting.[SP Office No], exxonTesting.[Safety POC], exxonTesting.[API Requirements], exxonTesting.City, exxonTesting.State, exxonTesting.[Name Tested], exxonTesting.Completed, exxonTesting.Expires, exxonTesting.[API Key...

Steve Jones - Editor (5/24/2010)

---

Like with a monitoring system. Don't ping me on 100% CPU, ping me when it's sustained 100% for more than 5 minutes, and it's not a...