Welcome to TechNet Blogs
Sign in
|
Join
|
Help
Mat Stephen's SQL Server WebLog
All things SQL Server. Complied by Matthew Stephen - SQL Server Product Specialist, Microsoft UK
This Blog
Email
Syndication
RSS 2.0
Atom 1.0
Search
Go
News
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified on Microsoft.com
Microsoft Evangelists UK
John Howard
Eileen Brown
Steve Lamb
Personal sites of interest
LifeLikeFriends
SQL Server Blogroll
Bob Beauchemin's Blog - Top trainer and Author
Mosha Pasumansky, Microsoft OLAP Server Development
Technorati Profile
Donald Farmer - Microsoft SQL Server Integration Services Group Program Manager
Euan Garden - SQL Server Group Program Manager
SQL Server sites of interest
SQL Server's home page
SQL Server on Technet
SQL Server Security Center
SQL Server on MSDN
SQL Server 2005
SQL server 2005 | data mining
SQL Server Developer Center - SQL Server 2005 Webcasts
Webcasts and chats for SQL Server
Get the Facts on Database Security
Reporting Services TechNet Site
sql-server-performance.com
SQL Server Integration Services - Community
SQL Server Integration Services - Microsoft Corp.
Analysis Services - Microsoft Corp.
UK Bloggers
Jamie Thomson for Integration Services
Chris Webb's BI Blog - Extreme MDX
Useful Integration Services Docs
Project REAL—Business Intelligence in Practice
Managing and Deploying SQL Server Integration Services
Conchango Describes How SQL Server 2005 Integration Services Compares with Informatica
Useful SQL 2000 Docs
Microsoft SQL Server 2000 Analysis Services Performance Guide
Microsoft SQL Server 2000 RDBMS Performance Tuning Guide for Data Warehousing
SQL Server 2000 Operations Guide
Microsoft SQL Server 2000 High Availability Series
SQL Server 2000 Backup and Restore
Analysis Services 2000 Whitepapers
Useful SQL 2005 Docs
Troubleshooting Performance Problems in SQL Server 2005
SQL Server 2005 comparison: features by edition
Tags
Analysis Services 2005
Architects Corner
Blogcasts
Business Intelligence
Code samples
Free SQL Server Tools, Utilities and Addins
High Availability
High Availability and Disaster Recovery
Oracle
Performance
Performance Top Tips
Post Event Follow Up
Replication
Reporting Services
SAP
Service Broker
SQL 64 bit
SQL Server 2000
SQL Server 2005
SQL Server Integration Services
SQL Server Security
T-SQL
Webcasts
Recent Posts
Free SAP Customer Workshops "How Microsoft Runs SAP" Munich on February 7, 2006 and in Brussels
SQL 2005 Metadata Samples Toolkit and whitepaper now available
New Performance Troubleshooting Guide for SQL2005
New SQL 2005 code samples available
Feature Pack for Microsoft SQL Server 2005 - November 2005
Archives
January 2006 (4)
November 2005 (4)
October 2005 (3)
September 2005 (9)
August 2005 (13)
July 2005 (14)
June 2005 (24)
May 2005 (19)
April 2005 (18)
March 2005 (9)
February 2005 (18)
January 2005 (7)
December 2004 (18)
Browse by Tags
All Tags
»
SQL Server 2000
»
Performance
(RSS)
Blogcasts
Post Event Follow Up
SQL 64 bit
SQL Server 2005
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
Filed under:
Performance
,
SQL 64 bit
,
SQL Server 2000
,
SQL Server 2005
Friday, August 19, 2005 2:20 PM
Blogcasts: SQL Server 2000 - Configuring System Monitor & Monitoring SQL Server performance & Configuring alerts
Three new SQL Server 2000 blogcasts out of Redmond: Demo 4-1 Configuring System Monitor http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_4-1.asx Demo 4-2 Monitoring SQL Server performance http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_4-2.asx
Posted by
Mat_Stephen
|
1 Comments
Filed under:
Blogcasts
,
Performance
,
SQL Server 2000
Friday, July 22, 2005 2:15 PM
Blogcast: Using SQL 2000 Profiler
Here's another blogcast in the SQL 2000 performance blogcast series out of the States - this time 'Using SQL 2000 Profiler'. This one's a bit long at 11mins 8secs. http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_3.asx
Posted by
Mat_Stephen
|
1 Comments
Filed under:
Blogcasts
,
Performance
,
SQL Server 2000
Tuesday, July 12, 2005 10:48 AM
Blogcast: SQL Server 2000 - Using the Index Tuning Wizard
Another blogcast from the States covering performance tuning in SQL Server 2000, this one covers using index tuning wizard. 6 mins 47 secs http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_2.asx
Posted by
Mat_Stephen
|
0 Comments
Filed under:
Blogcasts
,
Performance
,
SQL Server 2000
Monday, June 20, 2005 5:47 PM
Blogcast: SQL Server 2000 Performance Demo 1-3 Managing indexes
Here's a Blogcast, the third in a series of three from the US, looking at Performance tuning techniques with SQL 2000 'Managing indexes' http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_1-3.asx
Posted by
Mat_Stephen
|
0 Comments
Filed under:
Blogcasts
,
Performance
,
SQL Server 2000
Monday, June 20, 2005 5:44 PM
Blogcast: SQL Server 2000 Performance Demo 1-2 Analyzing an execution plan
Here's a Blogcast, second in a series of three from the US, looking at Performance tuning techniques with SQL 2000 'Analyzing an execution plan' http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_1-2.asx
Posted by
Mat_Stephen
|
0 Comments
Filed under:
Blogcasts
,
Performance
,
SQL Server 2000
Monday, June 20, 2005 5:40 PM
Blog cast SQL Server 2000 Performance Demo 1-1 Searching and browsing objects
Here's a Blogcast, one of a series of three from the US, looking at Performance tuning techniques with SQL 2000 http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_1-1.asx
Posted by
Mat_Stephen
|
0 Comments
Filed under:
Blogcasts
,
Performance
,
SQL Server 2000
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
Filed under:
Performance
,
Post Event Follow Up
,
SQL Server 2000
,
SQL Server 2005
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
Filed under:
Performance
,
SQL Server 2000
,
SQL Server 2005