Viewing 15 posts - 33,511 through 33,525 (of 59,102 total)
THE-FHA (6/24/2011)
SQL 2008 come with query execution plan and estimation. try testing this queries and see the estimated results.
Nah... the execution plan frequently lies for things having to do with...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 24, 2011 at 10:25 am
opc.three (6/24/2011)
Jeff Moden (6/24/2011)
Craig Farrell (6/23/2011)
This conversation resparked a curiousity on my part.
When I run that code as a single unit, it keeps returning the following error...
There is already an...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 24, 2011 at 10:23 am
THE-FHA (6/24/2011)
Ever thought of the Query Analyzer?the first option is best.
What on Earth are you talking about? First Query Analyzer is for 2000 and second, I meant running running...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 24, 2011 at 10:22 am
Please post the code for fnDistance and then I'll tell you why there's such a time difference. I might also be able to tell you how to fix it,...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 24, 2011 at 8:10 am
Craig Farrell (6/23/2011)
This conversation resparked a curiousity on my part.
When I run that code as a single unit, it keeps returning the following error...
There is already an object named '#PreBuild'...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 24, 2011 at 7:47 am
Jayanth_Kurup (6/23/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 24, 2011 at 7:34 am
bhawna.jain (6/24/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 24, 2011 at 7:13 am
SQLRNNR (6/23/2011)
Jeff Moden (6/23/2011)
Craig Farrell (6/20/2011)
Don't even get me started on the incredibly interesting answers I've gotten for "Describe two differences between Truncate and Delete".
BWAAA-HAAA!!!! Such easy questions! 😉 ...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 24, 2011 at 6:58 am
bitbucket-25253 (6/23/2011)
Nah we are all here sucking on those frozen beer popsicles that Jeff hordes in his freezer.
Well, if you were a dust bunnie that knew how to write code,...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 24, 2011 at 6:49 am
Craig Farrell (6/23/2011)
I always point folks to this one:http://www.sqlservercentral.com/articles/FOR+XML+PATH/70203/
For delimited lists, I point folks to this one:
http://www.sqlservercentral.com/articles/comma+separated+list/71700/
--Jeff Moden
Change is inevitable... Change for the better is not.
June 24, 2011 at 6:21 am
I believe that Wayne S. did this one already.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 23, 2011 at 5:32 pm
Craig Farrell (6/23/2011)
The last alternative I can think of are signed procedures, ...
And now you're thinking. 🙂 That's the first method (although it's a two step process for xp_CmdShell...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 23, 2011 at 7:35 am
Craig Farrell (6/20/2011)
Don't even get me started on the incredibly interesting answers I've gotten for "Describe two differences between Truncate and Delete".
BWAAA-HAAA!!!! Such easy questions! 😉 Everyone knows they're...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 23, 2011 at 7:21 am
RBarryYoung (6/20/2011)
Jeff Moden (6/19/2011)
Major vent... suppressed. 😀 ...Ahh, how you've grown, my son. 😀
Dang! Good to "see" you, Barry! How the heck are you?
--Jeff Moden
Change is inevitable... Change for the better is not.
June 23, 2011 at 7:16 am
Steve Jones - SSC Editor (6/21/2011)
Jeff, maybe we can entice...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 23, 2011 at 7:11 am
Viewing 15 posts - 33,511 through 33,525 (of 59,102 total)