随笔分类 - S.SQLServer2005
SQL Server 2005
摘要:为 SQL Server 启用 AWE 内存
阅读全文
摘要:PAGEIOLATCH_SH: Occurs when a task is waiting on a latch for a buffer that is in an I/O request. The latch request is in Shared mode.
阅读全文
摘要:CXPACKET: Occurs when trying to synchronize the query processor exchange iterator. You may consider lowering the degree of parallelism if contention on this wait type becomes a problem.
阅读全文
摘要:日志的逻辑文件名是DBNAME_LOG,数据库DBNAME: USE DBNAME BACKUP LOG DBNAME WITH NO_LOG --截断事务日志 GOOPTION 1:DBCC SHRINKFILE(DBNAME_LOG,10) --收缩事务日志 GO OPTION 2:企业管理器--右键你要压缩的数据库--所有任务--收缩数据库--收缩文件--选择日志文件--在收缩方式里选择收缩...
阅读全文
摘要:A couple of strange warnings in the Security event log always occur when then transaction fails:Log 1:Event Type:Failure AuditEvent Source:SecurityEvent Category:Account Logon Event ID:680Date:2008-2-...
阅读全文
摘要:The following SQL statement is used to reconfigure the SQL SERVER advanced settings, such as max text repl size. sp_configure 'max text repl size', 2147483647GORECONFIGURE;You can also configure this ...
阅读全文
摘要:How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server 2005 1. For a renamed default instance, run the following procedures:Get SQL SERVER NAME: select @@servername sp_dropserver GO...
阅读全文
摘要:Transact SQL User-Defined Functions in SQL Server 2005
阅读全文
摘要:An Introduction to SQL Server Service Broker Author: Roger Wolter Published: February, 2005 Summary: This paper introduces Service Broker, a new feature in Microsoft SQL Server 2005. With Service Brok...
阅读全文
摘要:A linked server is a virtual server that has been defined to SQL Server 2005 with all the information required to access an OLE DB data source. A linked server name is defined by using the sp_addlinkedserver system stored procedure.
阅读全文
摘要:If the Database Master Key was encrypted with the Service Master Key, it will be automatically opened when it is needed for decryption or encryption. In this case, it is not necessary to use the OPEN MASTER KEY statement.
阅读全文
摘要:The following shows you some kinds of SSB exception when enabling Transport Security and Dialog Security in the cross-server Service Broker conversation.
阅读全文
摘要:Clean up SSB Message Queue
阅读全文
摘要:Service Broker – EndDialog (http://schemas.microsoft.com/SQL/ServiceBroker/EndDialog)
阅读全文
摘要:Create route in cross-server SSB
阅读全文
摘要:SSB exceptions list in cross-server communication
阅读全文
摘要:KILL { session ID | UOW } [ WITH STATUSONLY ]
阅读全文
摘要:The problem is that the activation execution context is trusted only in the database, not in the whole server, like other stored procedures or DB. So when the activated SP calls another SP located in the other DB, the above exception will occur.
阅读全文
摘要:A poison message is a message containing information that an application cannot successfully process. A poison message is not a corrupt message, and may not be an invalid request.
阅读全文
摘要:the author suggests another pattern for SSB message conversation. The solution is let the target end the conversation first. The initiator can simply send the message to the target and then continue. The target will receive the message, end the conversation from the target side and this will send an EndDialog message back to the initiator.
阅读全文