Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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 4, 2009 4:48 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, September 19, 2016 10:09 PM
Points: 1,080, Visits: 1,009
Tricksy tricksy.

Good question, good follow up.

Learned something new today.

ta



Post #782813
Posted Friday, September 4, 2009 6:49 AM
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: Today @ 12:55 PM
Points: 3,231, Visits: 2,760
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 4, 2009 6:51 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 8:14 AM
Points: 1,523, Visits: 957
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 5, 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: Today @ 11:40 AM
Points: 3,343, Visits: 6,832
Good question and a good reminder.

__________________________________________________

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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, June 6, 2016 1:51 PM
Points: 1,400, Visits: 3,059
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 2, 2010 11:51 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, September 16, 2016 10:21 PM
Points: 554, Visits: 421
A simple but head scratching Question...!

Many thanks.I learnt something new today !


Thanks & Regards
-Tushar
MCP,MCDBA(SQL 2000),MCTS(SQL 2005,2008),MCITP(SQL 2005,2008)

"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: Monday, July 18, 2016 5:10 AM
Points: 698, Visits: 363
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