Viewing 15 posts - 436 through 450 (of 14,953 total)
davoscollective (12/9/2012)
Jeff Moden (12/7/2012)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 10, 2012 at 6:41 am
DavidL (12/7/2012)
GSquared (12/7/2012)
To put it more simply, the test is only valid on people who don't need it. See if you can figure out why.
Come, come, GSquared. Don't...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 7, 2012 at 1:58 pm
DavidL (12/5/2012)
GSquared (12/5/2012)
Taurus: You will...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 7, 2012 at 6:42 am
samalex (12/5/2012)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 7, 2012 at 6:31 am
Is there anything at all in your second table that indicates which customer the data is tied to? Also, anything that indicates sequence?
Honestly, the data looks poorly designed. ...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 6, 2012 at 8:10 am
Lexa (12/5/2012)
GSquared (12/5/2012)
It doesn't hurt anything.I don't bother, personally, but there's no disadvantage to it that I know of.
If you have a proc that is frequently called and it has...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 5, 2012 at 9:34 am
Make sure that defragmentation will actually buy you something before you move ahead on complex plans to get it done.
Defragmentation of indexes is really only important if you do range-selects...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 5, 2012 at 9:31 am
It doesn't hurt anything.
I don't bother, personally, but there's no disadvantage to it that I know of.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 5, 2012 at 9:22 am
I once saw a comic (newpaper comics page type thing), titled "Before Astrology was a Science". Had a horoscope on it that went like this:
Taurus: You will interpret vague...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 5, 2012 at 8:56 am
That's not T-SQL syntax. Not ANSI SQL syntax either. Not sure what it is.
The part that SQL Server is objecting to is the list of columns (I assume...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 4, 2012 at 7:09 am
Are you looking for interesting/clever, or effective?
Honestly, all of the answers given so far are just different ways to tell the optimizer to do (essentially) the same thing. Of...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 4, 2012 at 6:59 am
If you're happy with DropBox, use that. SkyDrive is just another option for it.
Main reason I use SkyDrive is because I've been using it (and hotmail) since before most...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 3, 2012 at 1:19 pm
You should be looking for all the things you'd look for in any review of an execution plan:
Out of date/Missing stats
Table/Index scans (not always a bad thing, but worth noting)
Join...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 3, 2012 at 11:12 am
Views aren't something you execute. Do you mean when you query data from one?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 3, 2012 at 11:04 am
With that same structure, try this:
SELECT *
FROM dbo.Parcel AS P
INNER JOIN dbo.ParcelDetail AS PD
ON P.ParcelId = PD.ParcelId
WHERE P.ParcelId BETWEEN 10 AND 20;
You'll still get a Nested Loops Join.
Has nothing to...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 3, 2012 at 9:39 am
Viewing 15 posts - 436 through 450 (of 14,953 total)