暂无介绍
ITPUB论坛APP
APP发帖 享双倍积分
IT168企业级官微
微信号：IT168qiye
系统架构师大会
微信号：SACC2013
发布时间：2016-04-21 01:05:44
关键词表? deldel用于list列表操作，删除一个或连续几个列表元素或者列表本身。点击(此处)折叠或打开a = [-1, 3, 'aa', 85, 'bbb', 555]print adel a[0]print adel a[2:4]print a.........【阅读全文】
发布时间：2013-08-22 14:29:34
使用waitfor time和waitfor delay[@more@][case 1]WAITFOR TIME '01:20:04'begin declare @i int = 0 while (@i < 3) begin insert into ContentType_Log(TypeID,TypeName,LastUpdateDate) select TypeID,TypeName,getdate() as LastUpdateDate from TypeTable set @i = @i + 1 WAITFOR DELAY '00:00:10' endendGO[case 2]WAITFOR TIME '01:23:34'GObegin insert into ContentType_Log(TypeID,TypeName,LastUpdateDate) select TypeID,TypeName,getdate() as LastUpdateDate from TypeTable WAITFOR DELAY '00:00:10' endGO 3......【阅读全文】
发布时间：2013-07-23 15:34:58
http://msdn.microsoft.com/en-us/library/dd207004%28v=sql.105%29.aspx[@more@][run as Admin]Microsoft Windows [Version 6.1.7601]Copyright (c) 2009 Microsoft Corporation. All rights reserved.C:Windowssystem32>C:Windowssystem32>net stop mssqlserverThe SQL Server (MSSQLSERVER) service is stopping.The SQL Server (MSSQLSERVER) service was stopped successfully.C:Windowssystem32>net start mssqlserver /mThe SQL Server (MSSQLSERVER) service is starting.The SQL Server (MSSQLSERVER) service was sta......【阅读全文】
发布时间：2013-07-22 17:25:24
Database Unit TestingDAL(Database Access Layer) Unit Testing[@more@]1. Database Unit Testinghttp://www.databasejournal.com/features/mssql/article.php/3844791/Database-Unit-Testing.htmhttp://www.cnblogs.com/harrychinese/articles/TutorialQuickStart.htmlhttps://anydbtest.codeplex.com/releases/view/609812. DAL(Database Access Layer) Unit Testinghttp://www.codeproject.com/Articles/12334/Armadillo-Unit-Testing-of-inline-SQL-with-a-little?q=c%23+db+unit+test+framework#intro......【阅读全文】
发布时间：2013-07-15 17:33:03
某存储过程调用频繁，绝大部分调用在1秒内结束。在每30分钟内，有30到40次调用超过10秒。从业务上我们知道这个过程调用很频繁，但到是什么程度，我们还不清楚。另外，从执行计划上来看，已经最优，没有优化SQL的空间了。下面是在这种情况下的调优过程。[@more@]1. 系统检测 （1）取系统等待并且阻塞的进程 SET NOCOUNT ON SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED GO CREATE TABLE #block( [current_time] [datetime] NOT NULL, [resource_type] [nvarchar](60) NOT NULL, [requ......【阅读全文】
