Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,921 through 37,935 (of 59,072 total)

RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Thomas-282729 (6/25/2010)
Nick Walton (6/25/2010)
I'm really looking forward to this series, as there's been a higher than average number of "Cursors are baaaaaad" posts on SSC recently. Your article...
--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)

June 25, 2010 at 7:53 am

#1185002
RE: Tuning

mike 57299 (6/23/2010)
Jeff Moden (6/23/2010)
Correct... the Tuning Advisor cannot see temp tables because they're usually created in another session. You'll need to make the table materialize while you're trying...
--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)

June 25, 2010 at 7:44 am

#1184996
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Michael Jenck (6/25/2010)
I have been trying to figure out a way to eliminate the following cursor. I figure this would be a good place to post this seeing 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)

June 25, 2010 at 7:38 am

#1184988
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

eq2home (6/24/2010)
Here is what I found out today from TechNet (Notice "the will be removed" language:
WITH CUBE
This feature will be removed in a future version of Microsoft 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)

June 25, 2010 at 7:13 am

#1184977
RE: Rename Temporary Table Name?

Eugene Elutin (6/24/2010)
Jeff Moden (6/24/2010)
Eugene Elutin (6/24/2010)
Jeff Moden (6/23/2010)
I don't believe so. Not in any forthright manner, anyway. Perhaps if you explained why you need to do 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)

June 24, 2010 at 7:52 am

#1184507
RE: 17 million rows to copy BCP or BULK INSERT or DTS?

quackhandle1975 (6/24/2010)
Found this out in the end.
DTS data copy with transformations bombed out after and hour so went with BCP file out from source db - which created a 4GB...
--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)

June 24, 2010 at 7:43 am

#1184501
RE: Rename Temporary Table Name?

Eugene Elutin (6/24/2010)
Jeff Moden (6/23/2010)
I don't believe so. Not in any forthright manner, anyway. Perhaps if you explained why you need to do such a thing, we could...
--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)

June 24, 2010 at 7:12 am

#1184474
RE: INSERT INTO SELECT WITH ORDER BY

{edit - comment withdrawn}
--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)

June 23, 2010 at 8:34 pm

#1184296
RE: data points

Are you sure it was "data points"? Data points can be "points" of data in XML, points (usually in pairs) on a chart, parts of an algorithm, or just...
--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)

June 23, 2010 at 8:12 pm

#1184292
RE: help using 'like' condtions

Ray K (6/23/2010)
Try something like this:select * from tableA
join tableB on tableA.drug like '%' + tableB.drug1 + '%'
I think this is the correct syntax. (Someone correct me if I'm...
--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)

June 23, 2010 at 7:57 pm

#1184284
RE: How to clean up the quatation

I haven't looked but isn't there something like a "Text Qualifier" property?
--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)

June 23, 2010 at 7:47 pm

#1184277
RE: Help needed

Actually, this is a duplicate post which has already been answered at the following...
http://www.sqlservercentral.com/Forums/Topic941870-392-1.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)

June 23, 2010 at 7:35 pm

#1184273
RE: Can I say that 'Clustered index scan' equals to 'table scan'? Or what is the difference?

hl6a (6/23/2010)
I am learning some basics about TSQL performance tuning. Some of the terms are confusing to me. Could somebody answer this simple question? Thanks.
The simple answer is "Yes" 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)

June 23, 2010 at 7:30 pm

#1184272
RE: Having trouble understanding the DateDiff command across year boundaries

huston.dunlap (6/23/2010)
Thank you for the answer. Sorry I got a little snide in that last post, wasn't the best day for me.
So let's ask the real question... do you need...
--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)

June 23, 2010 at 7:24 pm

#1184268
RE: Creating a Dynamic Temp Table

Unlike your other post, this one could probably be done but it would relegate most of your code to dynamic SQL. Why do you need to do this? ...
--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)

June 23, 2010 at 7:15 pm

#1184267

Viewing 15 posts - 37,921 through 37,935 (of 59,072 total)