Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,661 through 36,675 (of 59,072 total)

RE: Need help in this query

@sql.abhishek,
So! Are you all set or what? If you're all set, would you mind posting your final solution so that others may learn, please? Thanks.
--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)

September 19, 2010 at 1:49 pm

#1223700
RE: Converting a table variable into a permanent table

Jamie Julius (9/18/2010)
Thanks, guys.
The reason I asked is because the table in question is very large (about 1,000,000 records). Using SELECT INTO takes a couple of minutes to complete 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)

September 19, 2010 at 1:29 pm

#1223699
RE: I need some help with a test, please.

bitbucket-25253 (9/19/2010)
Jeff ran test on the oldest, least amount of memory, slowest desktop, age - older than dirt. Running Windows XP
Result for SQL 2005 Express using code after it...
--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)

September 19, 2010 at 1:17 pm

#1223697
RE: Are the posted questions getting worse?

GilaMonster (9/19/2010)
Is my irritation with this guy justifiable, or a product of a mostly wasted day? (well, until his last post that is)
http://www.sqlservercentral.com/Forums/Topic988907-391-1.aspx
Maybe it's just me but I didn't see...
--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)

September 19, 2010 at 1:13 pm

#1223696
RE: Are the posted questions getting worse?

GilaMonster (9/19/2010)
Jeff Moden (9/19/2010)
GilaMonster (9/19/2010)
Steve Jones - Editor (9/19/2010)
Gail will be harder since she's in South Africa, and a lot "sends" don't quite get there. I'll have to work 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)

September 19, 2010 at 1:07 pm

#1223695
RE: Convert CSV values in three columns to rows

Oleg Netchaev (9/18/2010)
Jeff,
So far, I can see that I use the same setup as far as the tally creation is concerned. The collation is of course the same 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)

September 19, 2010 at 12:57 pm

#1223692
RE: I need some help with a test, please.

steve-893342 (9/19/2010)
Paul White NZ (9/19/2010)
steve-893342 (9/19/2010)
Yes, but if you compare the two to shift data either with a SELECT INTO or INSERT query you won't see that sort of difference
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)

September 19, 2010 at 12:13 pm

#1223687
RE: I need some help with a test, please.

LutzM (9/19/2010)
The other reason: it became a habit to "eye-scan" each code snippet I run off the web, regardless of the source.
Ohhh yeahhh... do I ever agree with 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)

September 19, 2010 at 12:10 pm

#1223686
RE: Are the posted questions getting worse?

Steve Jones - Editor (9/19/2010)
OK, no pork chop launcher, or even ammo, but a small gift to Jeff for his support.
Oh my... I'm not sure how to get this big...
--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)

September 19, 2010 at 11:22 am

#1223663
RE: Are the posted questions getting worse?

GilaMonster (9/19/2010)
Steve Jones - Editor (9/19/2010)
Gail will be harder since she's in South Africa, and a lot "sends" don't quite get there. I'll have to work with RG on something.
Redgate's...
--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)

September 19, 2010 at 11:10 am

#1223660
RE: I need some help with a test, please.

gah (9/19/2010)
Jeff Moden (9/19/2010)
gah (9/19/2010)
version 2 resullts attached.
regards Graham
Now THAT's interesting! Even though the "XML-1 (Split8KXML1 mlTVF)" multi-line table valued still uses more logical reads, it still beat 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)

September 19, 2010 at 10:08 am

#1223648
RE: I need some help with a test, please.

Paul White NZ (9/19/2010)
Version 2 results...:satisfied:
Hmmmm... The XML-1 mlTVF that I originally cobbled together beat the new additions by almost 4:1 that time.
Just to give credit where credit is due,...
--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)

September 19, 2010 at 10:00 am

#1223646
RE: I need some help with a test, please.

ColdCoffee (9/19/2010)
Jeff, this is from environment 2..
~Edit : all my tests will be over the desktop machines, i dont have laptop yet, Jeff.. Rest of the eonvironments, i will give...
--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)

September 19, 2010 at 9:46 am

#1223643
RE: I need some help with a test, please.

Paul White NZ (9/19/2010)
Jeff Moden (9/19/2010)
Because I honestly don't know, let me ask if the SQLCLR will "uncache" like an old execution plan might and, if it does, will it...
--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)

September 19, 2010 at 9:44 am

#1223641
RE: I need some help with a test, please.

gah (9/19/2010)
version 2 resullts attached.
regards Graham
Now THAT's interesting! Even though the "XML-1 (Split8KXML1 mlTVF)" multi-line table valued still uses more logical reads, it still beat the new addititions for...
--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)

September 19, 2010 at 9:42 am

#1223640

Viewing 15 posts - 36,661 through 36,675 (of 59,072 total)