Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,691 through 54,705 (of 59,089 total)

RE: Convert 2005 table valued function to 2000

A big key here is that David DIDN'T even use a function (although you could if it's for RBAR GUI code)... it splits a whole table's worth of information 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)

October 9, 2007 at 7:16 am

#740339
RE: Merging two tables

Heh... I cheat like hell... load up one staging table with everything... delete the dupes with the "earliest" information... flip the pass-through-view to look at the new table... drink beer...
--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)

October 8, 2007 at 8:56 pm

#740216
RE: SQL Server 2000 Slow response time

Ramesh Lende (10/8/2007)
I am leaving in remote area of Pennsylvania where it is difficult to find out one DBA. People are coming and they don’t like the place so they...
--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)

October 8, 2007 at 8:47 pm

#740215
RE: SQL Server 2000 Slow response time

Backups... if for nothing else, to clear log files that are getting big and growing.
--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)

October 8, 2007 at 8:44 pm

#740213
RE: The USE command

Most people recommend against it for many reasons... most of them are good, some are not... but you could put a view in the Master database and that would draw...
--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)

October 8, 2007 at 8:34 pm

#740212
RE: Update with NULL value

nba (10/4/2007)
The problem now is not the trigger but why it was there and not documented.
Simple... database is not correctly locked down for changes. No one but DBA's should...
--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)

October 8, 2007 at 8:21 pm

#740211
RE: Update Order and MAXDOP

Works fine for what you have... no primary key.
To help, I need to know what you expect the output of your first post to be...
--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)

October 8, 2007 at 7:58 pm

#740210
RE: Putting image files in sql server 2005

You'd need to split out the images into separate files...
--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)

October 8, 2007 at 5:25 pm

#740198
RE: Why SQL Server is Better Than Oracle

We handle some pretty heavy loads, as well, but on the SQL Server side... that is, when folks stop trying to write Oracle code for 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)

October 8, 2007 at 5:21 pm

#740194
RE: Better way to write?

Even better!
--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)

October 8, 2007 at 5:18 pm

#740192
RE: Current Order Date and Average Count of Orders for Three Prior Days

David (10/6/2007)
Thanks Jeff! I was hoping you would respond. You always have such brilliant responses!!
Many thanks!!
Heh... thanks David :blush:
But, Serqiy's observations are spot on and I was actually...
--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)

October 8, 2007 at 5:01 pm

#740191
RE: Current Order Date and Average Count of Orders for Three Prior Days

Jack Corbett (10/8/2007)
I had a solution I was going to post but Jeff's was faster by magnitudes. I'd go with his solution.
Heh... :blush: Thanks for the Kudo, Jack......
--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)

October 8, 2007 at 4:51 pm

#740190
RE: Current Order Date and Average Count of Orders for Three Prior Days

Sergiy (10/8/2007)
I believe this topic is a perfect illustration for the article "Why programmers cannot program?".
They take care about everything - formatting, performance, style, but ignore building correct algorithm absolutely.
Absolutely...
--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)

October 8, 2007 at 4:45 pm

#740188
RE: Current Order Date and Average Count of Orders for Three Prior Days

Sergiy (10/6/2007)
What about days having no orders?
What if nobody made any order on Tuesday?
Jeff, don't you think the Thursday calculation should include zero orders for Tuesday, not whatever number...
--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)

October 8, 2007 at 4:41 pm

#740186
RE: How to model credit card transaction process?

Guess my other question would be... why do you even need this type of info in a fact table or dimension? This should be simple lookup data.
--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)

October 8, 2007 at 4:27 pm

#740185

Viewing 15 posts - 54,691 through 54,705 (of 59,089 total)