同时truncate 不同表不会所表，应该是其他地方在使用  临时表？

html5的local storage是浏览器的本地存储。没有办法和服务器的SQL SERVER直接交互，需要通过WEB接口。

数据损坏或者日志文件和数据文件不匹配

分开来拆比较好，我觉得影响主要是在 ‘3，每个查询语句的结果几十万条’这里，具体可以看看执行计划。 

推荐看下文章：
https://msdn.microsoft.com/zh-cn/library/ms190790.aspx
 
列出指定路径上的文件名和大小，看下面的存储过程
 
执行顺序：
1. 先执行以下代码：
sp_configure 'show advanced options',1
reconfigure
go
sp_configure 'xp_cmdshell',1
reconfigure
go
 
2. 再执行：
exec [dbo].[GetListOfFileWithSize] '制定路径'
 [code]CREATE PROCEDURE [dbo].
(
@Dir VARCHAR(1000)
)
AS
---------------------------------------------------------------------------------------------
-- Variable decleration
---------------------------------------------------------------------------------------------
declare @curdir nvarchar(400)
declare @line varchar(400)
declare @command varchar(400)
declare @counter int

DECLARE @1MB DECIMAL
SET @1MB = 1024 * 1024

DECLARE @1KB DECIMAL
SET @1KB = 1024

---------------------------------------------------------------------------------------------
-- Temp tables creation
---------------------------------------------------------------------------------------------
CREATE TABLE #dirs (DIRID int identity(1,1), directory varchar(400))
CREATE TABLE #tempoutput (line varchar(400))
CREATE TABLE output (Directory varchar(400), FilePath VARCHAR(400), SizeInMB DECIMAL(13,2), SizeInKB DECIMAL(13,2))

CREATE TABLE #tempFilePaths (Files VARCHAR(500))
CREATE TABLE #tempFileInformation (FilePath VARCHAR(500), FileSize VARCHAR(100))

---------------------------------------------------------------------------------------------
-- Call xp_cmdshell
---------------------------------------------------------------------------------------------

SET @command = 'dir "'+ @Dir +'" /S/O/B/A:D'
INSERT INTO #dirs exec xp_cmdshell @command
INSERT INTO #dirs SELECT @Dir
SET @counter = (select count(*) from #dirs)

---------------------------------------------------------------------------------------------
-- Process the return data
---------------------------------------------------------------------------------------------

WHILE @Counter <> 0
BEGIN
DECLARE @filesize INT
SET @curdir = (SELECT directory FROM #dirs WHERE DIRID = @counter)
SET @command = 'dir "' + @curdir +'"'
------------------------------------------------------------------------------------------
-- Clear the table
DELETE FROM #tempFilePaths


INSERT INTO #tempFilePaths
EXEC MASTER..XP_CMDSHELL @command

--delete all directories
DELETE #tempFilePaths WHERE Files LIKE '%<dir>%'

--delete all informational messages
DELETE #tempFilePaths WHERE Files LIKE ' %'

--delete the null values
DELETE #tempFilePaths WHERE Files IS NULL

--get rid of dateinfo
UPDATE #tempFilePaths SET files =RIGHT(files,(LEN(files)-20))

--get rid of leading spaces
UPDATE #tempFilePaths SET files =LTRIM(files)

--split data into size and filename
----------------------------------------------------------
-- Clear the table
DELETE FROM #tempFileInformation;

-- Store the FileName & Size
INSERT INTO #tempFileInformation
SELECT
RIGHT(files,LEN(files) -PATINDEX('% %',files)) AS FilePath,
LEFT(files,PATINDEX('% %',files)) AS FileSize
FROM #tempFilePaths

--------------------------------
-- Remove the commas
UPDATE #tempFileInformation
SET FileSize = REPLACE(FileSize, ',','')




--------------------------------------------------------------
-- Store the results in the output table
--------------------------------------------------------------

INSERT INTO output--(FilePath, SizeInMB, SizeInKB)
SELECT
@curdir,
FilePath,
CAST(CAST(FileSize AS DECIMAL(13,2))/ @1MB AS DECIMAL(13,2)),
CAST(CAST(FileSize AS DECIMAL(13,2))/ @1KB AS DECIMAL(13,2))
FROM #tempFileInformation

--------------------------------------------------------------------------------------------


Set @counter = @counter -1
END


DELETE FROM OUTPUT WHERE Directory is null
----------------------------------------------
-- DROP temp tables
----------------------------------------------
DROP TABLE #Tempoutput
DROP TABLE #dirs
DROP TABLE #tempFilePaths
DROP TABLE #tempFileInformation
--DROP TABLE #tempfinal

SELECT * FROM OutPut
DROP TABLE output

首先我不是DBA，但是我之前做过MSSQL的升级；将数据压缩备份，只备份数据不备份日志，这样数据库文件就会变小，节省时间。
（一般数据库服务器最好是Server和文件分离，这样方便管理。）

SQLServer本身自带的BI工具对于开发是不够的，需要结合VS使用；必须要对应版本，并且需要安装一些插件；这样开发功能才比较完善。

select * from C_SHIP_DATA order by case when LINER_ID is null then 0 else 1 end desc,LINER_ID asc

这个好像也是随着物理磁盘做调整的

可以。单项目多包的情况，连接管理是共享的

http://www.cnblogs.com/lyhabc/p/3480917.html
http://www.cnblogs.com/lyhabc/p/3504380.html

你百度下吧，通过系统表是可以获取的。
 
select a.name as tabname
,h.name as idname
from sys.objects as a 
right join sys.indexes as h on a.object_id=h.object_id
where a.type<>'s' 

这个应该是权限问题

EXEC sp_helprotect @username = @Role;

找到方法了  加 这个 ROWS BETWEEN 7 PRECEDING AND CURRENT ROW
 
如果跨周  会有差异  和实际需求