Viewing 13 posts - 166 through 178 (of 178 total)
From my XP workstation, running the first query only, if I connect to my local SQL 2008 install then I get the 3.3333 time. If I connect to our...
May 12, 2010 at 6:49 am
tamie.mcdonald (3/11/2010)
Why would you cluster an index for an Identity column key?...so wouldn't you want to cluster it around a logical key?
I too have the same curiosity. ...
March 11, 2010 at 10:33 am
Tim,
While I participated in an engaging (albeit, short) discussion with two others that spun from your article, I neglected to state a hearty, "Thank You" for your contribution. The...
March 3, 2010 at 1:55 pm
DCPeterson (3/3/2010)
There is no need to be as condescending and rude as you were, period.
A valid point, and I agree.
For some reason, people seem to find fault in others as...
March 3, 2010 at 12:24 pm
Todd,
I'll admit up front that I lack MUCH developer insight, thus my interest in Karen's response. How does the developer know that each vendor is indeed selling the exact...
March 2, 2010 at 9:38 am
Karen Lopez - InfoAdvisors (3/2/2010)
...What devs are telling me is that the real world does not have many-to-many relationships and that these are just artifacts of a designer trying to...
March 2, 2010 at 8:30 am
Thank you. I now understand the basics of CTE's. I've seen them referenced and this article represents my first understanding. I'll reference it as I gain more...
December 10, 2009 at 9:00 am
Excellent article. I'm sure this took some time to produce.
Thank you for debunking the "only in memory" myth for temp tables and table variables. I've never had time...
June 10, 2009 at 8:31 am
Jeff Moden (11/25/2008)
Heh... then there's the "intelligent" ones that say things like "performance" doesn't matter and will argue for hours about it. The only reason why I continue in...
November 25, 2008 at 7:26 am
Jeff Moden (11/24/2008)
thisisfutile (11/24/2008)
Jeff Moden (11/24/2008)
jacroberts (11/24/2008)
... queried the table with 4000 rows in in less than 1 second.That's pretty slow and performance should be always an issue...
With all due...
November 25, 2008 at 6:54 am
Jeff Moden (11/24/2008)
jacroberts (11/24/2008)
... queried the table with 4000 rows in in less than 1 second.That's pretty slow and performance should be always an issue...
With all due respect Jeff, it...
November 24, 2008 at 7:38 am
Bilal,
The first article that Deepak referenced (902388) was exactly what helped me...(read on)
Several years ago, I had the same problem with the DB Maintenance plan. This process was failing...
May 21, 2008 at 8:57 am
If you force a square peg into a round hole, you will shave the corners...
I have to admit, I didn't read all the posts
...but, some seem to be implying that...
May 21, 2008 at 7:53 am
Viewing 13 posts - 166 through 178 (of 178 total)