Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,401 through 41,415 (of 59,098 total)

RE: Understanding INNER join in detail

Toby White (10/23/2009)
Anyway, I just have one thing to add. Why not use:
INSERT #InnerJoinTest1
DEFAULT VALUES
go 5
Instead of:
WHILE SCOPE_IDENTITY() <5 OR SCOPE_IDENTITY() IS NULL
Ummmm... because that's RBAR as well? 😉
--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)

October 23, 2009 at 7:14 pm

#1070314
RE: Understanding INNER join in detail

I realize this is a republished article from some time ago but I agree with many of the others ... if you understand that the author probably speaks English as...
--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)

October 23, 2009 at 7:12 pm

#1070313
RE: Understanding INNER join in detail

RobinC-661862 (10/23/2009)
While this was a good beginner article and I liked the visual references, there is a serious danger in showing this to beginners - Joins with > and <...
--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)

October 23, 2009 at 6:45 pm

#1070310
RE: Understanding INNER join in detail

Former Member (7/8/2008)
Gischump is absolutely correct. I apologize for the rude remarks and concur with the earlier post that this should never have been published w/o first being edited....
--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)

October 23, 2009 at 5:52 pm

#1070299
RE: Need to pull mulitple row communication infor into single row per customer

Heh... does it like pork chops? 😛
--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)

October 23, 2009 at 5:43 pm

#1070297
RE: Concatenating Rows

Roxy Wehner (10/23/2009)
Good question! In the nested select you can filter, manipulate and cleanup the data as much as necessary before replacing the space delimiter with your choice 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)

October 23, 2009 at 5:37 pm

#1070296
RE: TSQL Question about getting data

Understood... been through that a couple of million times. Lemme know how it works out for you when you get the chance.
--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)

October 23, 2009 at 4:00 pm

#1070284
RE: Finding difference of cumulative values in a table

Just a word of caution... I strongly recommend that you use OPTION (MAXDOP 1) in order to prevent any parallelism during the "Quirky Update' which would destroy the procedural nature...
--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)

October 23, 2009 at 3:57 pm

#1070282
RE: Summing differences between time stamps

Heh... is that what it is? I'm going to have to get a copy of that book. You don't happen to have the ISBN for it do 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)

October 23, 2009 at 6:00 am

#1069932
RE: Using synonyms to redirect queries

To be clear, you only need one synonym and you alter it to change where it's pointed.
--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)

October 23, 2009 at 5:57 am

#1069930
RE: String functions

ChiragNS (10/23/2009)
good one Jeff. Can u explain this part - ORDER BY (SELECT 1). I looked up the order by clause but did not fully understand.
Sure... at the minimum, 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)

October 23, 2009 at 5:51 am

#1069926
RE: The Value of Experience

I'm going to take the opposite stance from a lot of other folks. Sure, I believe that you have to know other "stuff" to be a good DBA or...
--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)

October 23, 2009 at 12:05 am

#1069812
RE: Populate rows with column values, but not a pivot!

It's easy and I found Ginger...
See the first link in my signature below to provide a CREATE TABLE statement and some sample data so we can show you how.
--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)

October 22, 2009 at 11:57 pm

#1069807
RE: Need to pull mulitple row communication infor into single row per customer

BWAA-HAA!!! What downside? Just think of it... you store everything in one table and you only need one index. Simplicity at it's best. :-P:-D;-)
(For those not familiar...
--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)

October 22, 2009 at 11:53 pm

#1069804
RE: String functions

Loops are slow... break the habit of using them. 😉
SELECT TOP 10 RIGHT('000'+CAST(ROW_NUMBER() OVER (ORDER BY (SELECT 1))-1 AS VARCHAR(3)),3)
FROM Master.sys.All_Columns
--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)

October 22, 2009 at 11:48 pm

#1069803

Viewing 15 posts - 41,401 through 41,415 (of 59,098 total)