Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,351 through 43,365 (of 59,063 total)

RE: Is a history table required for maintaining a column's previous value?

Another possible method is Type 2 SCD's (Slowly Changing Dimensions). See the following article...
http://en.wikipedia.org/wiki/Slowly_Changing_Dimension
--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)

June 16, 2009 at 5:50 pm

#1010562
RE: pivot or cross tab assistance

Rich96 (6/16/2009)
Thanks so much.. that's going to do it for me!
Because this is a denormalization of data, I'm curious and I have to ask why this needs to be done?...
--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)

June 16, 2009 at 5:45 pm

#1010560
RE: How to concatenate row values?

MissDaisy,
It's normally a very bad idea to store concatenated data in a table so I'm curious... why do you want to store concatenated data in a 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)

June 16, 2009 at 5:41 pm

#1010559
RE: Which Rows in Cursor?

ken.trock (6/15/2009)
Thanks for looking at this. I'll take a look at table vars and error handling. These procs operate on anywhere from several hundred rows to a worst case scenario...
--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)

June 15, 2009 at 6:22 pm

#1009981
RE: Which Rows in Cursor?

That may actually be ok... it depends on how many rows you're processing with things like the following...
EXEC UpdateAcdFact @ServerId, @SiteId, @EffectiveDate
How many rows does that sproc process for any...
--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)

June 15, 2009 at 3:01 pm

#1009926
RE: Test your problem solving skills!

Also I forgot to mention, this was a TESTBED server for ALL of development
Yep... you're correct. I totally missed it. Anyway, if you think I'm making 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)

June 15, 2009 at 2:55 pm

#1009924
RE: Identity and uniqueIdentifier and custom id

It doesn't need to be the primary key. Doesn't even need to be the clustered index. Can be an index. It all depends... what do most 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)

June 15, 2009 at 2:24 pm

#1009909
RE: Identity and uniqueIdentifier and custom id

Digs (6/14/2009)
Identity and uniqueIdentifier and customid
Is there any CustomID method where I can create my own ID for keys in tables.
Sequential ID from identity is ok
The UniqueIdentifier works but 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)

June 15, 2009 at 1:56 pm

#1009898
RE: Are the posted questions getting worse?

Mike McQueen (6/15/2009)
As far as I know, he has no idea what your e-mail address is. When you e-mail someone all you see is their User Name, and it 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)

June 15, 2009 at 1:50 pm

#1009893
RE: Append output from SQLCMD in batch file

WayneS (6/15/2009)
Jeff Moden (6/15/2009)
Ok... you guys can remove the handrails, now. 😛
..... getting out the reciprocating saw .... or will that cause too much damage where the handrails are...
--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)

June 15, 2009 at 1:46 pm

#1009890
RE: Test your problem solving skills!

Lynn Pettis (6/15/2009)
But, on the flip side, there is also no reason that it could be pointed out that it would be beneficial to move those detached databases to another...
--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)

June 15, 2009 at 1:43 pm

#1009888
RE: Test your problem solving skills!

talltop (6/15/2009)
I've worked for incompetent managers in the past as well and they usually end doing themselves in. They don't need my help. However, tellling off a manager or advising...
--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)

June 15, 2009 at 11:41 am

#1009811
RE: Are the posted questions getting worse?

Roy Ernest (6/15/2009)
The troll generator gave me good name...Sticky Buns Troll..:hehe:
Heh... TMI, Roy. 😀
--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)

June 15, 2009 at 11:13 am

#1009803
RE: How to get Saturday b/w two dates

Lutz's example is the start. You just need to add the SUM code which should be no biggee.
If you need a more complete answer, we need to see...
--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)

June 15, 2009 at 11:11 am

#1009802
RE: DBA job not busy enough

WayneS (6/14/2009)
Jeff Moden (6/14/2009)
Also, test the restoration of backups and maybe write the standard guidline for doing such a thing. Maybe even go whole hog and setup/test a disaster...
--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)

June 15, 2009 at 10:46 am

#1009773

Viewing 15 posts - 43,351 through 43,365 (of 59,063 total)