Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,811 through 33,825 (of 59,099 total)

RE: Problem With Recursive CTE

opc.three (5/30/2011)
Jeff Moden (5/30/2011)
Are you suggesting that you want only leaf-level information no matter which part you ask for? 🙂
That's what I got out of it this time around but...
--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)

May 30, 2011 at 11:24 am

#1331698
RE: Problem With Recursive CTE

David-155102 (5/30/2011)
Hi Jeff,
I see your point; if I change the test data to the following then "Part G" is not returned when it should be :crazy::
Ok... and I'm not being...
--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)

May 30, 2011 at 9:42 am

#1331669
RE: Query Help

flash.rsn (5/29/2011)
I need help for following scenario.
I have a table tb1 with following datetime columns.
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10......so on
A trigger will update the each column with following conditions.
e.g if last column having null/empty...
--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)

May 29, 2011 at 12:54 pm

#1331467
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (5/29/2011)
Jeff Moden (5/28/2011)
Steve Jones - SSC Editor (5/27/2011)
Now we got the $27k Prius in '07, but got a $1500 tax credit and saved a ton...
--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)

May 29, 2011 at 11:31 am

#1331456
RE: which type of data or objects stored in mdf and logfiles

Gail's summary is spot on. For more information, start at the following URL...
http://msdn.microsoft.com/en-us/library/ms179316.aspx
--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)

May 29, 2011 at 10:50 am

#1331449
RE: Problem With Recursive CTE

David-155102 (5/26/2011)
Using "Part D" as the example the result would be the following components:
Part X
Part W
Part Y
Gosh... what would you want if Part Z had more than just Part Y...
--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)

May 29, 2011 at 10:30 am

#1331445
RE: strange problem

If you were to also update a "LastModifiedOn" column for the row when you set the flag to "USE", you could mod your program to check for the time difference...
--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)

May 29, 2011 at 10:14 am

#1331443
RE: Hi,small clarification............

Google is your friend... click the following link 😉
http://tinyurl.com/3dxz5ql
--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)

May 29, 2011 at 10:01 am

#1331440
RE: Query performance - 3 part name

BTW... you can also remove the DISTINCT. It serves no purpose because WHERE/IN stops at the first occurance it finds. The DISTINCT is just burning some extra clock...
--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)

May 29, 2011 at 9:47 am

#1331438
RE: Query performance - 3 part name

allmhuran (5/29/2011)
a simpler hd.returnNo is not null and hd.returnNo != ''
You can actually go even simpler and faster because it only has one decision to make...
hd.returnNo > ''
But neither...
--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)

May 29, 2011 at 9:41 am

#1331437
RE: Looking for Work in SQL Server

Jake Shelton (5/26/2011)
...there are aspects of my new field that take time to develope,...
If you stated it, I'm sorry I missed it. Which new field did you jump...
--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)

May 28, 2011 at 10:22 pm

#1331387
RE: Are the posted questions getting worse?

Roy Ernest (5/27/2011)
GSquared (5/27/2011)
SQLkiwi (5/26/2011)
Steve Jones - SSC Editor (5/26/2011)
I'll say that most of the better applications were self-written. It's hard for someone else to do a good job listing...
--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)

May 28, 2011 at 10:10 pm

#1331386
RE: Are the posted questions getting worse?

Roy Ernest (5/27/2011)
Congrats Gail and Grant. That means if things go as planned, I can meet all of you at the Summit.
I had a great time hanging around with...
--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)

May 28, 2011 at 10:03 pm

#1331384
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (5/27/2011)
Now we got the $27k Prius in '07, but got a $1500 tax credit and saved a ton of gas.
What did it do to your...
--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)

May 28, 2011 at 10:01 pm

#1331383
RE: I would like to get the distinct value from specified column. I would appreciate if any one provide the answer of this

I don't know for sure but I'd almost bet the number of reads and writes being different from run to run are because I'm writing to disk and SQL Server...
--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)

May 28, 2011 at 9:54 pm

#1331381

Viewing 15 posts - 33,811 through 33,825 (of 59,099 total)