Viewing 15 posts - 10,681 through 10,695 (of 14,953 total)
GilaMonster (3/2/2009)
Alvin Ramard (3/2/2009)
GilaMonster (3/2/2009)
*snigger*http://www.sqlservercentral.com/Forums/Topic666430-146-1.aspx
WOW, he got the hint!!!
It wasn't exactly subtle.
Great statement I ran into somewhere, "That man's as subtle as a two-by-four upside the head."
- 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
March 2, 2009 at 8:35 am
On the subject of "nothing to hide, nothing to fear", there's another aspect to it: Nobody, and I mean nobody, wants to know certain things about certain people. I...
- 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
March 2, 2009 at 8:31 am
I can easily imagine the inventor of the filing cabinet having similar qualms about "ease of data abuse" and "ease of data corruption".
I can also imagine the inventor of writing...
- 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
March 2, 2009 at 8:24 am
On the subject of terrabyte flash drives:
http://www.enterprisestorageforum.com/technology/news/article.php/3795956
Looks like it'll be a lot less than a decade.
On the subject of cloud databases, I think it's a cool idea, but I just...
- 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
March 2, 2009 at 8:07 am
Sometimes it takes a separate set of eyes to pick these things up.
One thing I always do with dynamic SQL, is have a print command right before the exec command....
- 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
March 2, 2009 at 7:20 am
Is there a column in RoutePosition that would satisfy the range of the query? Perhaps an index with a column like that would help.
- 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
March 2, 2009 at 7:15 am
It's the union all operation that's slowing it down. Or so it seems to me.
Try dumping the data into a single table, in a test environment, with that index...
- 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
March 2, 2009 at 7:12 am
Bob Hovious (2/27/2009)
My war story is that our development group used to have a guy whose...
- 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
March 2, 2009 at 7:07 am
karthikeyan (3/2/2009)
- 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
March 2, 2009 at 6:47 am
Why are you executing your Where clause? "exec (@iWhere)". From what I can see, that's just a set of boolean comparisons, without a Select, etc. Do you...
- 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
February 27, 2009 at 1:30 pm
Roy Ernest (2/27/2009)
- 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
February 27, 2009 at 1:26 pm
Yes, you can create a layer to expose a proc through a web service. People do it all the time. It comes under the heading of building something...
- 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
February 27, 2009 at 1:20 pm
Jack Corbett (2/27/2009)
Here's one of my favorite type of problem:http://www.sqlservercentral.com/Forums/Topic665812-266-1.aspx
At least they have backups.
They know how to do backups, but not how to restore them. They also think you...
- 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
February 27, 2009 at 1:17 pm
Easier with a case statement. There are only so many variations on the interval.
case @Type
when 'dd' then dateadd(day, @Number, MyDate)
when 'ww' then dateadd(week, @Number, MyDate)
...
- 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
February 27, 2009 at 1:15 pm
Connect to the database using any standard method, and run the proc using the methods and properties appropriate to your programming language. Not sure what else you would do.
- 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
February 27, 2009 at 12:18 pm
Viewing 15 posts - 10,681 through 10,695 (of 14,953 total)