Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Fixed to varying length Expand / Collapse
Author
Message
Posted Friday, September 04, 2009 4:48 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 2:20 AM
Points: 1,052, Visits: 863
Tricksy tricksy.

Good question, good follow up.

Learned something new today.

ta



Post #782813
Posted Friday, September 04, 2009 6:49 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 11:52 AM
Points: 2,919, Visits: 2,511
Excellent question - made me think, got it wrong, then learned something.

Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
Post #782859
Posted Friday, September 04, 2009 6:51 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 10:57 AM
Points: 1,053, Visits: 537
I should not have made the assumption that the question was solely about the differences between char and varchar! I was assuming (see, that was my problem!) that the appropriate clean-up would be taken into consideration when I said that it would result in a 70% reduction. In that case, I would have been correct.

Werry twicky, you wascally wabbit!



"...when ye are in the service of your fellow beings ye are only in the service of your God." -- Mosiah 2:17
Post #782862
Posted Saturday, September 05, 2009 2:31 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, April 14, 2014 7:45 AM
Points: 3,949, Visits: 5,944
Good question and a good reminder.

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? -- Stephen Stills
Post #783390
Posted Tuesday, September 22, 2009 11:47 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, January 21, 2014 8:55 AM
Points: 1,520, Visits: 3,035
Hugo,

Thank you for this gleaming nugget. Although I'm a developer, not a DBA, I like to know something of what's under the hood with the tools we use. This QOD gave us double our money's worth -- an explicit rtrim() is necessary to fully take advantage of the move to varchar and the clustered index must be rebuilt to free the space used by the old fixed length column definition.

I've never been happier to get an answer wrong than this time -- really learned something valuable.
Post #792372
Posted Wednesday, June 02, 2010 11:51 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, March 05, 2014 7:24 AM
Points: 457, Visits: 343
A simple but head scratching Question...!

Many thanks.I learnt something new today !


_____________________________________________

Kindest Regards,
- Tushar
MCP,MCDBA(SQL 2000),MCTS(SQL 2005),MCITP(SQL 2005)

" Most Good Experience Comes From Judgement,
Most Judgement Comes From Bad Experience "
Post #931852
Posted Wednesday, July 28, 2010 8:03 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, April 17, 2014 6:43 AM
Points: 697, Visits: 344
Good question and best answer.
i never take any idia about this type problems.+
thanks

Post #960057
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse