Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,516 through 34,530 (of 59,099 total)

RE: Are the posted questions getting worse?

Grant Fritchey (3/24/2011)
Jeff Moden (3/24/2011)
Oh, very cool... I just found out that one of my favorite novels is going to be made into a movie. "The Martian Tales 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)

March 24, 2011 at 10:03 pm

#1303343
RE: Settings for "Script Table As..."

HowardW (3/24/2011)
there doesn't appear to be an option to turn off SET ANSI_NULLS ON or SET QUOTED_IDENTIFIER ON parts of the script
They are functional parts of the definition of objects,...
--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)

March 24, 2011 at 9:54 pm

#1303342
RE: Settings for "Script Table As..."

Robert klimes (3/24/2011)
Unfortunately I do not see anywhere to stop those table option from being scripted out.
I didn't either and I've been looking! 😛 Thanks for your very quick...
--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)

March 24, 2011 at 11:39 am

#1303133
RE: Settings for "Script Table As..."

Thanks again for the previous tip. Similar problem, though... there doesn't appear to be an option to turn off SET ANSI_NULLS ON or SET QUOTED_IDENTIFIER ON parts of 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)

March 24, 2011 at 10:26 am

#1303095
RE: Settings for "Script Table As..."

Man, thanks for the very quick reply, Robert. I was in a bit of a crunch and just couldn't bring myself to use the "urgent" word. 😛 Thank...
--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)

March 24, 2011 at 10:14 am

#1303084
RE: Are the posted questions getting worse?

Oh, very cool... I just found out that one of my favorite novels is going to be made into a movie. "The Martian Tales of Edgar Rice Burroughs" which...
--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)

March 24, 2011 at 7:12 am

#1302932
RE: Need Records from strings

UMG Developer (3/23/2011)
That is an interesting use of the start position, but it looks to me like either the documentation in BOL is wrong, or the behavior is a bug....
--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)

March 24, 2011 at 6:55 am

#1302910
RE: Need Records from strings

parthi-1705 (3/23/2011)
Try this,
CHARINDEX will help u
CREATE TABLE #abc_tmp
(Path nvarchar(850))
insert into #abc_tmp values('rptclientrifvdistrictgrantstatuschangelog_MillmanR_9dfb3dfa-081b-48d1-8bbf-81361bbd9cb9')
insert into #abc_tmp values('rptclientrifvdistrictgrantstatuschangelog_MeiA_e472f742-c6a3-4a70-822e-1c5417efb293')
insert into #abc_tmp values ('rptclientrifvglobalgrantproposalbytrackingnumber_BateyK_23eafa59-e222-462d-a08c-27ed8131c274')
Select SUBSTRING(Path,0, CHARINDEX('_',Path) ), * from #abc_tmp
DROP TABLE #abc_tmp
VERY clever use...
--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)

March 23, 2011 at 5:49 pm

#1302770
RE: 'IS NOT NULL' in LEFT OUTER JOIN

SQLJocky (3/23/2011)
@pam
I agree, that dropped the processing time in half. Thanks for the suggestion. 😀
Please post how the code you applied Pam's suggestion to so we can...
--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)

March 23, 2011 at 11:13 am

#1302618
RE: How often do you really need dynamic t-SQL?

GilaMonster (3/23/2011)
Discussed here - http://sqlinthewild.co.za/index.php/2011/03/18/q-a-from-24-hours-of-pass-session/
I’m actually in favour of nulls in a database. If there’s no data for a column I don’t want some made up value to indicate that...
--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)

March 23, 2011 at 10:57 am

#1302608
RE: How often do you really need dynamic t-SQL?

opc.three (3/22/2011)
In general dynamic sql is a bad idea and you should avoid it...
In general, I disagree. 😀 There are some very easy steps that can be taken...
--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)

March 23, 2011 at 8:24 am

#1302491
RE: Are the posted questions getting worse?

Grant Fritchey (3/23/2011)
...duck tour should be a blast.
Heh... not sure duck hunting season is open right now. 😛
--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)

March 23, 2011 at 7:17 am

#1302439
RE: is there a way to do a mass update in SSIS

Heh... I don't mind 2 year old threads being resurrected especially if someone has a good tip. 😉
--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)

March 23, 2011 at 7:15 am

#1302438
RE: Looking for Elegant Efficient T-SQL Code

TheSQLGuru (3/23/2011)
Hard-coding the table names instead of using a sys.objects driven cursor to do these deletes may save you 0.001% of the total execution time. I say it would...
--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)

March 23, 2011 at 7:08 am

#1302434
RE: Looking for Elegant Efficient T-SQL Code

CELKO (3/22/2011)
Why don't you know the names of the staging tables and hardcode them?
Hmmm... good question, Joe.
--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)

March 22, 2011 at 10:42 pm

#1302268

Viewing 15 posts - 34,516 through 34,530 (of 59,099 total)