Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,531 through 52,545 (of 59,072 total)

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

This has all been totally awesome! Give yourselves a huge pat on the back... 122 posts on a fairly controversial subject and no flame wars. My hat is...
--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)

February 14, 2008 at 7:12 pm

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

Yep... tested the heck out of the CTE solution with ROW_NUMBER() for the running balance... without the clustered index on the appropriate columns, if falls apart in that the running...
--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)

February 14, 2008 at 6:57 pm

#778670
RE: The switch to Oracle

gints.plivna (2/14/2008)
If one gets a new car by another vendor he understands that the core functionality is the same i.e. the car can be driven but switches, detectors, the general...
--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)

February 14, 2008 at 6:24 pm

#778666
RE: The switch to Oracle

JohnG (2/14/2008)
Heh... thanks Steve... I'll consider it. It would be very difficult, though, because I break out in a bad case of Tourette's syndrome every time I try to do...
--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)

February 14, 2008 at 6:18 pm

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

Christopher Ford (2/13/2008)
Earlier Jeff posted a question on using SUM(SAL) OVER()
Since OVER() doesn't support ORDER BY when used with an aggregation.
How about this one?
SELECT J1.AccountID,
J1.Date,
...
--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)

February 14, 2008 at 5:06 pm

#778642
RE: CLR

While I certainly agree that one should use the right tool for the right job, I'll also be the first to disagree about the shorter the code, the faster 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)

February 14, 2008 at 6:11 am

#778305
RE: The switch to Oracle

Steve Rosenbach (2/14/2008)
Hey Jeff!
Sounds like you're a good candidate to write "ORACLE for SQL Server Developers." 🙂
Seriously, would you consider writing an article for SQLServerCentral.com about some of 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)

February 14, 2008 at 5:56 am

#778300
RE: Help With Query

Agreed... basically the same... I've got an extra "Compute Scalar" 'cause of the formatting I did...
--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)

February 13, 2008 at 11:00 pm

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

Well stated in both posts, Christopher... But, you've been spoiled by SS 2k5... none of that works in 2k and, I don't know about other folks, but the companies I've...
--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)

February 13, 2008 at 10:51 pm

#778205
RE: The switch to Oracle

Although a lot of this information is several years old, the "basics" still apply.
No, they really don't.
In SQL Server, the UPDATE statement has a FROM clause where you can do...
--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)

February 13, 2008 at 10:31 pm

#778200
RE: Combing two dates into on column

Just curious, Art... haven't seen it before... what does a "Database Analyst" do? In other words, what's the job description for a "Database Analyst"?
--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)

February 13, 2008 at 9:27 pm

#778184
RE: Help With Query

Aaron,
This should do it... also, take a look at how I created the test table and data... would help a lot if you could post sample data like that in...
--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)

February 13, 2008 at 9:15 pm

#778183
RE: At what size db does it make sense to split into multiple files?

Christopher Ford (2/13/2008)
Jeff, I could almost hug you actually...you wrote an article the other day that I have been working a problem for 6 months on trying to solve. ...
--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)

February 13, 2008 at 8:50 pm

#778180
RE: Bulk insert question

Vika (2/4/2008)
OK you are right. It is not possible to bulk insert from the file into a table variable. It is possible to bulk insert from the file into a...
--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)

February 13, 2008 at 6:27 pm

#778168
RE: At what size db does it make sense to split into multiple files?

Tom Leykis (2/13/2008)
Ok, this will really light your fire :hehe:
The reason I was asking is becuase it's my database, for my company, that I manage the db for, because 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)

February 13, 2008 at 5:57 pm

#778162

Viewing 15 posts - 52,531 through 52,545 (of 59,072 total)