04 2014 档案

SET Statements for SQLServer
摘要：SET SHOWPLAN_ALL { ON | OFF }It will not execute the TSQL statements.It cannot be specified inside a stored procedure,must be the only statements in a... 阅读全文
posted @ 2014-04-29 21:46 princessd8251 阅读(429) 评论(0) 推荐(0) 编辑
Change Tracking of SQLServer
摘要：1.Enable the change tracking at the database level.ALTER DATABASE AdventureWorks2008 SET CHANGE_TRACKING = ON;By Default retention is 2 dyas with auto... 阅读全文
posted @ 2014-04-27 02:04 princessd8251 阅读(651) 评论(0) 推荐(0) 编辑
SQLServer DMV Query
摘要：1.DMV Query to identify all active SQL Server SessionsThe query below identifies all currently active SQL Server user connections by their SQL Server ... 阅读全文
posted @ 2014-04-22 19:04 princessd8251 阅读(272) 评论(0) 推荐(0) 编辑
SQL Server Logical/Physical Reads
摘要：Summary Info:Logical Reads : Reading Data pages from CachePhysical Reads : Reading Data pages from Hard DiskBuffer Cach Hit Ratio: (logical reads – ... 阅读全文
posted @ 2014-04-22 18:27 princessd8251 阅读(746) 评论(0) 推荐(0) 编辑
The include feature of SQL Server Index
摘要：1. Why we need the index 'include' feature? For SQLServer , the length of all the index key have a limit length as 900 byte.when you create a index wh... 阅读全文
posted @ 2014-04-22 17:01 princessd8251 阅读(273) 评论(0) 推荐(0) 编辑
Declare Cusror of SQLServer
摘要：Defines the attributes of a Transact-SQL server cursor, such as its scrolling behavior and the query used to build the result set on which the cursor ... 阅读全文
posted @ 2014-04-21 23:40 princessd8251 阅读(351) 评论(0) 推荐(0) 编辑
给锁住的行解锁（oracle）
摘要：1、查看数据库锁,诊断锁的来源及类型： select object_id,session_id,locked_mode from v$locked_object;或者用以下命令：select b.owner,b.object_name,l.session_id,l.locked_modefrom v... 阅读全文
posted @ 2014-04-19 00:49 princessd8251 阅读(256) 评论(0) 推荐(0) 编辑
SET Statements (Transact-SQL)
摘要：The Transact-SQL programming language provides several SET statements that change the current session handling of specific information. The SET statem... 阅读全文
posted @ 2014-04-18 16:28 princessd8251 阅读(275) 评论(0) 推荐(0) 编辑
SQLServer temporary table and table variable
摘要：Temporary tables are created in tempdb. The name "temporary" is slightly misleading, for even though the tables are instantiated in tempdb and backed ... 阅读全文
posted @ 2014-04-17 20:40 princessd8251 阅读(694) 评论(0) 推荐(0) 编辑
Nested transactions in stored procedure of SQLServer
摘要：question:if the nested transaction encountered an exception, then rollbacked. How about the outer transaction?Lets demo this using below code.create p... 阅读全文
posted @ 2014-04-16 21:43 princessd8251 阅读(491) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示