Viewing 15 posts - 12,316 through 12,330 (of 14,953 total)
rosh (8/11/2008)
which is recommended CTEs or Views?
Both. They do different things. Where they overlap in function, either will work.
- 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
August 12, 2008 at 8:57 am
Just because you can do a triple-back-flip-gainer-twist-split doesn't mean you showed any actual blocks and strikes in your form.
True. After all, what's politics got to do with karate?
- 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
August 12, 2008 at 8:51 am
vlad (8/11/2008)
this makes varchar(max) a special type ... necessitating special handling aka "workaround" for a bug, maybe ??
Nope. Implicit conversion can be a problem on just about any data...
- 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
August 12, 2008 at 8:48 am
Jeff Moden (8/11/2008)
GSquared (8/11/2008)
On CLR, yes, it will be faster than the CTE on that.Does anyone want to race? 😉
Matt's already tested that on a prior thread. A...
- 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
August 12, 2008 at 8:43 am
ryan.leuty (8/12/2008)
What's wrong with views?
They have a tendency to be badly misused, much like cursors, UDFs, et al.
I've seen lots of views that included six or seven tables, dozens 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
August 12, 2008 at 8:30 am
Chris: Yes, SQL 2000 needed Goto for exactly that. You're right.
Tom: I haven't found a need for that. I can see where it might have a use, but...
- 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
August 12, 2008 at 8:22 am
I have to agree with the article, with Phil, and with Grant, all at the same time. (My sig pretty clearly sums up why I say that.)
I have run...
- 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
August 12, 2008 at 7:33 am
I just ran my unmodified code on my machine, and got Jan 31, Feb 29 and Mar 31.
The difference is probably where your Numbers table starts. Mine starts at...
- 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
August 11, 2008 at 3:28 pm
Most of what I do uses derived tables as well. Actually, I use CTEs for those these days, but it's the same concept.
My point is merely that temp tables...
- 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
August 11, 2008 at 3:25 pm
On CLR, yes, it will be faster than the CTE on that.
- 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
August 11, 2008 at 3:13 pm
I actually don't know if you can do an in-place installation, since Dev Edition isn't supposed to be used for production databases.
On the other hand, you'll need your server settings,...
- 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
August 11, 2008 at 3:02 pm
rbarryyoung (8/11/2008)
GSquared (8/11/2008)
Barry, when I said, "your" I meant Milu's. He miscopied yours.
Yeah, I knew that Gus. Sorry if it looked like I was responding to you, 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
August 11, 2008 at 2:57 pm
Steve Jones - Editor (8/11/2008)
Sorry to hear that and hope you have some great memories. I know as I get older, things hurt, it becomes harder and harder to stress...
- 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
August 11, 2008 at 2:50 pm
Jimbo (8/11/2008)
I can sympathize. We do what we can with what we have. When I walk the dog, I often still get an annoying shin splint feeling in...
- 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
August 11, 2008 at 2:44 pm
On the subject of marketing and preconceptions, I've actually seen several hundred people do "the Pepsi Challenge", with both cups filled with Coke, and most people had strong preferences for...
- 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
August 11, 2008 at 2:38 pm
Viewing 15 posts - 12,316 through 12,330 (of 14,953 total)