Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,061 through 39,075 (of 59,072 total)

RE: Double-Entry Bookkeeping for SQL Programmers

"double-entry bookkeeping"
Heh... I've run into "double-entry" methods many, many times at a fair number of companies. The problem is that some people do it wrong to make...
--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 4, 2010 at 2:35 pm

#1145515
RE: Are the posted questions getting worse?

I usually don't even both looking at the QOD. I find the "real life" questions in the forums more interesting. 😉 The points come a little harder but...
--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 4, 2010 at 2:26 pm

#1145513
RE: Money

Heh... "fuzzy, forgiving input" that disregards just about all currency marks other than the decimal point except when set to the European format where periods represent commas and a comma...
--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 4, 2010 at 2:22 pm

#1145511
RE: Creating Indices on Temp Tables from Stored Procedures

kramaswamy (4/2/2010)
Sometimes I read comments on these forums, and others, where people are recommending very elegant solutions to problems, however, they don't always take in to account the amount of...
--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 4, 2010 at 2:03 pm

#1145509
RE: Creating Indices on Temp Tables from Stored Procedures

The Dixie Flatline (3/26/2010)
If a report is run once or twice a day, and you can take the runtime down to 10 seconds instead of several minutes, is it really...
--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 4, 2010 at 1:53 pm

#1145506
RE: Options for dealing with table Contention

(Way too much code involved in modifying them and it's not mine, it's a third party vendor's)
My first inclination is to invite the officers of the third party vendor'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)

April 4, 2010 at 1:09 pm

#1145500
RE: Which value should we use as a PK auto incremented or padded value???

Paul White NZ (4/4/2010)
sumit.joshij (4/3/2010)
While maintaining a database which values should we use as a PK. is it preferable to use auto incremented or our self generated padded values
say...
--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 4, 2010 at 12:04 pm

#1145487
RE: Using second SQL server for running reports

keith.littlejohn (4/1/2010)
I am running SQL 2005 Ent edition. We have an application that runs on our SQL 2005 server and when users try to run reports off that database,...
--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 4, 2010 at 11:53 am

#1145486
RE: Foreign key constraints...WHY??

PaulB-TheOneAndOnly (4/4/2010)
david_wendelken (4/4/2010)
I start with the premise that the data is supposed to be valid. That's, on occasion, NOT a business requirement at all. (Sometimes the business requirement...
--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 4, 2010 at 11:15 am

#1145480
RE: DateTime input with time always at 00:00:00.0000

Paul White NZ (4/3/2010)
Paul White NZ (3/22/2010)
Same goes for the CHAR conversion (if done with a deterministic style) and FLOAT (2008 only).
^^^ Hey Jeff 😉 ^^^
Hey Paul...
-- Persisting whole_date2 only...
--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 3, 2010 at 11:20 am

#1145361
RE: Removing duplicates and keeping 1 record with no PK

lmu92 (4/3/2010)
olie480 (4/2/2010)
Jeff Moden (4/2/2010)
Deleting data that is supposedly duplicated by FirstName and LastName is a very good way to have a sudden and very unwelcome career change. There...
--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 3, 2010 at 11:19 am

#1145360
RE: Speeding up a fast forward cursor proc

Paul White NZ (4/3/2010)
Jeff Moden (4/2/2010)
Heh... jeez... doesn't anyone use a plain ol' zip file anymore? 😉
RAR is a great choice - after all, it doesn't take 10 minutes to...
--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 3, 2010 at 11:14 am

#1145359
RE: Output columns from lowest to highest in a pivot type query help

Garadin (4/2/2010)
I've read several of that guys articles, good stuff. 😉
Heh... thanks, Seth. Good finish to a long day.:-)
--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 2, 2010 at 10:31 pm

#1145220
RE: Selecting list of month numbers between two dates

Ok... thanks for the feedback.
--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 2, 2010 at 10:29 pm

#1145219
RE: The Missing Certification

Gosh... :blink: You would think that an MCM would be required to know how to distinguish between good code and bad code as part of some sort of "performance...
--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 2, 2010 at 9:28 pm

#1145212

Viewing 15 posts - 39,061 through 39,075 (of 59,072 total)