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

dcraday (5/24/2010)

---

But since this is a SQL forum - I am VERY grateful that 'Select MyColumn from MyTable' is the same thing as 'SElect MyColumn from MyTable' or 'Select...

Usage of the word "smart" within the technology industry is like using the word "fair" within the realm of politics. I mean, ask 100 random people to define their idea...