Forum Replies Created
Viewing 15 posts - 2,731 through 2,745 (of 5,685 total)
-
RE: Are the posted questions getting worse?
Ninja's_RGR'us (8/5/2011)
Craig Farrell (8/5/2011)
A moment of Friday Humor...Time to optimize, perhaps?
What the heck is this supposed to to? :w00t:
155 million row update on a very wide table (which has been...
-
RE: Are the posted questions getting worse?
A moment of Friday Humor...
Time to optimize, perhaps?
-
RE: Are the posted questions getting worse?
george sibbald (8/4/2011)
GilaMonster (8/4/2011)
george sibbald (8/4/2011)
Craig Farrell (8/4/2011)
RE: Airplanes and idiots:It's been proven that you can *waltz* through American security even after 9/11 with:
...- 2 lbs of C4 ( shaped...
-
RE: Are the posted questions getting worse?
RE: Airplanes and idiots:
It's been proven that you can *waltz* through American security even after 9/11 with:
- A katana
- Machete
- Enough gunpowder to press your own 100 round magazine. ...
-
RE: SQLServerCentral.com Best Practices Clinic: Part 5
Ninja's_RGR'us (8/3/2011)
Ninja's_RGR'us (8/2/2011)
UPDATE dbo.AnalysisLog SET @Count = Count = Count + 1 WHERE ...Nevermind that part, I had missed the fact that there's 1 row per date where there's action...
-
RE: SQLServerCentral.com Best Practices Clinic: Part 5
bradmcgehee@hotmail.com (8/2/2011)
I am providing most of the information requested, except the XML execution plans. You will have to work with the graphical execution plans.Why not? Not that I can't...
-
RE: What is faster, MAX() with GROUP BY, OR CTE with ROW_NUMBER()?
Pagan DBA (8/2/2011)
As an aside, I'm sorry but BIT(1) = 1/0 is my preferred choice to VARCHAR(1) = Y/N. This is because in spite of my efforts, I have always... -
RE: What is faster, MAX() with GROUP BY, OR CTE with ROW_NUMBER()?
Row_Number() is rarely faster, and usually only due to bad indexing/heaps, or because the data is incredibly limited that it has to number before moving forward. On large data...
-
RE: Except vs. Left Join vs. Not Exists
I wanted to thank everyone (particularly Paul) for helping me find, or at least learn what to go research, in regards to my confusion. I'm sorry I haven't been...
-
RE: Except vs. Left Join vs. Not Exists
Eugene Elutin (7/27/2011)
Are you always using MAXDOP 1 in your queries?You don't trust MS at all are you? 😀
Not for benchmark tests, no. Besides, if you'll see my...
-
RE: Design suggestions for Large SQL 2008 table (several billion+ rows)
To simplify and maybe help you narrow down what OPC is discussing here, are you joining that PK into other tables? If so, that's going to hurt, and you...
-
RE: Are the posted questions getting worse?
Chad Crawford (7/26/2011)
<Darth Vader>: Luke!<Luke>: Yes father?
<Darth Vader>: I know what you're getting for your birthday.
<Luke>: But father, how could you know what I'm getting...
-
RE: Max degree of parallelism
SQLkiwi (7/26/2011)
I do want to respond to the comments about CXPACKET though. Very few people understand what CXPACKET truly means (and I do not number storage engine experts among... -
RE: Max degree of parallelism
On a personal level, I'd probably start at serverwide MAXDOP 8 with a cost setting of ~10-15 and then monitor the heck out of it looking for the pain points....
Viewing 15 posts - 2,731 through 2,745 (of 5,685 total)