Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,386 through 35,400 (of 59,102 total)

RE: T-sql to loop through all the tables in the database and delete records

Actually, it's not quite so easy to pull off in the presence of DRI. You'll need code to identify dependencies and that's not always the easiest thing to determine.
--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)

January 14, 2011 at 2:52 pm

#1273817
RE: Select column values as comma seperated format

Agreed and thanks for the feedback, Andrew. SQL Server 2000 was quite the bear for things like concatenation. I did come up with a couple of ways to...
--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)

January 14, 2011 at 2:49 pm

#1273816
RE: RETURN clause, clarification

autoexcrement (1/14/2011)
Sorry, this might be my dumbest post yet. But I can't seem to find a simple explanation.
I'm unclear on exactly what "RETURN" does. BoL says it "[immediately] exits...
--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)

January 14, 2011 at 2:45 pm

#1273812
RE: Better looping - replace for cursor

BaldingLoopMan (1/14/2011)
sorry. i do agree w the indexing just not the loop haters out there
Not to worry... I only hate slow loops... 😉
--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)

January 14, 2011 at 1:37 pm

#1273778
RE: Select column values as comma seperated format

andrewd.smith (1/14/2011)
Something like this should do for a character data type column. A numeric datatype column would just need a cast to a varchar (or nvarchar).
DECLARE @MyList varchar(max)
SET @MyList =...
--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)

January 14, 2011 at 1:32 pm

#1273776
RE: Merge performance on Very Large Tables

zerolan22 (1/14/2011)
To all you DB/SQL experts out there - I hope you can shed some light on my problems.
It sounds from your description as if it may be indexes causing...
--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)

January 14, 2011 at 8:07 am

#1273564
RE: Please help with SQL code

pwalter83 (1/11/2011)
The condition is if value in POL_COUNTRY_CD or POD_COUNTRY_CD column in table NCV_BL_DHL_TEMP begins with FR, then join to MG_LOCATION table to identify continent.
That's the whole problem in 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)

January 13, 2011 at 9:04 pm

#1273406
RE: UPDATE using a self-join

CELKO (1/13/2011)
Lowell (1/13/2011)
Horrible example, Celko; all it proves is the row used to to update the parent table is not guaranteed unless you make sure the joins form a 1: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)

January 13, 2011 at 8:25 pm

#1273404
RE: Are the posted questions getting worse?

Luke L (1/13/2011)
Stefan Krzywicki (1/13/2011)
jcrawf02 (1/13/2011)
Stefan Krzywicki (1/13/2011)
or we could follow Europe and Japan and let people operate vending machines with their phones.
Do what with their phone now? We should...
--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)

January 13, 2011 at 8:04 pm

#1273401
RE: Are the posted questions getting worse?

LutzM (1/13/2011)
Any of the Threadizens interested in a performance tuning project in the Los Angeles area? Drop me a PM.
I don't suppose there's a chance of doing it remotely, is...
--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)

January 13, 2011 at 7:58 pm

#1273399
RE: Are the posted questions getting worse?

Roy Ernest (1/13/2011)
This place rocks... I ask for help and I get tons of help. This is the second time I asked for help here and both the times 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)

January 13, 2011 at 7:56 pm

#1273398
RE: Are the posted questions getting worse?

Stefan Krzywicki (1/13/2011)
If they see a penny on the ground, they leave it there.
Maybe other folks will leave it, but I'll stop and pick it up. I've got 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)

January 13, 2011 at 7:53 pm

#1273396
RE: Are the posted questions getting worse?

Grant Fritchey (1/13/2011)
SQLkiwi (1/13/2011)
Grant Fritchey (1/13/2011)
Thank you very much. I've already shot this one in the head. I was working off a bad notion of how heaps are stored, so...
--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)

January 13, 2011 at 7:48 pm

#1273395
RE: Are the posted questions getting worse?

Jan Van der Eecken (1/13/2011)
Ray K (1/13/2011)
Ray K (1/12/2011)
Hey Threadizens -- I could use some advice on what I hope is a quick and easy question!
Thank you, fellow Threadizens, 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)

January 13, 2011 at 7:45 pm

#1273393
RE: substring funcation.

mister.magoo (1/13/2011)
Jeff Moden (1/13/2011)
mister.magoo (1/13/2011)
Jeff Moden (1/12/2011)
I'm a lightweight when it comes to XML. What are the two slashes and the [1] for?
The two slashes are the XML equivalent...
--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)

January 13, 2011 at 7:38 pm

#1273390

Viewing 15 posts - 35,386 through 35,400 (of 59,102 total)