Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2005 » Performance   (RSS)
Tuesday, January 03, 2006 10:12 AM

New Performance Troubleshooting Guide for SQL2005

Many things have changed with SQL 2005, correspondingly we have to change the way we think about troubleshooting performance problems. The most significant change is the advent of the new Dynamic Management Views (DMV), these are going to take some getting
Posted by Mat_Stephen | 0 Comments
Monday, September 12, 2005 10:27 PM

Getting to know SQL 2005 Service Broker

Looks likes I've got to do a presentation on Service Broker for the SQL 2005 launch - so I've been doing some home work on the subject. The best primer I've found is http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlsvcbroker.asp?frame=true
Posted by Mat_Stephen | 0 Comments
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, August 31, 2005 10:34 AM

SQL 2005 - UPSERT: In nature but not by name; but at last!

SQL Server has long been criticised for not having an UPSERT command, well now in SQL 2005 we have some good news, we have two new TSQL set operators that give us the complex insert/update logic that constitute an UPSERT. These are INTERSECT and EXCEPT
Posted by Mat_Stephen | 1 Comments
Tuesday, August 30, 2005 4:27 PM

Project REAL—Business Intelligence in Practice - great website!

For sometime a group of Program Managers from the SQL BI team have been working with a customer, Barnes and Noble, to produce a SQL BI solution for their data warehouse and analysis needs using SQL 2005. The leasons learnt from all their work is being
Posted by Mat_Stephen | 0 Comments
Thursday, August 25, 2005 1:23 PM

64 Bit performance v 32 bit performance - some compelling evidence

More and more ITPros are looking for help in deciding between 64 bit and 32 bit boxes, often they are looking for evidence that 64 bit is worth the investment and worth the risk (of adopting a new platform). This link http://www.microsoft.com/sql/64bit/productinfo/winhecdemo.mspx
Posted by Mat_Stephen | 1 Comments
Thursday, June 23, 2005 5:40 PM

Cool new OVER Clause (Transact-SQL) in SQL Server 2005

Cool new OVER Clause (Transact-SQL) in SQL Server 2005 to circumvent the not so efficient correlated subquery. Imagine a table: create table grades( StudentID int not null ,StudentName varchar(10) not null ,Subject varchar(10) not null ,Score int not
Posted by Mat_Stephen | 1 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
Thursday, June 16, 2005 11:13 PM

More follow up from my TechNet SQL 2005 presentation (14/6/05) - SMP boxes and database files

During my TechNet presentation on Tuesday evening (14/6/05 in Reading), I got a little side tracked and, while talking about partitioning in SQL 2005, found myself drawing my audiences’ attention to the fact that only one thread can access a database
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
Thursday, May 19, 2005 11:38 AM

SQL Server 2000 vs SQL Server 2005 Performance

As SQL server 2005 gets closer more and more people are asking how much faster is it than SQL Server 2000. Thanks to Rog Garrison here's one of the first tests I've seen http://www.sqljunkies.com/Tutorial/077C7BEB-EB31-4A07-923D-BE309F59D0F8.scuk Thank
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
 
Page view tracker