05 2014 档案

Troubleshooting Insufficient Disk Space in tempdb
摘要：his topic provides procedures and recommendations to help you diagnose and troubleshoot problems caused by insufficient disk space in thetempdb databa... 阅读全文
posted @ 2014-05-24 03:51 princessd8251 阅读(573) 评论(0) 推荐(0) 编辑
Using SQL DMVs – sys.dm_db_file_space_usage
摘要：You can use the sys.dm_db_file_space_usage dynamic management view to monitor the spaced used bytempdbfor storing user/internal objects and version st... 阅读全文
posted @ 2014-05-24 03:30 princessd8251 阅读(203) 评论(0) 推荐(0) 编辑
Be Prepared: Collecting Data from sp_WhoIsActive in a Table
摘要：I am a fangirl ofAdam Machanic‘s sp_whoisactive stored procedure.Be prepared. When things go wrong, you want to focus on the problem itself. Make a pl... 阅读全文
posted @ 2014-05-24 03:17 princessd8251 阅读(351) 评论(0) 推荐(0) 编辑
Deferred Deallocations of Pages in TempDb
摘要：The other day I ran into a question on msdn:Tempdb Deallocation (dm_db_session_space_usage). A person with the pseudonym DontPageMeBro noticed an odd ... 阅读全文
posted @ 2014-05-24 03:15 princessd8251 阅读(135) 评论(0) 推荐(0) 编辑
Bug: sys.dm_db_session_space_usage Reporting Extremely High Tempdb Allocations
摘要：A little more than a year ago while working atIdera, I was consulted on reports from a few clients using the Idera monitoring toolSQL diagnostic manag... 阅读全文
posted @ 2014-05-24 03:14 princessd8251 阅读(279) 评论(0) 推荐(0) 编辑
Prefetch – Querying at the speed of SAN
摘要：Prefetch is a mechanism with which SQL Server can fire up many I/O requests in parallel for Nested Loop join.The SAN administrator says your data volu... 阅读全文
posted @ 2014-05-23 02:03 princessd8251 阅读(292) 评论(0) 推荐(0) 编辑
SQL Server Prefetch and Query Performance
摘要：IntroductionPrefetching is often ignored by developers and DBAs when they are analyzing performance problems. After you’ve read this article I hope yo... 阅读全文
posted @ 2014-05-23 02:01 princessd8251 阅读(206) 评论(0) 推荐(0) 编辑
Links
摘要：Reading Pageshttp://technet.microsoft.com/en-us/library/ms191475(v=sql.105).aspxHeap Structureshttp://technet.microsoft.com/en-us/library/ms188270(v=s... 阅读全文
posted @ 2014-05-23 01:22 princessd8251 阅读(164) 评论(0) 推荐(0) 编辑
Useful query
摘要：Create function to check SQL instance CPU loadcreate function check_cpu_load ()returns tableasreturn(SELECT SQLProcessUtilization, 100 - S... 阅读全文
posted @ 2014-05-23 01:08 princessd8251 阅读(167) 评论(0) 推荐(0) 编辑
SQL Server Buffer Pool Distribution
摘要：Key points about SQL Server buffer pool:1,A buffer is an 8-KB page in memory, the same size as a data or index page. Each cached data page has one buf... 阅读全文
posted @ 2014-05-22 22:14 princessd8251 阅读(304) 评论(0) 推荐(0) 编辑
SQL Server – Understanding Allocation Units – In Row Data, LOB Data & Row Overflow Data
摘要：Before we get started on this topic, here is a quick fact..in SQL Server 2000, there used to be hard limit on the data that can be stored in a single ... 阅读全文
posted @ 2014-05-22 19:31 princessd8251 阅读(336) 评论(0) 推荐(0) 编辑
%%lockres% and %%physloc%%
摘要：These two can be seen as a scalar function return different values ??in different rows.The following description of the test environment are as follow... 阅读全文
posted @ 2014-05-22 02:21 princessd8251 阅读(653) 评论(0) 推荐(0) 编辑
Undocumented Virtual Column: %%lockres%
摘要：Fromhttp://scarydba.wordpress.com/2010/03/18/undocumented-virtual-column-lockres/One of my development teams needed a mechanism for identifying the va... 阅读全文
posted @ 2014-05-22 02:13 princessd8251 阅读(189) 评论(0) 推荐(0) 编辑
Investigating Transactions Using Dynamic Management Objects
摘要：Every statement executed against SQL Server is transactional, and SQL Server implements various transaction isolation levels, to ensure the ACID (Atom... 阅读全文
posted @ 2014-05-22 02:06 princessd8251 阅读(223) 评论(0) 推荐(0) 编辑
SQL Server 2008 storage structure of the object is stored view
摘要：In fact, the most important storage structure of the database objects to the two SQLServer support system view, that sys.partitions and the sys.alloca... 阅读全文
posted @ 2014-05-22 02:04 princessd8251 阅读(183) 评论(0) 推荐(0) 编辑
Introduction to Locking in SQL Server
摘要：fromhttp://www.sqlteam.com/article/introduction-to-locking-in-sql-serverLocking is a major part of every RDBMS and is important to know about. It is a... 阅读全文
posted @ 2014-05-22 01:47 princessd8251 阅读(149) 评论(0) 推荐(0) 编辑
SQL Server storage view sys.objects, sys.partitions, sys.allocation_units and sys.system_internals_allocation_units
摘要：from http://beyondrelational.com/modules/2/blogs/59/posts/13693/sql-server-storage-internals-part-2-partitions-and-allocation-units.aspxBefore moving ... 阅读全文
posted @ 2014-05-22 01:46 princessd8251 阅读(383) 评论(0) 推荐(0) 编辑
SQL Server中In-Flight日志究竟是多少
摘要：转自http://www.cnblogs.com/CareySon/p/3195276.html在SQL Server中，利用日志的WAL来保证关系数据库的持久性，但由于硬盘的特性，不可能使得每生成一条日志，就 直接向磁盘写一次，因此日志会被缓存起来，到一定数据量才会写入磁盘。这部分已经生成的，却没... 阅读全文
posted @ 2014-05-22 01:21 princessd8251 阅读(146) 评论(0) 推荐(0) 编辑
SP_HELP / SP_HELPINDEX / SP_HELPTEXT
摘要：sp_helptext显示规则、默认值、未加密的存储过程、用户定义函数、触发器或视图的文本。 语法sp_helptext [ @objname = ] 'name' 参数[@objname =] 'name' 对象的名称，将显示该对象的定义信息。对象必须在当前数据库中。name 的数据类型为 nva... 阅读全文
posted @ 2014-05-21 10:25 princessd8251 阅读(425) 评论(0) 推荐(0) 编辑
XQuery Labs - A Collection of XQuery Sample Scripts
摘要：fromhttp://beyondrelational.com/modules/2/blogs/28/posts/10279/xquery-labs-a-collection-of-xquery-sample-scripts.aspxI have always experienced and am ... 阅读全文
posted @ 2014-05-21 00:47 princessd8251 阅读(372) 评论(0) 推荐(0) 编辑
An XEvent a Day (6 of 31) – Targets Week – asynchronous_file_target
摘要：Yesterday’s post,Targets Week - ring_buffer, looked at the ring_buffer Target in Extended Events and how it outputs the raw Event data in an XML docum... 阅读全文
posted @ 2014-05-20 23:32 princessd8251 阅读(219) 评论(0) 推荐(0) 编辑
An XEvent a Day (5 of 31) - Targets Week – ring_buffer
摘要：Yesterday’s post,Querying the Session Definition and Active Session DMV’s, showed how to find information about the Event Sessions that exist inside a... 阅读全文
posted @ 2014-05-20 21:14 princessd8251 阅读(194) 评论(0) 推荐(0) 编辑
An XEvent a Day (4 of 31) – Querying the Session Definition and Active Session DMV’s
摘要：Yesterdays post,Managing Event Sessions, showed how to manage Event Sessions in Extended Events Sessions inside the Extended Events framework in SQL S... 阅读全文
posted @ 2014-05-20 21:13 princessd8251 阅读(195) 评论(0) 推荐(0) 编辑
An XEvent a Day (3 of 31) – Managing Event Sessions
摘要：Yesterdays post,Querying the Extended Events Metadata, showed how to discover the objects available for use in Extended Events. In todays post, we’ll ... 阅读全文
posted @ 2014-05-20 21:12 princessd8251 阅读(165) 评论(0) 推荐(0) 编辑
An XEvent a Day (2 of 31) – Querying the Extended Events Metadata
摘要：In yesterdays post,An Overview of Extended Events, I provided some of the necessary background for Extended Events that you need to understand to begi... 阅读全文
posted @ 2014-05-20 21:11 princessd8251 阅读(237) 评论(0) 推荐(0) 编辑
An XEvent a Day (1 of 31) – An Overview of Extended Events
摘要：First introduced in SQL Server 2008, Extended Events provided a new mechanism for capturing information about events inside the Database Engine that w... 阅读全文
posted @ 2014-05-20 21:09 princessd8251 阅读(188) 评论(0) 推荐(0) 编辑
Using the Blocked Process Report in SQL Server 2005/2008
摘要：Locking is a familiar concept to anyone working with SQL Server. However, when a process holds locks for a long period of time, other processes can be... 阅读全文
posted @ 2014-05-15 22:36 princessd8251 阅读(434) 评论(0) 推荐(0) 编辑
10 More Common Mistakes Java Developers Make when Writing SQL
摘要：I was positively surprised to see how popular my recent listingabout10 Common Mistakes Java Developers Make when Writing SQLwas, bothon my own blogand... 阅读全文
posted @ 2014-05-15 17:42 princessd8251 阅读(156) 评论(0) 推荐(0) 编辑
Tuning a 'LIKE-clause' by using Oracle Text or Reverse Key Indexes
摘要：The LIKE-clause can ignore indexes, causing queries to run forever while doing full table scans. This document describes how to tune such SQL statemen... 阅读全文
posted @ 2014-05-15 17:40 princessd8251 阅读(216) 评论(0) 推荐(0) 编辑
Technical: Microsoft – SQL Server – Query – Like Clause – Optimization – Using Prepared Statements
摘要：IntroductionSQL Server Like Clause – Another path to helping SQL Server use our Index.BackgroundMicrosoft – SQL Server – Query Likehttp://danieladenij... 阅读全文
posted @ 2014-05-15 14:55 princessd8251 阅读(223) 评论(0) 推荐(0) 编辑
Technical: Microsoft – SQL Server – Query – Like Clause – Optimization – Using Query Hint – Optimize for “value”
摘要：IntroductionSQL Server Like Clause – Another path to helping SQL Server use our Index.BackgroundMicrosoft – SQL Server – Query Likehttp://danieladenij... 阅读全文
posted @ 2014-05-15 14:54 princessd8251 阅读(145) 评论(0) 推荐(0) 编辑
Technical: Microsoft – SQL Server – Query – Like Clause (using sqlcmd.exe)
摘要：IntroductionThis is a short follow-up to our last discussion on SQL Server optimization path when it processes SQL Like Clause.BTW, the URL to that di... 阅读全文
posted @ 2014-05-15 14:52 princessd8251 阅读(154) 评论(0) 推荐(0) 编辑
Technical: Microsoft – SQL Server – Query – Like Clause
摘要：IntroductionIn Database Applications, the SQL Clause (like) is often used to match on partial terms. The Application developer can allow end-users to ... 阅读全文
posted @ 2014-05-15 14:50 princessd8251 阅读(142) 评论(0) 推荐(0) 编辑
SQL Server 2012: Adding Not Null columns to an existing table
摘要：Most of you must have come across the pain of adding a not null column with a default value to an existing big table. It takes minutes to add columns.... 阅读全文
posted @ 2014-05-15 14:11 princessd8251 阅读(245) 评论(0) 推荐(0) 编辑
T-SQL Tuesday #11: Misconceptions about…. EVERYTHING!!
摘要：This month's T-SQL Tuesday is being run by fellow-MVP Sankar Reddy (blog|twitter) and the topic is aboutMisconceptions in SQL Server.(Check out the 60... 阅读全文
posted @ 2014-05-15 00:43 princessd8251 阅读(173) 评论(0) 推荐(0) 编辑
An XEvent A Day: 31 days of Extended Events
摘要：Back in April, Paul Randal (Blog|Twitter) did a 30 day series titledA SQL Server Myth a Day, where he covered a different myth about SQL Server every ... 阅读全文
posted @ 2014-05-15 00:41 princessd8251 阅读(225) 评论(0) 推荐(0) 编辑
virtual columns in 11g
摘要：Oracle has supported stored expressions for many years, in views and function-based indexes. Most commonly, views enable us to store and modularise co... 阅读全文
posted @ 2014-05-05 16:53 princessd8251 阅读(307) 评论(0) 推荐(0) 编辑
Monitoring SQL Server 2012 - Capture and Parse sp_server_diagnostics output
摘要：ProblemIf you're one of the lucky ones, you or your company has the ability to purchase third party software to monitor the health of your database sy... 阅读全文
posted @ 2014-05-05 00:03 princessd8251 阅读(421) 评论(0) 推荐(0) 编辑

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