I had kind of the same problem. Have you tried to change the network cable, plug into another port in the Switch? If you have more that one ethernet port,...

Good article altought was corrected by BrentO. I recently attended to at South Florida group meeting where Brent spoke about SSD. It would be interesting to see what should be...

Have you considered stay at a hotel some day? How much are you spending on gas,...

Fortunately for me my commuting time is about 30 minutes and 20 when schools are in recess. Also this is due to the fact that I leave home at 7:00am...

GilaMonter

I am trying to give an answer. Problem could be memory resources on the SQL 2008 R2. (I am assumming that tables has indexes, statistics updated, etc.) Check on the...

Did you move your query from 2000 to 2008? I am experiencing the same performance issue. I have a SP that run in about1/2 sec in 2000 and in 2008...

Nice solution regardless the comment why to do it with SQL. It is all depends on you organization and the resources you have in your hands. Sometimes you have to...

Do you have one?

What we do in our shop is to add a prefix to the name of the field like:

sName: (s) for Char, Varchar

dBirthdate (d) for Datetime

nPayment (n) numeric fileld...

I think Brad took it personal!!! This article is an opinion and it is up to us to discuss and bring our comments in how to improve the a way...