Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,381 through 43,395 (of 59,098 total)

RE: Are the posted questions getting worse?

GilaMonster (6/16/2009)
I just got word from the documentation people. The lack of the UPDATE <alias> was simply an oversight and it will be corrected in a future version of BoL....
--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 7:37 pm

#1010582
RE: Are the posted questions getting worse?

george sibbald (6/16/2009)
Please note that the overall percentage of correct answers for QOTD has recently gone up from 57% to 58%
Heh... probably a rounding error by the same programmers 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)

June 16, 2009 at 7:22 pm

#1010578
RE: DBCC DBReindex with "Sort In TembDB"

MANU (6/16/2009)
Its an option under Create Index in sql 2000:
http://msdn.microsoft.com/en-us/library/aa174535(SQL.80).aspx
MJ
Thanks Manu. What I was looking for, though, was a way to use DBCC DBReIndex with the sort-in-TempDB option. ...
--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 6:41 pm

#1010572
RE: How to concatenate row values?

Ah... got it. Seems like the right thing to do in this case.
Gus' code suggestion should work just fine except when you run into things like "&" and 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 16, 2009 at 6:33 pm

#1010569
RE: TempDB mdf file has grown to 11GB

Mani Singh (6/16/2009)
Re-Starting SQL server is the best practise.
Ummmmmm.... Who made that rule? Do you happen to have an MS document that actually recommends such a practice?
--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:58 pm

#1010565
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

Viewing 15 posts - 43,381 through 43,395 (of 59,098 total)