Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,966 through 19,980 (of 59,098 total)

RE: If you could use xp_CmdShell securely, would you?

Spot on a similar here. I use it for calls to WMIC to pick up the disk stats and warnings for the entire enterprise and put it all in...
--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)

August 6, 2015 at 9:20 am

#1817899
RE: Interview Questions Help

Kutang Pan (8/6/2015)
Thank you Jeff,
I’ve actually read many threads on this forum and know that you do have some experience in recruiting sql "professionals" so any input would be highly...
--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)

August 6, 2015 at 8:49 am

#1817882
RE: If you could use xp_CmdShell securely, would you?

TomThomson (8/4/2015)
Jeff Moden (8/3/2015)
Heh... ironically, I absolutely agree with the idea of writing SQLCLR for file handling, etc. Equally ironic is the amount of FUD concerning such CLR endeavors...
--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)

August 6, 2015 at 7:48 am

#1817853
RE: If you could use xp_CmdShell securely, would you?

stevenb 14609 (8/6/2015)
I use xp_CmdShell for 2 different things.
One is to export csv reports for end users.
The other one is to export and then FTP files to a...
--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)

August 6, 2015 at 7:40 am

#1817848
RE: Parse String By Column Position

terrance.steadman (8/6/2015)
Greetings All,
Thank you for the current replies. I had a feeling that the way Jeff had said would end up being the primary solution. Still, when running...
--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)

August 6, 2015 at 7:16 am

#1817838
RE: Parse String By Column Position

terrance.steadman (8/5/2015)
Greetings,
I am looking for a way to simplify chopping up a fixed width string into its individual fields. I realize I can just use SUBSTRING() to get each...
--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)

August 5, 2015 at 3:35 pm

#1817726
RE: If you could use xp_CmdShell securely, would you?

Excellent! I'm tickled pink that little ol' BCP can still pull the pants off of much more expensive software for things like this. Thanks for the feedback, JG.
Some...
--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)

August 5, 2015 at 3:21 pm

#1817723
RE: Code to Archive Data

BTW... the above isn't meant to discourage anyone from partitioning. It's meant to inform so that you can actually develop a great plan for partitioning. The same method...
--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)

August 5, 2015 at 11:27 am

#1817646
RE: Code to Archive Data

ARC211 (8/5/2015)
@jeff Moden
What is "but there can be a lot of other baggage that goes along with it" referring to when you mentioned it in your comment.... I was...
--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)

August 5, 2015 at 11:22 am

#1817645
RE: Interview Questions Help

Kutang Pan (8/5/2015)
Jeff Moden (8/5/2015)
Since its conspicuously absent for all the above, what of backups and what's the DR plan at the company? What condition are you leaving the company...
--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)

August 5, 2015 at 10:13 am

#1817620
RE: parsing a line post import

XYoung (8/5/2015)
One idea could be to use a function to parse your values. To get you started, check out this solution and see if it offers any inspiration: http://social.technet.microsoft.com/wiki/contents/articles/26937.t-sql-splitting-a-string-into-multiple-columns.aspx
What logic...
--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)

August 5, 2015 at 8:39 am

#1817569
RE: parsing a line post import

Edward-445599 (8/4/2015)
I have a table which has been import from a TXT file. Most lines can be ignored, but when I get a line like this
' ...
--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)

August 5, 2015 at 8:30 am

#1817560
RE: Looking for someone to team up with

Brandon Carl Goodman (8/5/2015)
I should of paid better attention to the date.
You could post a similar question via your own post if you're still interested in buddying up with someone...
--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)

August 5, 2015 at 8:18 am

#1817552
RE: Prep for large increase in usage

Or... get 3 envelopes. 😀
--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)

August 5, 2015 at 8:14 am

#1817551
RE: User-defined function

fnndala2 (8/5/2015)
I have the following SQL-Query:
CREATE FUNCTION fn_SelectTopEmployees ()
RETURNS TABLE
AS
RETURN
(
SELECT TOP(10) EmployeeID
FROM Employees
);
When I run the query, how many times between 1 and 10...
--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)

August 5, 2015 at 8:10 am

#1817546

Viewing 15 posts - 19,966 through 19,980 (of 59,098 total)