Rickie is back .... 人生·工作的结果=思维方式×热情×能力

今天比昨天更好，明天比今天更好，为此，不屈不挠地工作、勤勤恳恳地经营、孜孜不倦地修炼，我们人生的目的和价值就是这样确确实实地存在着。

  博客园 :: 首页 :: 新随笔 :: 联系 :: 订阅 订阅 :: 管理 ::
  397 随笔 :: 3 文章 :: 1310 评论 :: 129 引用

S.SQLServer2005

SQL Server 2005
为 SQL Server 启用 AWE 内存
摘要: 为 SQL Server 启用 AWE 内存阅读全文
posted @ 2008-04-25 16:15 Rickie 阅读(1005) | 评论 (0) 编辑

SQL Server 2005: Wait Type - PAGEIOLATCH_SH
摘要: 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.阅读全文
posted @ 2008-03-20 11:46 Rickie 阅读(2116) | 评论 (0) 编辑

SQL Server 2005: Wait Type - CXPACKET
摘要: 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. 阅读全文
posted @ 2008-03-18 18:40 Rickie 阅读(5576) | 评论 (0) 编辑

SQL SERVER数据库清理DB LOG
posted @ 2008-02-22 10:12 Rickie 阅读(916) | 评论 (0) 编辑

Random MS DTC problem
posted @ 2008-02-20 11:01 Rickie 阅读(586) | 评论 (0) 编辑

Reconfigure SQL server's advanced settings
posted @ 2008-02-02 13:58 Rickie 阅读(411) | 评论 (0) 编辑

How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server 2005
posted @ 2008-01-10 09:41 Rickie 阅读(191) | 评论 (0) 编辑

Transact SQL User-Defined Functions in SQL Server 2005
摘要: Transact SQL User-Defined Functions in SQL Server 2005阅读全文
posted @ 2007-09-29 11:23 Rickie 阅读(497) | 评论 (1) 编辑

An Introduction to SQL Server Service Broker [WORD DOCUMENT]
posted @ 2007-07-02 21:55 Rickie 阅读(357) | 评论 (0) 编辑

SQL Server 2005: how to add a linked server
摘要: 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.阅读全文
posted @ 2007-06-27 13:26 Rickie 阅读(1457) | 评论 (1) 编辑

SQL Server 2005 – Database Master Key
摘要: 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. 阅读全文
posted @ 2007-06-19 09:18 Rickie 阅读(525) | 评论 (1) 编辑

SSB – Connection handshake failed
摘要: The following shows you some kinds of SSB exception when enabling Transport Security and Dialog Security in the cross-server Service Broker conversation.
阅读全文
posted @ 2007-06-04 19:35 Rickie 阅读(484) | 评论 (0) 编辑

Clean up SSB Message Queue
摘要: Clean up SSB Message Queue阅读全文
posted @ 2007-05-21 10:08 Rickie 阅读(318) | 评论 (0) 编辑

Service Broker – EndDialog (http://schemas.microsoft.com/SQL/ServiceBroker/EndDialog)
摘要: Service Broker – EndDialog (http://schemas.microsoft.com/SQL/ServiceBroker/EndDialog)
阅读全文
posted @ 2007-03-21 22:47 Rickie 阅读(681) | 评论 (1) 编辑

Create route in cross-server SSB
摘要: Create route in cross-server SSB阅读全文
posted @ 2007-03-07 08:46 Rickie 阅读(512) | 评论 (0) 编辑

SSB exceptions list in cross-server communication
摘要: SSB exceptions list in cross-server communication阅读全文
posted @ 2007-03-02 08:28 Rickie 阅读(382) | 评论 (1) 编辑

SQL SERVER – 检测LOCK、终止会话 ID/UOW 的用户进程
摘要: KILL { session ID | UOW } [ WITH STATUSONLY ] 阅读全文
posted @ 2006-12-31 21:39 Rickie 阅读(1322) | 评论 (0) 编辑

SSB – Activation Execution Context
摘要: 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.阅读全文
posted @ 2006-12-28 18:19 Rickie 阅读(453) | 评论 (0) 编辑

SSB – Handling and Removing Poison Messages
摘要: 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.阅读全文
posted @ 2006-12-28 16:14 Rickie 阅读(413) | 评论 (0) 编辑

SSB - Fire and Forget: Good for the military, but not for Service Broker conversations
摘要: 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. 阅读全文
posted @ 2006-12-27 23:24 Rickie 阅读(434) | 评论 (0) 编辑

SSB FAQ (4) – Debug tips for SSB beginners
摘要: There are some tips which are helpful for SSB beginners to debug and resolve some general issues.阅读全文
posted @ 2006-12-27 23:06 Rickie 阅读(390) | 评论 (0) 编辑

SSB FAQ (3) – A rowset provider OPENXML
摘要: OPENXML provides a rowset view over an XML document.
OPENXML SYNTAX:
OPENXML( idoc int [ in] , rowpattern nvarchar [ in ] , [ flags byte [ in ] ] )
[ WITH ( SchemaDeclaration | TableName ) ]

阅读全文
posted @ 2006-12-27 22:04 Rickie 阅读(331) | 评论 (0) 编辑

SSB FAQ (2) – Create a stored procedure as a service program
摘要: CREATE QUEUE [dbo].[Queue_OutStock_Out] WITH STATUS = ON , RETENTION = OFF ,
ACTIVATION
( STATUS = ON ,
PROCEDURE_NAME = [dbo].[usp_OutStock_OnReceiveMessage] ,
MAX_QUEUE_READERS = 5 , EXECUTE AS N'dbo'
)

阅读全文
posted @ 2006-12-27 21:35 Rickie 阅读(341) | 评论 (0) 编辑

SSB FAQ (1) – Target Queue cannot receive message
摘要: SSB target queue can not get a message, when the sender sends a message without any error.

阅读全文
posted @ 2006-12-27 18:53 Rickie 阅读(309) | 评论 (0) 编辑

SSB Exception - Sql Server 2005
摘要: SSB Exception - Sql Server 2005阅读全文
posted @ 2006-12-21 13:50 Rickie 阅读(565) | 评论 (1) 编辑

Database Engine Tuning Adviser: How to tune your new SQL Server 2005
posted @ 2006-12-15 16:55 Rickie 阅读(354) | 评论 (0) 编辑

Microsoft SQL Server 2005 Setup FAILED!
posted @ 2006-12-12 14:44 Rickie 阅读(1063) | 评论 (0) 编辑

Overview of Sql Cache Dependency
posted @ 2006-05-19 15:23 Rickie 阅读(504) | 评论 (0) 编辑

MS的一个BUG折腾我几个小时！
posted @ 2006-05-13 21:40 Rickie 阅读(525) | 评论 (3) 编辑

Multiple Active Result Sets (MARS) in ADO.NET 2.0 and SQL Server 2005
摘要: Multiple Active Result Sets (MARS) is a new feature of ADO.NET 2.0 that provides the capability to open more than one result set over the same connection and lets you access them all concurrently. Prior to MARS, each result set required a separate connection. Currently, the first commercial database to support MARS is SQL Server 2005. 阅读全文
posted @ 2006-03-09 21:59 Rickie 阅读(2229) | 评论 (0) 编辑

SQL Server 2005 Beta 2 Service Broker: Stored Procedure acts as a service program
摘要: 这里演示同一个SQL Server中不同数据库之间的基于Service Broker的异步消息传递，其中Stored Procedure充当Service Program。阅读全文
posted @ 2005-04-16 05:32 Rickie 阅读(1267) | 评论 (0) 编辑

SQL Server 2005 Beta 2 Service Broker: State of conversation endpoint
摘要: Conversation Endpoints can be looked up via querying the sys.conversation_endpoints catalog view in the local broker's database. In this way, we continue on a demo to check Conversation Endpoints in both the Initiator and Target Endpoints.阅读全文
posted @ 2005-04-09 04:57 Rickie 阅读(1092) | 评论 (1) 编辑

SQL Server 2005 Beta 2 Service Broker: Create Route
摘要: Following the previous post, A simple tutorial on SQL Server 2005 Beta 2 Service Broker, this post will handle how to send messages to and from in the different Database or SQL Server.阅读全文
posted @ 2005-04-08 00:44 Rickie 阅读(1130) | 评论 (3) 编辑

A simple tutorial on SQL Server 2005 Beta 2 Service Broker
摘要: Service Broker is a new technology in Microsoft SQL Server 2005 Beta 2 that helps database developers build secure, reliable, and scalable applications. Service Broker provides queuing and reliable messaging as part of the Database Engine. These features provide the infrastructure necessary to build high-performance applications that easily scale-up or scale-out.阅读全文
posted @ 2005-04-07 23:48 Rickie 阅读(1468) | 评论 (1) 编辑

SQL Server 2005 webcast Series [English]
摘要: SQL Server 2005 webcast Series [English]阅读全文
posted @ 2005-04-07 02:17 Rickie 阅读(701) | 评论 (0) 编辑

Microsoft SQL Server 2005 Beta2初步体验
摘要: SQL Server 2005对SQL Server 2000而言，总体感觉各个方面均很大的提升。因为短短试用了几天，简单记录一下自己的体验。阅读全文
posted @ 2005-04-04 03:05 Rickie 阅读(1560) | 评论 (1) 编辑