我的表有15万条记录 最近发现更新update速度很慢 每次重启服务器后运行一段时间又出现这个问题。表结构如下CREATE TABLE [dbo].[cld](
[流水号] [nvarchar](14) NOT NULL,
[采购单编号] [nvarchar](50) NULL,
[日期] [datetime] NOT NULL,
[材料名称] [nvarchar](12) NULL,
[供应单位] [nvarchar](50) NULL,
[规格] [nvarchar](10) NULL,
[单位] [nvarchar](10) NULL,
[毛重] [float] NULL,
[皮重] [float] NULL,
[净重] [float] NULL,
[料单数量] [float] NULL,
[承运单位] [nvarchar](60) NULL,
[车种] [nvarchar](12) NULL,
[车牌号] [nvarchar](20) NULL,
[质量评定] [nvarchar](10) NULL,
[验收人] [nvarchar](12) NULL,
[含水率] [float] NULL,
[生产单位] [nvarchar](50) NULL,
[时间] [datetime] NULL,
[回皮时间] [datetime] NULL,
[料仓编号] [nvarchar](50) NULL,
[部门] [nvarchar](20) NULL,
[部门编号] [nvarchar](20) NULL,
[回皮图片] [image] NULL,
[过磅图片] [image] NULL,
[回皮牌号] [nvarchar](20) NULL,
CONSTRAINT [PK_cld] PRIMARY KEY CLUSTERED
(
[流水号] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
[流水号] [nvarchar](14) NOT NULL,
[采购单编号] [nvarchar](50) NULL,
[日期] [datetime] NOT NULL,
[材料名称] [nvarchar](12) NULL,
[供应单位] [nvarchar](50) NULL,
[规格] [nvarchar](10) NULL,
[单位] [nvarchar](10) NULL,
[毛重] [float] NULL,
[皮重] [float] NULL,
[净重] [float] NULL,
[料单数量] [float] NULL,
[承运单位] [nvarchar](60) NULL,
[车种] [nvarchar](12) NULL,
[车牌号] [nvarchar](20) NULL,
[质量评定] [nvarchar](10) NULL,
[验收人] [nvarchar](12) NULL,
[含水率] [float] NULL,
[生产单位] [nvarchar](50) NULL,
[时间] [datetime] NULL,
[回皮时间] [datetime] NULL,
[料仓编号] [nvarchar](50) NULL,
[部门] [nvarchar](20) NULL,
[部门编号] [nvarchar](20) NULL,
[回皮图片] [image] NULL,
[过磅图片] [image] NULL,
[回皮牌号] [nvarchar](20) NULL,
CONSTRAINT [PK_cld] PRIMARY KEY CLUSTERED
(
[流水号] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
解决方案 »
- 求教数据库中 查询数据库中所表表的语句
- 如何为用户将1.0版本的升级2.0版本?
- Microsoft OLE DB Provider for SQL Server 错误 '80004005'[DBNETLIB][ConnectionOpen (Connect()).]SQL Server 不存在或拒绝访问。
- 用SQLServer还是MySql?
- 问个sql的查询语句!(愿意给所有分)
- 关于数据规范化问题.
- 存储过程分页问题
- 动态SQL exec2
- 我怎样配置BDE,才能使DELPHI调用SQL SERVER数据库,请帮帮我???
- SQL7.0日志经常写满,为什么?????
- sql server 如何灾难恢复数据?
- 急!!!我的SQL SERVER 服务总是启动不了.
参考http://msdn.microsoft.com/zh-cn/library/ms188917.aspx