Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,261 through 52,275 (of 59,098 total)

RE: Sequence number with Group By

Heh... yeah, I'll just bet he would, Micheal...
http://www.sqlservercentral.com/articles/T-SQL/61539/
--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 29, 2008 at 1:40 pm

#784037
RE: Include end date on a history record?

Lynn Pettis (2/29/2008)
Jeff, I'll give you an "It depends". Yes, it is the start date of the current record, and it with the StatuteId does uniquely identify a single...
--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 29, 2008 at 1:15 pm

#784023
RE: Sequence number with Group By

John Mitchell (2/29/2008)
No. Probably the easiest way is to create a temp table with an identity column, insert your rows into that, then select from it.
John
I'll third 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)

February 29, 2008 at 1:10 pm

#784019
RE: What about MONTH and YEAR functions?

For too many reasons to list in this short amount of space, I strongly recommend that you never process dates by individual Year and/or Month components. 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 29, 2008 at 12:20 pm

#783991
RE: Who is responsible for databases: DBA or Admins

Ummm... I've seen questions like this go back and forth and even some flame wars get started over it and similar things like privs on the Windows Server, etc.
I think...
--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 29, 2008 at 10:05 am

#783935
RE: I got burned today at a SQL Server Interview!

Grant Fritchey (2/29/2008)
I don't know, I've seen your posts. You look pretty knowledgeable.
I gotta agree with that... you're no slouch, Jack.
BTW, we are hiring over here in the Island 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)

February 29, 2008 at 9:51 am

#783931
RE: I got burned today at a SQL Server Interview!

Hey Jeff, when you are hiring let me know, I'd like to work with you so I can improve my SQL skills.
The feeling is mutual, 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)

February 29, 2008 at 9:44 am

#783919
RE: I got burned today at a SQL Server Interview!

I have to disagee with Jeff on this one.
Oh... wait a minute folks... I didn't mean to make it look like I was condoning this dis-honesty... not even for 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 29, 2008 at 9:42 am

#783914
RE: Include end date on a history record?

Lynn Pettis (2/29/2008)
Jeff,
Could you do it in SQL 2000 with a tally table and derived tables?
😎
Ummm... I don't think so... a running update would do it though... certainly 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 29, 2008 at 8:44 am

#783834
RE: Include end date on a history record?

MattieNH (2/29/2008)
Jeff, correct me if I've screwed up my terminology, but isn't the normalized design the one without a StopWeightEffectiveDate column, ...
I'll probably get some argument from others here,...
--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 29, 2008 at 8:40 am

#783830
RE: Index management - rebuild/reorganize/dbreindex & fillfactor

Adam Bean (2/29/2008)
Ok, but what if you don't pass a fillfactor? Does it default to it's original value or the database default?
Does the same thing apply to rebuild/reorganize?
Heh... Who 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 29, 2008 at 8:31 am

#783817
RE: Practical Methods: Naming Conventions

So, the young couple took the new born twins, a boy and a girl, to the God Father. "God Father", said the young Mother... "We would be honored if...
--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 29, 2008 at 8:20 am

#783802
RE: Include end date on a history record?

... and a trigger would take care of the date-1 thing.
--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 29, 2008 at 7:49 am

#783772
RE: Include end date on a history record?

So should I go with the normalized design,...
Heh... what would be the alternative?
--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 29, 2008 at 7:48 am

#783770
RE: Index management - rebuild/reorganize/dbreindex & fillfactor

It's in Books Online under "DBCC Reindex"...
fillfactor
Is the percentage of space on each index page to be used for storing data when the index is created. fillfactor replaces the original...
--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 29, 2008 at 7:40 am

#783764

Viewing 15 posts - 52,261 through 52,275 (of 59,098 total)