Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,936 through 19,950 (of 59,072 total)

RE: Interview Questions Help

Kutang Pan (8/6/2015)
Thank you Lynn, appreciate the effort.
Jeff,
I did try to avoid it but for this particular product i couldnt find better way. For another one I've used merge replication...
--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 4:10 pm

#1817989
RE: Amateur Data Analysis

I've found that many people already have a notion of what they want to find in the data rather than finding what the data is telling them. As Granny...
--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 11:18 am

#1817935
RE: Interview Questions Help

Kutang Pan (8/6/2015)
When the software is being upgraded it automatuically backs up a database, It's just a full backup, so i thought at least knowing how to do a backup...
--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:51 am

#1817912
RE: Interview Questions Help

Luis Cazares (8/6/2015)
I would try to go from the basics to the more advanced things to help to determine easier the knowledge and also to give an easy start for...
--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:22 am

#1817900
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

Viewing 15 posts - 19,936 through 19,950 (of 59,072 total)