Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,521 through 41,535 (of 59,102 total)

RE: BCP Export a CSV file

I would agree about the permissions issue. What is the server logged in as and what are you using to do the BCP Export (ie: xp_Cmdhell?)
--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)

October 17, 2009 at 7:02 pm

#1067363
RE: Discussion: Removing the option to ' SELECT * FROM OBJECT'

I believe a little education and threats of high velocity pork chops would be the easiest and best thing to do.
--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)

October 17, 2009 at 6:34 pm

#1067362
RE: SQL CLR code needed to replace fn_regex_split

Matt Miller (#4) (10/17/2009)
Anything involving the "outside world" IMO just incentivizes all of those cruel ways some folks love to torture SQL Server (e.g. let me use my SQL server...
--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)

October 17, 2009 at 5:11 pm

#1067361
RE: Are the posted questions getting worse?

Lynn Pettis (10/17/2009)
What is even better, we got a call from Kassondra as she was at the Charlotte NC airport, 8 soldiers in uniform (including her) were called up the...
--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)

October 17, 2009 at 5:06 pm

#1067359
RE: SQL CLR code needed to replace fn_regex_split

Paul White (10/17/2009)
I do wish you would come to see CLR routines as complimentary to T-SQL 🙂
Heh... Actually, I do and I also understand the power there. The problem...
--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)

October 17, 2009 at 12:04 pm

#1067344
RE: Afraid of Help

talltop-969015 (10/17/2009)
Still, no excuse to not do some research before posting....
Agreed... but sometimes folks don't even know what to look for especially when they're new to SQL. Some haven't...
--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)

October 17, 2009 at 11:24 am

#1067341
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

Thanks Allister. The reformatting is taking longer than any of us anticipated and I also have a late breaking bit of information that I'm adding.
For the code windows, you'll...
--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)

October 17, 2009 at 9:56 am

#1067338
RE: Are the posted questions getting worse?

jcrawf02 (10/16/2009)
Steve Jones - Editor (10/16/2009)
whoop upside?
what's next, shocking keyboards? loud raspberries when someone responds?
Seconded, all in favor?:-D
Belt fed pork chop launcher sounds like more fun. 😛
--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)

October 17, 2009 at 12:59 am

#1067307
RE: Are the posted questions getting worse?

Grant Fritchey (10/15/2009)
Jack Corbett (10/15/2009)
Okay threadiatics, if you have choice between putting data for multiple applications in 1 database because there is some common data or application specific databases?
Unless...
--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)

October 17, 2009 at 12:53 am

#1067306
RE: SQL CLR code needed to replace fn_regex_split

Ummm... ok... take any split function that works on an VARCHAR(8000) and test it for performance using something less than 8k to split (sorry for being obvious). Then, just...
--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)

October 17, 2009 at 12:35 am

#1067304
RE: query optimizing

zukko (10/8/2009)
sorry forgot to add the full script 😛
Thanks zukko.
--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)

October 17, 2009 at 12:30 am

#1067303
RE: Slow Query

I was in a hurry so I didn't read Mark's post. He basically said the same thing that I did before I did.
Here's the code you posted...
select distinct a.empid
from...
--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)

October 17, 2009 at 12:21 am

#1067301
RE: Concatenating Rows

Paul White (10/16/2009)
edit: aw carp - done it again! There are four pages of comments, not just the last one that the link took me to!
Oh well, never...
--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)

October 17, 2009 at 12:09 am

#1067299
RE: Concatenating Rows

sonphan11 (10/16/2009)
1) What I meant was no particular view. This post was to reply back to a comment saying this method works only on one entity. I assumed the entity...
--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)

October 17, 2009 at 12:00 am

#1067298
RE: query to modify

s ss (10/16/2009)
Thank you so much Jeff. You put it way better than what I wanted to say in "The Thread".
God bless you!
Regards,
Supriya
Thanks Supriya... this one bugged me. ...
--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)

October 16, 2009 at 8:31 pm

#1067281

Viewing 15 posts - 41,521 through 41,535 (of 59,102 total)