question

platypusdata avatar image
platypusdata asked

To convert nvarchar to varchar VLDB

Hi

We have growing database challenges and looking for ideas. we have a sql server which stores a central copy of production databases for reporting.. the actual production databases are spread around the globe on mysql though all pretty similar in structure. our biggest challenge is AUS and UK databases have grown to over a terrabyte (the rest of regions are <20GB) and capacity is getting tight. We're thinking of changing the AUS and UK report databases to use varchar datatype as they all use nvarchar and there are lots of string fields.. Is this a bad idea?

Thanks

sql databasedatatypecapacity
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
platypusdata avatar image
platypusdata answered

anyone got experience with nvarchar back to varchar conversion...or general tips for slimming down VLDB would be useful, cheers

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.