Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,231 through 40,245 (of 59,072 total)

RE: select query for only changed rows

The original post seems to suggest that this is all for a staging table upsert into a main table (or maybe I've not had enough coffee). I'd recommend 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 16, 2010 at 12:37 pm

#1104636
RE: Deadlock on single Table, when DELETE

Even better.
--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 16, 2010 at 11:31 am

#1104627
RE: @@error

stephenhai (1/15/2010)
Thanks...
Anythings need to pay attention when upgrade from 2000 to 2008
When you say "upgrade", I think "in place upgrade" and I wouldn't do it that way. I'd have...
--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 16, 2010 at 11:23 am

#1104625
RE: select query for only changed rows

Even that may not do it... you can update a row with the same data as what it started with and the TimeStamp will still change.
--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 16, 2010 at 11:17 am

#1104622
RE: Deadlock on single Table, when DELETE

You might also consider saving your Word docs as a Word 97-2003 compatible doc because you cut out a lot of people who don't have Word 2007 from helping you....
--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 16, 2010 at 11:02 am

#1104621
RE: Table design/select statements - rows to columns (T-SQL)?

Question 3:
Why do you want to denormalize the result this way? The answer could make a difference.
Also, what is the maximum number of banks you will handle in such...
--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 16, 2010 at 10:57 am

#1104619
RE: Need help with comma seperated quoted string

dhanu-1026978 (1/15/2010)
Set QUOTED_IDENTIFIER OFF did the trick.
Thanks.
Maybe it made it work for > 128 characters but what about performance? My recommendation would be to post the code for 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)

January 16, 2010 at 10:52 am

#1104617
RE: Need help landing first job

SQL08Kid (1/15/2010)
I've been using databases for a little over 2 yrs now and feel it's time to start my "DBA" career. There's NEVER any Jr. DBA job postings so 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 16, 2010 at 10:37 am

#1104615
RE: Use of a VARCHAR(MAX) in a Non-Clustered Index?

You bet... thanks for the feedback, Lee.
--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 16, 2010 at 10:25 am

#1104610
RE: Local Temporary Tables and Table Variables

Ken Shapley (1/15/2010)
I've read a some articles on Table variable vs Temp Table performance and I have found them lacking good explaination. This one left me hanging at the end...
--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 16, 2010 at 8:39 am

#1104600
RE: Use of a VARCHAR(MAX) in a Non-Clustered Index?

Michael Valentine Jones (1/16/2010)
If you really need to do an exact match lookup on a varchar(max) column, you can add a computed column that contains a checksum of the varchar(max)...
--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 16, 2010 at 8:23 am

#1104599
RE: Sub-queries vs correlated sub-queries

Heh... maybe I should turn it into an article... the question does come up often enough. That's how my very first article was born... the one on hidden RBAR...
--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 16, 2010 at 8:10 am

#1104598
RE: splitcsv

arun.sas (1/15/2010)
Jeff Moden (1/15/2010)
Would you share with us why you want to do this unusual thing first?
Hi Jeff,
The OP needs to set the posted function (may created for another reason)...
--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 16, 2010 at 8:05 am

#1104597
RE: Query Performance: Batch or Procs

bigj77s (1/15/2010)
I thought a more efficient approach might be to package up all queries for that web page in a single batch, and execute it once. Rather than calling...
--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 15, 2010 at 9:10 pm

#1104551
RE: splitcsv

Would you share with us why you want to do this unusual thing first?
--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 15, 2010 at 8:46 pm

#1104549

Viewing 15 posts - 40,231 through 40,245 (of 59,072 total)