Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,126 through 43,140 (of 59,063 total)

RE: CHARINDEX in reverse

REVERSE is a fairly expensive function performance wise. No need to use three of them just to get the last name. I'll be back in a minute...
--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)

July 2, 2009 at 11:09 am

#1019340
RE: source files with different col names, order... one mapping for all? fuzzy mapping?

Just checking on something. In all of these files, is the loan number column guaranteed to have only non-alpha characters such as numeric digits and dashes?
--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)

July 2, 2009 at 10:44 am

#1019317
RE: Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.

... and no more "shrinking".... it's bad for the system all the way around.
--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)

July 2, 2009 at 10:35 am

#1019306
RE: Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.

Krasavita (7/2/2009)
Ok, Thank you I put for both 100 MB. I have for data 4,307 MB and for log 2MB. Do I keep it like this for now? Also I...
--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)

July 2, 2009 at 10:18 am

#1019295
RE: Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.

Krasavita (7/2/2009)
If you can't help, don't reply:-)
Heh... you must like pork chops. The link Lynn gave you was to a thread where Gail Shaw and others "in the know"...
--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)

July 2, 2009 at 10:03 am

#1019280
RE: SQL brian teaser...

Lynn Pettis (7/2/2009)
sometimes I just go with my gut feeling on things
Heh... welcome to the club. "Use the force, Luke."
--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)

July 2, 2009 at 9:45 am

#1019264
RE: SQL brian teaser...

Lynn Pettis (7/2/2009)
Jeff,
Pretty sure I'm the first one SSC to use the Base 10. I just thought it reduced the number of cross joins to generate a large number...
--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)

July 2, 2009 at 5:52 am

#1019058
RE: SQL brian teaser...

Lynn,
Was it you that first came up with the "Base 10" modification on Itzek's cteTally or someone else? Folks have had so many races on the subject that I...
--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)

July 1, 2009 at 11:22 pm

#1018894
RE: SQL brian teaser...

rijiboy (7/1/2009)
Lynn,
you are absolutely right, it will not, but the original question was not about speed 😀
Riz
BWAA-HAA!!!! The original question IS always be about speed especially when...
--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)

July 1, 2009 at 10:01 pm

#1018879
RE: Error Creating format file for bcp

You bet... thank you for the feedback. Please don't hesitate to post back if you continue to have problems.... we can bring some guns to bear on these types...
--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)

July 1, 2009 at 11:23 am

#1018607
RE: Error Creating format file for bcp

Also, the following parameter of:
-S MySQLServer\MyInstance
...should actually be"
-S"MySQLServer\MyInstance"
... because of the special character in the instance name.
--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)

June 30, 2009 at 9:17 pm

#1018116
RE: Error Creating format file for bcp

allan_au (6/30/2009)
Hi,
Thanks for reading this and hope you can help me.
Tried this:
bcp AdventureWorks.dbo.HumanResources.myTeam format nul -c -t , -f \\SomeServer\SomeFolder\myTeam.Fmt -Sserver_name [MySQLServer\MyInstance] -Ulogin_id Mylogin -Ppassword MyPassword -T
it error out with...
--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)

June 30, 2009 at 9:15 pm

#1018114
RE: Documenting Database Code: Structured Headers

Heh... I agree... we need automatic forced headers and automated code reviewers for things like "Warning: It's been determined that the code windows on SSC don't work correctly 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)

June 30, 2009 at 8:45 pm

#1018107
RE: Are the posted questions getting worse?

john.arnott (6/30/2009)
3NF-Boy got me ROFL with this response:w00t:. I can't wait to see Gus's answer. 😉
I took a look at that OP's response. I'd...
--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)

June 30, 2009 at 6:34 pm

#1018083
RE: How to chage IDENTITY Column seed

Heh... nice to have confirmation. 😉
--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)

June 30, 2009 at 4:13 pm

#1018041

Viewing 15 posts - 43,126 through 43,140 (of 59,063 total)