Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,291 through 34,305 (of 59,099 total)

RE: Are the posted questions getting worse?

Brandie Tarvin (4/12/2011)
I've actually found, in some circumstances, cursors are faster than WHILE Loops.
R-e-s-i-s-t-i-n-g u-r-g-e... t-e-c-h-n-i-c-a-l c-h-a-l-l-e-n-g-e o-n t-h-r-e-a-d... GAH!!! M-U-S-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)

April 12, 2011 at 10:52 am

#1310525
RE: Are the posted questions getting worse?

bitbucket-25253 (4/11/2011)
Jeff Moden (4/11/2011)
WayneS (4/11/2011)
Jeff, I never did get this. Did you miss my previous post to send it on?
Apparently so. I'll send it out when I get home...
--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)

April 12, 2011 at 10:46 am

#1310519
RE: Are the posted questions getting worse?

Trey Staker (4/11/2011)
Some people no matter how wrong they may be will not accept the fact that they are wrong or that there is a better way of doing things.
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)

April 11, 2011 at 5:17 pm

#1310163
RE: Are the posted questions getting worse?

Craig Farrell (4/11/2011)
Ho Boy. How did you fill your PM box up quickly Jeff? :hehe:
I wore a shirt with a Gila Monster on it. 😛
--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)

April 11, 2011 at 3:47 pm

#1310148
RE: Are the posted questions getting worse?

GilaMonster (4/11/2011)
After 30 minutes of arguing about set theory, equivalence of statements, testing requirements and development methodology I gave up and discarded the changes.
That's why I try to let 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)

April 11, 2011 at 3:41 pm

#1310146
RE: Are the posted questions getting worse?

WayneS (4/11/2011)
Jeff, I never did get this. Did you miss my previous post to send it on?
Apparently so. I'll send it out when I get home tonight. Thanks,...
--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)

April 11, 2011 at 3:36 pm

#1310142
RE: Normals not my friend anymore....

medwar19 (4/11/2011)
Hey,
thanks for your reply
To answer your question I need the IDs to enter new data that has previous entries. Maybe this is where I'm going wrong? If I 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)

April 11, 2011 at 3:33 pm

#1310141
RE: Recursive query for a Bill of Materials table

david.moule (4/11/2011)
Hi Jeff,
I got your .net email and have sent a test reply to it.....
I didn't get it as of 5:26 PM
--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)

April 11, 2011 at 3:26 pm

#1310138
RE: Recursive query for a Bill of Materials table

david.moule (4/11/2011)
Using the BOL article on "Expanding Hierarchies"... I took the example code and modified it as below. My problem is that it needs the top level BOM in order...
--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)

April 11, 2011 at 3:22 pm

#1310136
RE: Tuning image datatype

Do you have an index on GLCDS.MODNR ?
--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)

April 11, 2011 at 6:55 am

#1309788
RE: PIVOT function

Yes. Make a backup just before you do the change and have the users test it before you bring it back into service.
--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)

April 11, 2011 at 6:53 am

#1309784
RE: Script Database relations

a.ghasemi (4/10/2011)
well
I want to script only database relations without table script except the script must have all 'drop relation' statements,then it must contain 'create relation' statements,[font="Arial Black"]is there any...
--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)

April 11, 2011 at 6:02 am

#1309762
RE: PIVOT function

vilonel (4/11/2011)
nigel. (4/11/2011)
That only tells you the versions of the client tools etc installed on your machine, not the version of the database engine.
Run this in a query window:
SELECT...
--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)

April 11, 2011 at 5:38 am

#1309750
RE: SQL Injection Everywhere

paul.knibbs (4/11/2011)
Jeff Moden (4/10/2011)
How about spending more time and dollars on really cool stuff like designing a 350HP engine that gets 50MPG without batteries?
Because it's impossible? Petrol and diesel engines...
--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)

April 11, 2011 at 5:33 am

#1309748
RE: full-text indexing with partical word

I checked in Books Online and found Prefix-Terms where you can use a trailing asterick but no place where you use a leading asterick.
I'm not 100% sure but I don'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)

April 11, 2011 at 5:22 am

#1309745

Viewing 15 posts - 34,291 through 34,305 (of 59,099 total)