SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Regarding change the data type(Size) of column


Regarding change the data type(Size) of column

Author
Message
Bharat21
Bharat21
Old Hand
Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)

Group: General Forum Members
Points: 358 Visits: 280
Hi ,

I have to change the size of one of the column of table in production server which having more than 3 cr data.
Existing data type of this is varchar(150) now we want to made it varchar(300)
Please suggest impact of this on data base growth and how we can analysis as it's transnational table (More than 50-80 thousands records are inserted per day )



Please guide if any know well .

subramaniam.chandrasekar
subramaniam.chandrasekar
Mr or Mrs. 500
Mr or Mrs. 500 (598 reputation)Mr or Mrs. 500 (598 reputation)Mr or Mrs. 500 (598 reputation)Mr or Mrs. 500 (598 reputation)Mr or Mrs. 500 (598 reputation)Mr or Mrs. 500 (598 reputation)Mr or Mrs. 500 (598 reputation)Mr or Mrs. 500 (598 reputation)

Group: General Forum Members
Points: 598 Visits: 235
Bharat21 - Monday, January 1, 2018 3:28 AM
Hi ,

I have to change the size of one of the column of table in production server which having more than 3 cr data.
Existing data type of this is varchar(150) now we want to made it varchar(300)
Please suggest impact of this on data base growth and how we can analysis as it's transnational table (More than 50-80 thousands records are inserted per day )



Please guide if any know well .

Its not even a bigger change to the existing table, May I know why you need to change the length of the existing field now ? because of any of the following
1) any recent Release on the source table / view ?
2) new requirement OR any
Possible impacts:
Unless your prod server db. table has been used by other shared services team, no other possible impacts.

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search