Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,056 through 44,070 (of 59,097 total)

RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

Lynn Pettis (4/24/2009)
Jeff, Do you have access to SQL Server 2008? At the SSWUGvConference I heard the the ORDER BY "may be" honored again in the UPDATE statement. ...
--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)

April 24, 2009 at 1:59 pm

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

bruce.trimpop (4/24/2009)
Jeff Moden (4/24/2009)
..... I'm talking about code that has been intentionally made slow....
That would seem to imply something malicious on the developers part "intentionally made slow" ?
That aside,...
--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)

April 24, 2009 at 11:39 am

#983726
RE: Crosstab type report -- Horizontal Summray

Ok... let's peel one potato at a time. Be gentle because I'm a data troll and don't even know how to spell things like ".adp". 😛
First, what parameters would...
--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)

April 24, 2009 at 10:51 am

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

I cannot speak for the others, but I'm not talking about code optimized to the nth degree... I'm talking about code that has been intentionally made slow because the developer...
--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)

April 24, 2009 at 10:45 am

#983684
RE: Problems using Bulk insert with a CSV file that has inconsistent quotes

WayneS (4/23/2009)
Leave it to Jeff to find another way with less code.:rolleyes:
Heh... I'm just lazy... I hate typing lots of code.
I learned how to do this just for the occasional...
--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)

April 24, 2009 at 10:36 am

#983677
RE: how to compare values in t-sql 2005

I'm thinking that once you can identify things that have more than 1 consecutive 5, you could probably write code to do anything you wanted. Here's the code 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)

April 23, 2009 at 9:51 pm

#983367
RE: XACT_ABORT ON

RJ (4/23/2009)
whether XACT_ABORT ON can be used in a stored procedure where you never use begin tran commit or rollback.
i have 2 insert, 1 updates, 1 delete in a stored...
--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)

April 23, 2009 at 7:49 pm

#983356
RE: insert record

doran_doran (4/22/2009)
That's funny. LOL.
How come people have all the time to comment on how to post?
Who really cares as long as it's not all that offensive?
I need some...
--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)

April 23, 2009 at 7:24 pm

#983350
RE: Finding the best way..

I sense extreme danger... someone tell me why you'd truncate a perfectly good archive table.
--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)

April 23, 2009 at 7:18 pm

#983348
RE: Problems using Bulk insert with a CSV file that has inconsistent quotes

Actually.... let's just say the data from the original post was stored on the server in C:\Temp and the filename was called SomeFile.txt
Then, you can do a little SQL prestidigitation...
--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)

April 23, 2009 at 7:01 pm

#983345
RE: Row Size

mithun.gite (4/23/2009)
Clear with the Max row size, it wont allow char to grow more than 8060 and varchar would reside in row upto 8060 and after that off tha page...
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)

April 23, 2009 at 6:09 pm

#983339
RE: Crosstab type report -- Horizontal Summray

Joseph,
Did you ever get this figured out?
--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)

April 23, 2009 at 5:40 pm

#983329
RE: Pivot tha data in this format

Thanks for the feedback. I always wonder if some of these suggestions get through or not.
--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)

April 23, 2009 at 5:32 pm

#983327
RE: Are the posted questions getting worse?

GSquared (4/23/2009)
"Bait and Switch".
BWAA-HAA!!! Energy drink my foot! It would be a heck of a name for a marriage counseling service. 😛
--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)

April 23, 2009 at 5:04 pm

#983322
RE: Are the posted questions getting worse?

Adi Cohn (4/23/2009)
Since we are sharing some bad code stories, I have to tell you the true and sad story from few years ago. At that time I was...
--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)

April 23, 2009 at 4:57 pm

#983319

Viewing 15 posts - 44,056 through 44,070 (of 59,097 total)