Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,176 through 32,190 (of 59,099 total)

RE: Unable to run Batch file though T-SQL (Xp_cmdshell)

Dev @ +91 973 913 6683 (10/19/2011)
Please don't forget to follow the discussion.
I cringe every time I see a recommendation for xp_cmdshell.
http://www.sqlservercentral.com/Forums/FindPost1186236.aspx
Yes... please follow ALL of the discussion because...
--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 24, 2011 at 5:22 pm

#1398934
RE: FInd position of a number in string by using FINDSTRING

I'm not 100% sure about SSIS but, from what I've read, you should be able to use "%[0-9]%" as the "search string" in FINDSTRING. Of course, you'd use 1...
--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 24, 2011 at 4:55 pm

#1398925
RE: rows into columns

mnicholas (10/24/2011)
I'm tring to get results that has first name and last name in a single row rather than column, any help would be appreciated.
SELECT distinct ...
--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 24, 2011 at 4:43 pm

#1398924
RE: convert date

sqlfriends (10/24/2011)
I need to convert yesterday's date from getdate()-1 to something like 20111023.
I have to ask "Why?"... What are you going to do with it after you do the conversion?...
--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 24, 2011 at 4:37 pm

#1398921
RE: I cringe every time I see a recommendation for xp_cmdshell.

Elliott Whitlow (10/24/2011)
I guess I see it differently Jeff. I certainly agree SQL injection is not acceptable but I am opposed to having xp_cmdshell enabled without a really good...
--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 24, 2011 at 4:25 pm

#1398917
RE: Help Converting While Loop to true Set Based

Mike Usoffski (10/24/2011)
Outstanding !
This is a small part of major data scrubbing/cleansing within 2000 --> 2K8 R2 migration project.
The plan was to leave "dups" behind on a SQL 2000 side....
--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 24, 2011 at 1:53 pm

#1398875
RE: I cringe every time I see a recommendation for xp_cmdshell.

patrickmcginnis59 (10/24/2011)
This discussion is pretty good except that I'm not really understanding the actual attack surface issue itself. The closest I could find on the web is that an attacker...
--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 24, 2011 at 1:22 pm

#1398868
RE: bcp Challenge

patrickmcginnis59 (10/24/2011)
...dreaded xp_cmdshell...
Heh... "dreaded". I love 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)

October 24, 2011 at 11:02 am

#1398813
RE: total inside cte

Jack Corbett (10/24/2011)
I have a question. Why the TABLOCKX hint on the temp table? What does it give you that the QP/QO wouldn't do anyway?
It's a small "speed...
--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 24, 2011 at 10:59 am

#1398811
RE: performance of the query and index

On that note... do what I do... I trust no one's article. I test the heck out of their claims using my own code. In truth, you shouldn'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 24, 2011 at 7:08 am

#1398655
RE: Are the posted questions getting worse?

HowardW (10/24/2011)
Just came across this:
http://sqlserverboost.info/?p=204
Complete plagiarism, yes?[/url]
The rest of the site content looks equally dubious.
Google for the phrase "In my experience, every DBA has his own mental checklist"... which comes...
--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 24, 2011 at 5:10 am

#1398605
RE: performance of the query and index

dva2007 (10/24/2011)
thanks jeff & gail.
I had a quick look at this article before couple of years which made my wrong impression about select into.
http://searchsqlserver.techtarget.com/tip/Tricks-to-increase-SQL-Server-query-performance
Many thanks for the clarification.
Ah......
--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 24, 2011 at 4:56 am

#1398597
RE: total inside cte

My pleasure and thank you for the kudo.
Of more immediate concern is, have you studied the code, know how it works, or have any questions about how it works? ...
--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 24, 2011 at 4:35 am

#1398582
RE: LTRIM,RTRIM

SARG stands for "Search ARGument" and "SARGable" has come to mean that the search arguments in a WHERE clause, ORDER BY, and/or ON clause are capable of doing an INDEX...
--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 24, 2011 at 4:31 am

#1398577
RE: Converting rows to columns

andre-394971 (10/23/2011)
I have tried the pivot table approach but neither column lends itself to an aggregate function and unfortunatly my skill set with SQL is limited
Heh... use MAX instead... it's...
--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 23, 2011 at 8:51 pm

#1398492

Viewing 15 posts - 32,176 through 32,190 (of 59,099 total)