Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,511 through 33,525 (of 59,099 total)

RE: Quick question on zip code searches: U.S. and Canada

@matt6749,
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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 24, 2011 at 8:10 am

#1343679
RE: Which one is better select * into # temp from tableA Vs create #temp table insert into...

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 24, 2011 at 7:47 am

#1343656
RE: kindly give some solution

Jayanth_Kurup (6/23/2011)
A rule of thumb , the data decides the datatype , performance and storage considerations are secondary , i.e if the data is fixed length use char else varchar...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 24, 2011 at 7:34 am

#1343650
RE: Restricting DBA from accessing SQL DB objects

bhawna.jain (6/24/2011)
I have already applied cell level encryption. But I don't want DBA to see the definition or modify any object. We are blocking DBA access for the security of...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 24, 2011 at 7:13 am

#1343642
RE: Are the posted questions getting worse?

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 24, 2011 at 6:58 am

#1343633
RE: Are the posted questions getting worse?

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 24, 2011 at 6:49 am

#1343629
RE: Concatenating multiple rows into a string

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 24, 2011 at 6:21 am

#1343615
RE: Concatenating multiple rows into a string

I believe that Wayne S. did this one already.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 23, 2011 at 5:32 pm

#1343427
RE: Does anyone have a good reason to run xp_CmdShell?

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 23, 2011 at 7:35 am

#1343027
RE: Are the posted questions getting worse?

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 23, 2011 at 7:21 am

#1343016
RE: Are the posted questions getting worse?

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 23, 2011 at 7:16 am

#1343010
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (6/21/2011)
Anyone here do a lot of .NET work and willing to travel/speak on those topics? Might have some funding for you.
Jeff, maybe we can entice...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 23, 2011 at 7:11 am

#1343004
RE: Analytical Interview Questions

james.morrison 19355 (6/22/2011)
Would you really put an MCM through all of that? If the person had 3 years of experience at Microsoft, would you really be that worried about their...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 23, 2011 at 12:25 am

#1342806
RE: Does anyone have a good reason to run xp_CmdShell?

Craig Farrell (6/22/2011)
rmechaber (6/22/2011)
Craig, I looked at BOL for this following your suggestions, and I have a question:
Looks like you must create a Windows account, grant it NTFS...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 23, 2011 at 12:08 am

#1342801
RE: Does anyone have a good reason to run xp_CmdShell?

Craig Farrell (6/22/2011)
Oh Lord, Jeff. I haven't fully wrapped my head about it but you're going to skip up to CLR and use the windows account, aren't you?
Nah... no...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 23, 2011 at 12:02 am

#1342799

Viewing 15 posts - 33,511 through 33,525 (of 59,099 total)