Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,201 through 31,215 (of 59,101 total)

RE: multiple update statements to update the same table

I think his mindset is just fine, Joe. It is frequently much faster to employ such "Divide'n'Conquer" methods rather than trying to do everything in a single query. ...
--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)

February 11, 2012 at 9:39 pm

#1445990
RE: One thing I keep missing in SQL

Samuel Vella (2/8/2012)
Usually I end up with either CTE's or similar to try and make the SQL more readable.
Are there any better work arounds?
Actually, the CTE method you speak of...
--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)

February 11, 2012 at 9:36 pm

#1445989
RE: SELECT statement issue, spread by YYYYMM

Digs (2/11/2012)
Sir, I am an old fart working on a private project...just needed a little help !
Thanks 🙂
Jeez, Digs. The 2nd Cross Tab article that Lutz pointed you 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)

February 11, 2012 at 9:22 pm

#1445987
RE: Totaling 1 row's #'s from a distinct related row

Thanks for the test data setup code. It makes it a whole lot easier and timely for me to help.
Here's your test data and the solution. It returns...
--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)

February 11, 2012 at 9:16 pm

#1445985
RE: group by & having or ranking

Shamelessly borrowing from Mark's good code for test data, we can simplify both the code and the results a bit...
--===== Create the test table/data
DECLARE @t TABLE(PNumber VARCHAR(2),ReasonCode VARCHAR(2))
INSERT INTO...
--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)

February 11, 2012 at 5:05 am

#1445901
RE: Server is slwo in Production Server

Even after passing Gail's "Magic Wand" over this (and you really should read her article if you haven't already), LIKE filters that begin with a wild-card will always be tough...
--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)

February 11, 2012 at 4:20 am

#1445893
RE: DBA task if Production is Down

First, get 3 envelopes... 😉
--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)

February 11, 2012 at 4:06 am

#1445891
RE: Totaling 1 row's #'s from a distinct related row

pharmboy4u (2/11/2012)
Hello,
Sorry I'm not posting in a table form, I don't create them so I'm not fluent in the lingo and it would take me forever
No it wouldn'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)

February 11, 2012 at 3:57 am

#1445889
RE: Salary question (London)

Shark Energy (1/19/2012)
Anyone have any idea how you would price up the following roles? Job sites seem to vary so much...
1) DBA Team Leader
2) Software Development Manager WITH DBA responsibility
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)

February 11, 2012 at 3:53 am

#1445887
RE: Remove HTML from varchar field?

Rob-350472 (2/8/2012)
I've got a varchar(max) field which I've just discovered contains data like this:
Blah blah blah <a href=" /xxx/yy/bbb.aspx?ID=111111 "> Entity Name </a>, blah blah blah...
I'm trying to retrieve...
--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)

February 11, 2012 at 3:49 am

#1445885
RE: Need to tune SQL

kiran.rajenimbalkar (2/8/2012)
Hi Professional,
I need your help to solve this issue.
I need to tune this my SQL mentioned below,
SELECT ind.ind_cst_key,
...
--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)

February 11, 2012 at 3:44 am

#1445880
RE: One thing I keep missing in SQL

CELKO (2/8/2012)
your mindset is still stuck in procedural languages. Instead of working from left to right, an entire row comes into existence ALL AT ONCE. This is not magnetic tapes...
--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)

February 11, 2012 at 3:32 am

#1445875
RE: Inline table-valued functions and multi-statement TVFs

Rowles (2/9/2012)
When would you use a temporary table instead of an inline table-valued function?
Is an inline table-valued function the same as a multi-statement TVF that only had one table-valued 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)

February 11, 2012 at 3:22 am

#1445872
RE: Rouge Cross Server Update, Updates the Wrong Rows

About the only time I've seen this problems is when folks looked at the wrong server. Double check where the linked server is pointing 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)

February 11, 2012 at 3:13 am

#1445870
RE: What are the minimum events and fields I need to capture to find the cause of log growth ?

Joy Smith San (2/10/2012)
Thanks a lot.
Often times index maintenance is the culprit in this case or some kind of bulk-load process. If there are no scheduled jobs that...
--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)

February 10, 2012 at 6:53 pm

#1445848

Viewing 15 posts - 31,201 through 31,215 (of 59,101 total)