Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

using nvarchar

  
   Database Forums (Home) -> Server RSS
Next:  Temp table  
Author Message
DJ

External


Since: Dec 19, 2003
Posts: 2



(Msg. 1) Posted: Wed Jun 30, 2004 5:15 am
Post subject: using nvarchar
Archived from groups: microsoft>public>sqlserver>server (more info?)
Does the datatype nvarchar affect query performance in a
negative way as opposed to simply using varchar?

 >> Stay informed about: using nvarchar 
Back to top
Login to vote
Mark Allison3

External


Since: Jun 07, 2004
Posts: 29



(Msg. 2) Posted: Wed Jun 30, 2004 1:24 pm
Post subject: Re: using nvarchar [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
dj,

Well it takes up twice as much space, so yes. I.e. if you are joining on
a nvarchar column it will take longer. I/O requests will take longer
because you will half as much data on a page, therefore you will need
twice as many I/Os.

Each character in a unicode field requires 2 bytes to store it.
--
Mark Allison, SQL Server MVP
<a rel="nofollow" style='text-decoration: none;' href="http://www.markallison.co.uk" target="_blank">http://www.markallison.co.uk</a>

Looking for a SQL Server replication book?
<a rel="nofollow" style='text-decoration: none;' href="http://www.nwsu.com/0974973602.html" target="_blank">http://www.nwsu.com/0974973602.html</a>


dj wrote:
 > Does the datatype nvarchar affect query performance in a
 > negative way as opposed to simply using varchar?

 >> Stay informed about: using nvarchar 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
nvarchar / varchar(MAX) question - Hi all, I'm curious about the efficiency of the varchar datatype in general. I understand the difference between varchar and nvarchar (unicode), and I understand what the new nvarchar(max) is in sql 2005. What I don't understand is exactly how varchar..

Passing table variable as input parameter to stored proc - I understand you cannot pass a table variable as input parameter to a stored proc. But what is the alternative in my case? Current DB standards limit access of linked servers to the execution of stored procs and functions, no cross server joins. But...

Need Help in interpreting Lock:Timeout Error in SQL Profil.. - Hi, I need some help in interpreting trace from SQL profiler. I'm seeing a whole bunch of Lock:Timeout events in SQL Profiler Trace. >From the trace, it seems like for spid=118, database issues "SP:StmtStarting" event for opening a cursor f...

Urgent - General Network Error - Hi , I have a subscription that keeps failing to synchronise with the following error : "General Network Error. Check your network documentation" how can i check the cause & resolve ? kindly advise

cannot start MSSQLServerOLAPService....error 1058: the ser.. - sql 2000 w/ sp4 running on w2k3 using sql authenitcation.......olap service account is running under AD admin account and is a member of local OLAP admin group. not sure what else to check.....have looked all over the net. thanks.
   Database Forums (Home) -> Server All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]