Viewing 15 posts - 1 through 15 (of 22 total)
noeld (2/9/2009)
You must change those that you can to VARCHAR it will reduce the width by 2
Unable to do so as the system needs to support multibyte character strings.
You...
February 9, 2009 at 1:24 pm
I cannot change the type from NVARCHAR to VARCHAR as the company that is using this database require the NVARCHAR datatype as they deal with clients in, for example, China.
Graham...
February 9, 2009 at 1:04 pm
What this script is trying to do is to drop fields that the client does not use. for example LEAD_COMPANYNAME, as the Database is a CRM system (Sage CRM to...
February 9, 2009 at 11:15 am
I think I may have found the error. Will keep you posted......
Graham Harris
February 9, 2009 at 11:09 am
1. SP3 has been installed
2. Here is the DDL for the unchanged table:
CREATE TABLE [dbo].[Lead](
[Lead_LeadID] [int] NOT NULL,
[Lead_CreatedBy] [int] NULL,
[Lead_CreatedDate] [datetime] NULL,
[Lead_UpdatedBy] [int] NULL,
[Lead_UpdatedDate] [datetime] NULL,
[Lead_TimeStamp] [datetime] NULL,
[Lead_Deleted] [int] NULL,
[Lead_PrimaryCompanyID]...
February 9, 2009 at 10:49 am
Forgot to mention that the table contains a variety of data types, int, datetime, bit. Will this prevent SQL Server from wrapping the data up into another page?
Graham Harris
February 9, 2009 at 10:25 am
OK Crated a script that converted the NCHAR fields to NVARCHAR fields BUT it fell over when the data was reinserted back into the table. As I had to...
February 9, 2009 at 10:09 am
OK figured out what was going wrong. Found this article on MSDN
http://blogs.msdn.com/msdnts/archive/2006/12/01/row-size-limitation-in-sql-2000-and-2005.aspx
and I realized that there are a lot of fields that are of NCHAR(n) rather than NVARCHAR(n).
Graham Harris
February 6, 2009 at 11:16 am
Thanks for the tip!!
Graham
January 7, 2009 at 10:58 am
Thanks!
There is an index on the lead_fromdataid and lead_type though there is a seperate index on both fields. I gues that is why SQL Server is using the clustered...
January 7, 2009 at 10:41 am
Managed to grad the actual execution plan! Please see attached zip.
January 7, 2009 at 10:08 am
GilaMonster (1/7/2009)
gharris_35 (1/7/2009)
HiDid you check that before you posted? 😉
Whoops!
I think you're going to have to use profiler to narrow things down a little. Look for the procs with...
January 7, 2009 at 7:31 am
Yes!! That was the case. I have noticed that some of the stored procs trouble is that the procedure is running now. And I do not want to run it...
January 7, 2009 at 7:22 am
Hi
I have uploaded the estimated plan. See Estimated Plan.zip
January 7, 2009 at 7:12 am
Tried runing it with the estimated plan and Management studio returned too much info!! I think the answer is, and it is not want I kind of want, is that...
January 7, 2009 at 6:56 am
Viewing 15 posts - 1 through 15 (of 22 total)