Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » Performance » High Availability and Disaster Recovery   (RSS)
Tuesday, September 06, 2005 6:11 PM

SQL 2005: Making sense of the new Optimistic Concurrency Controls and the readers that block writers

For a long time now Oracle enthusiasts have bashed SQL Server for not having Optimistic Concurrency Controls. They would demonstrate a SQL Server reader blocking a writer and possibly a writer blocking a reader. Thus, having appeared to demonstrate that
Posted by Mat_Stephen | 0 Comments
Wednesday, June 22, 2005 9:31 PM

Follow up on Database snapshot performance question from SQL Server™ 2005 High Availability TechNet evening 21/6/05

Follow up on Database snapshot performance question from SQL Server™ 2005 High Availability TechNet evening 21/6/05 Question; how does a snapshot database perform compared to the original database when it comes to querying – can it make use of the indexes
Posted by Mat_Stephen | 0 Comments
Monday, May 23, 2005 5:23 PM

Processing XML Showplans Using SQLCLR in SQL Server 2005 - Make Use of the New XML Showplans

SQL 2005 now provides Showplan (Query plan) output in XML - why? To make it easier for a dba/developer to write TSQL, or other code, that can determine the cost of a query and thus dynamically determine if the query should be prevented from running based
Posted by Mat_Stephen | 0 Comments
Monday, April 18, 2005 4:49 PM

TechNet Roadshow Example code for Microsoft SQL Server 2005 Table partitioning

For those who want to give this a try, this is the code I've been using on the 2K5 H1 roadshow for my SQL 2k5 Table Partitioning demo. USE AdventureWorks GO ALTER DATABASE AdventureWorks ADD FILEGROUP FG1 ALTER DATABASE AdventureWorks ADD FILEGROUP FG2
Posted by Mat_Stephen | 0 Comments
Tuesday, February 08, 2005 3:50 PM

Microsoft SQL Server Performance Top Tip: Degrees of Parallelism and a Degree of Uncertainty

Max degree of parallelism is an advanced configuration option in SQL Server about which many question have been asked and much written. In this blog entry I hope to offer some insight and certainty as to what this option does and how it should be used.
Posted by Mat_Stephen | 2 Comments
Friday, January 07, 2005 11:23 AM

SQL Server Health and History Tool (SQLH2)

This tool has been available for a couple of months but I only found out about it yesterday; I was reading some stuff about SQL Server 2005 and found a reference to say this tool will be supported in SQL 2k5. Realising such downloads have sometimes escaped
Posted by Mat_Stephen | (Comments Off)
 
Page view tracker