Re: Varchar vs Nvarchar

While I agree that you might not need NVARCHAR based on your description,
I'm not sure that it's something worth worrying about. 7.5 gigs is not a
lot of disk space... Why the concern?


--
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--


"MChrist" <MChrist@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5653976D-FA2D-4E0C-AECA-DDEF7640E124@xxxxxxxxxxxxxxxx
> Please pardon my ignorance here, but I'm a newbie with MS SQL Server.
>
> I have a database that contains a table with 33.6 million records. When I
> built the table I used Nvarchar in several of the fields. Now I'm
> thinking
> that because the db size is 7.5 gb, that I could reduce that by changing
> the
> datatype to Varchar.
>
> Since I'm not changing languages or porting hardware platforms is there a
> good reason why I should keep the nvarchar data type other that it will
> take
> an eternity to save the new table structure?
>
> Does anyone have any suggestions as to which would be faster, building a
> new
> table and importing the records via a query, or just changing the existing
> datatype and saving the table.
>
> TIA!
>
> Mark
>
>


.

Relevant Pages

  • Re: nText field not showing up (ASP)
    ... SQL Server MVP ... > nvarchar to ntext, but now nothing is being displayed. ... > However once I changed the datatype of "Body" from nvarchar to ntext, ... Is there a special way for me to retrieve ntext fields? ...
    (microsoft.public.inetserver.asp.general)
  • Re: JDBC - Cant get unicode with ResultSet.getString()
    ... The column is a nvarchar and I use ResultSet.getStringto retrieve it. ... >> The data is correct in Sql Server - I viewed it there. ... >> And it is the jdbc getString() that returns it wrong, ...
    (microsoft.public.sqlserver.odbc)
  • Re: Severe performance hit with NCHAR queries
    ... Response time the first couple of times was upwards of 20+ seconds, ... When two different data types meet, SQL Server applies a strict data-type ... The data type of a string literal with a preceeding N is nvarchar. ...
    (comp.databases.ms-sqlserver)
  • Re: slow stored procedure
    ... portion of the table much a condition like WHERE EVT_UPDATED < @CutOFfDate ... WHERE (CAST(ACS_EVENT AS NVARCHAR) + ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Importing Textfiles into SQL Server 2000
    ... I have been unable to import a Text file into SQL Server 2000. ... At the end of the last field of the header column, ... nvarchar NULL, ... datetime NULL, ...
    (microsoft.public.sqlserver.server)
Loading