Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,136 through 54,150 (of 59,098 total)

RE: is there any difference between != and <>

GilaMonster (11/14/2007)
Or if Jeff wants to produce the T-SQL, I can give the C# a try, but it won't be for a couple days.
Heck ya... great idea for a test,...
--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)

November 14, 2007 at 6:00 pm

#751320
RE: is there any difference between != and <>

Shaun McGuile (11/14/2007)
Good idea Gail, I'm not gonna get in the way of battling giants!:D
Matt said it right... "boys with their toys"... just having a bit of fun... c'mon 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)

November 14, 2007 at 5:55 pm

#751316
RE: can I Shrink the database?

KT (11/14/2007)
keep in mind that this is a DL380 and E is currently over 550GB so would this additional space be for moving E or would it be simply adding...
--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)

November 14, 2007 at 5:50 pm

#751314
RE: is there any difference between != and <>

Heh... you've hit SQL Server in it's weak spot... RegEx... I know that's what you'll build into your CLR and I've got a funny feeling I'm going to get my...
--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)

November 14, 2007 at 3:10 am

#751005
RE: unexplained database growth

In the moving of the data I forgot a job that deleted from 1 table, so in a weeks time this table became hugh.
So... you all set 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)

November 13, 2007 at 11:57 pm

#750966
RE: help me...

Okidoki... I'm not a "Systems DBA" so anything I'd say would probably be wrong on this... so the following URL's are the step by step instructions on how to do...
--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)

November 13, 2007 at 11:43 pm

#750959
RE: help me...

Data might not be gone if the database is in the "FULL RECOVERY" mode... can you check, please? Don't do a recovery, just yet...
--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)

November 13, 2007 at 11:32 pm

#750958
RE: INSERT A Record Based on Count

Absolutely! And to be fair, it IS a really extreme example... but put both pieces of code in a single QA window and run an estimated execution plan on...
--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)

November 13, 2007 at 10:24 pm

#750927
RE: INSERT A Record Based on Count

Actually - did you see my last post? Execution plan-wise, and processor effort-wise, CTE seems to be the "better choice".
Heh... they ALL say that until a job takes 8...
--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)

November 13, 2007 at 9:40 pm

#750920
RE: is there any difference between != and <>

I'll pick up that gauntlet.. How about we up the ante a little. Split the string, return the PK, the split value AND the index in the original string....
Heh......
--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)

November 13, 2007 at 8:56 pm

#750916
RE: INSERT A Record Based on Count

but we have others who are about to (use this to "gut" CTE's).
Like me! 😀
Heh... I don't need this thread to gut CTE's... most code examples that use them 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)

November 13, 2007 at 5:58 pm

#750899
RE: INSERT A Record Based on Count

I've found is that in some cases one is much better than the other two
In what way? Not necessarily looking for an example, but how were they better?
CTE 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)

November 13, 2007 at 5:38 pm

#750897
RE: to improve query response time

Vivien Xing (11/13/2007)
Comparing query performance from different server/SQL edition? It is supposed to compare based on the same server setting/configuration.
Isn't that like saying two different size dump trucks...
--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)

November 13, 2007 at 5:30 pm

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

Guess I'm just gonna have to document that proc from BOL... 😛
Andy, what the max number of parts a given assembly can have? There's a reason why I ask......
--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)

November 13, 2007 at 7:40 am

#750685
RE: How come no one post any job?

Grumpy... looks like you have PM disabled. Wanted to send you my cell phone number. Might be fun to get together and do some 12 ounce curls wilst...
--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)

November 13, 2007 at 7:36 am

#750682

Viewing 15 posts - 54,136 through 54,150 (of 59,098 total)