Tuesday, January 06, 2009
Register
Login
SQL Home
Events
Discussions
Articles
Scripts/Tools
Tips & Tricks
Resources
Community
Job Board
SQL-FEST
You Are Here:
Resources
»
SQL Server Teams at Microsoft
»
SQL Server Product Support Services Team
SQL Community Portal
SQL
Community Home
SQL
Tips & Tricks
SQL
Blogs
SQL
Discussion Forums
SQL
Automation Central
SQL
Community Articles
SQL
TechNet Articles
SQL
Upgrade Central
SQL
Laboratory
SQL
Wikipedia
SQL
Server RADIO
SQL
World Wide Events
SQL
Job Listings
SQL
Clinics
Recently Submitted Articles
Grouping Sets
12/28/2008
Windows / SQL Server Services
12/27/2008
SQL Server 2008 Data Compression
10/28/2008
How to Retrieve the Last Objects Changed In SQL Server 2005
10/28/2008
Multi-Server Deployment and Management Using SQL Server Central Management Server
10/6/2008
Recent SQL Clinic Articles
Configuring DBM on a Low-Bandwidth Networks
6/3/2008
Achieving Geo-redundancy with Database Mirroring
5/15/2008
Best Practices when performing maintenance in a DBM environment
3/11/2008
How to read data from a Mirror database using Database Snapshots
3/6/2008
Comparing Failover Clustering with Database Mirroring
2/25/2008
Direct from SQL Server PSS Team
Close
Move
SQL Server 2000 Downloads
SQL Server 2000 Service Pack 4 (SP4)
SQL Server 2000 Service Pack 3a (SP3a)
SQL Server 2000 Service Pack 2 (SP2)
SQL Server 2000 Service Pack 1 (SP1)
SQL Server 2000 Reporting Services Downloads
Reporting Services Service Pack 2 (SP2)
Reporting Services Service Pack 1 (SP1)
SQL Server 2000 Notification Services SP Downloads
Notification Services 2.0 Service Pack 1 (SP1)
SQL Server 2000 Notification Services, Enterprise Edition 2.0 Service Pack 1 (SP1)
SQL Server 2000 Notification Services, Standard Edition 2.0 Service Pack 1 (SP1)
SQL Server CE Downloads
SQL Server CE Service Pack 1 (SP3)
SQL Server CE 1.1 Service Pack 1 (SP1) Update
SQLXML 3.0 Service Pack Downloads
SQLXML 3.0 Service Pack 3 (SP3)
SQLXML 3.0 Service Pack 2 (SP2)
SQLXML 3.0 Service Pack 1 (SP1)
SQL Server 2000 JDBC Driver
SQL Server 2000 Driver for JDBC Service Pack 3 (SP3)
SQL Server 2000 Driver for JDBC Service Pack 2 (SP2)
SQL Server 2000 Driver for JDBC Service Pack 1 (SP1)
MDAC 2.6 Download
Microsoft Data Access Components (MDAC) 2.6 Service Pack 2 (SP2)
SQL Server 2000 Tools Downloads
Microsoft SQL Server 2005 Upgrade Advisor
Support Tools Available for Stress Testing and Performance Analysis
PSSDIAG Data Collection Utility
Download SQL Server Accelerator for Business Intelligence (BI)
SQL Server 2000 Security Tools
Microsoft SQL Web Data Administrator
SQL Server 2000 Desktop Engine Deployment Toolkit (Sample Application)
SQL Server Management Pack
SQL Server 2000 Best Practices Analyzer 1.0
SQL Server 2000 Driver for JDBC Service Pack 3 (SP3)
MSDEToText Tool for Internet Security and Acceleration (ISA) Server 2004
SQL Server 2000 SP4 Replication Components
SQL Server 2000 Web Services Toolkit
Updated Samples for SQL Server 2000
SQL Server 2000 Report Pack for IIS Logs
SQL Server 2000 Report Pack for Microsoft SharePoint Portal Server
SQL Server 2000 Report Pack for Microsoft Exchange
SQL Server 2000 Report Pack for Financial Reporting
SQL Server 2000 Report Pack for Great Plains
SQL Server Report Pack for Microsoft Customer Relationship Management (CRM)
SQL Server 2000 Report Pack for Microsoft Axapta 3.0
SQL Server 2000 Report Pack for Microsoft Axapta 3.0
SQL Server 2000 Report Pack for Microsoft SharePoint Portal Server 2003
SQL Server 2000 Report Pack for Internet Information Services (IIS) Logs
SQL Server 2000 Report Pack for Microsoft Business Solutions—Great Plains 8.0
SQL Server 2000 Report Pack for Microsoft Customer Relationship Management (CRM)
SQL Server 2000 Report Pack for Microsoft Exchange
SQL Server 2000 Report Pack for Financial Reporting
Reporting Services for SQL Server 2000 Trial Software
Reporting Services for SQL Server 2000 Books Online Update
Developing Applications Using SQL Server 2000 Reporting Services
SQL Server 2000 Health and History Tool (SQLH2) Reports
SQL Server CE 2.0
SQL Server CE 2.0 Books Online
SQL Server CE 2.0 Update for Use with IIS and SQL Server 2000 SP4
Important Information for SQL Server 2000 SP3 and SP3a Users
Notification Services Events
Close
Move
SQL Server 7.0 and 6.x Downloads
SQL Server 7.0 Books Online
SQL Server 7.0 Service Pack 4 (SP4)
SQL Server 7.0 Security Update for Service Pack 4
SQL Server 7.0 Service Pack 3 for Intel Platforms
SQL Server 7.0 OLAP Services SP3
SQL Server 7.0 Service Pack 2 (Intel)
SQL Server 7.0 Service Pack 1 for Intel
SQL Server 7.0 Security Patch MS03-031
Fix: Service Pack Installation May Save Standard Security Password in File
SQL Server 6.5 Service Pack 5a (SP5a)
SQL Server 7.0 Tools Downloads
Migrating Sybase Applications to SQL Server 7.0
SQL Server Management Pack
SQL Server DataSizer Tool
OLAP Manager Add-In Kit
Office 2001 Data Access Update
SQL Server 7.0 Samples
OLAP Services: Web Browser Sample
Active Server Pages Sample Application
Active Server Pages Sample Application
Visual Basic Sample Application
Visual C++ Sample Application
OLAP Services Sample
Close
Move
SQL Server 2005 & SQL Server 2000 Best Practices
·
Database Snapshot Performance Considerations under I/O-Intensive Workloads
·
Best Practices for Migrating Non-Unicode Data Types to Unicode
·
Database Mirroring and Log Shipping Working Together
·
Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques
·
The Impact of Changing Collations and of Changing Data Types from Non-Unicode to Unicode
·
Precision Considerations for Analysis Services Users
·
Scale-Out Querying with Analysis Services Using SAN Snapshots
·
Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services
·
XML Best Practices for Microsoft SQL Server 2005
·
Performance Optimizations for the XML Data Type in SQL Server 2005
·
SQL Server 2005 Security Best Practices - Operational and Administrative Tasks
·
SQL Server 2005 Full-Text Queries on Large Catalogs: Lessons Learned
·
Scale-Out Querying with Analysis Services
·
SQL Server 2005 Analysis Services Processing Best Practices
·
Pre-deployment I/O Best Practices
·
Partial Database Availability
·
Comparing Tables Organized with Clustered Indexes versus Heaps
·
SQL Server 2005 Deployment Guidance for Web Hosting Environments
·
Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarios
·
Implementing Application Failover with Database Mirroring
·
OLAP Design Best Practices for Analysis Services 2005
·
DBCC SHOWCONTIG Improvements and Comparison between SQL Server 2000 and SQL Server 2005
·
TEMPDB Capacity Planning and Concurrency Considerations for Index Create and Rebuild
·
Loading Bulk Data into a Partitioned Table
·
Database Mirroring Best Practices and Performance Considerations
·
SQL Server 2005 Performance Tuning using Waits and Queues
·
Analysis Services 2005 Performance Guide
·
SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Performance, and Scalability
·
Microsoft SQL Server 2005 Tuning Tips for PeopleSoft 8.x
·
Troubleshooting Performance Problems in SQL Server 2005
·
SQL Server 2005 Best Practices Analyzer
·
DMV Stats
Scripts and Tools for Performance Tuning and Troubleshooting SQL Server 2005
·
Buffer Cache
·
CPU and Optimization
·
Indexes and Indexing
·
Input/Output
·
Performance
·
Query Plan Re-Use
·
Retrieving SQL Text and XML Plans
·
SQLOS: Schedulers, Runnable Queue, Waiter List
·
Tempdb
·
Transactions and Locking
·
Wait Statistics
SQL Server 2000 Best Practices
·
SQL Server 2000 SP3 Security Features and Best Practices: Security Best Practices Checklist
·
Microsoft SQL Server 2000 Index Defragmentation Best Practices
·
Best Practices Analyzer Tool for Microsoft SQL Server 2000
Close
Move
Email:
Name:
Message:
Send Copy?
Cancel
Send
Community Sharing Central
Submit
SQL Articles
Submit
SQL Scripts
Submit
SQL Tips
Submit
SQL Resources
Submit
SQL Events
Submit
SQL Bug
Submit
Your Resume
Submit
Your SQL Wish
Submit
Job Posting
Submit
Your FEEDBACK
Recently Submitted SQL Tips
Uninstall SQL Server
11/24/2008
Findind Occurrences of Text in the Database
8/22/2008
Finding An Occurrence of a Column
6/15/2008
List Indexes for all Tables in a Database
5/17/2008
UPDATE Based Off of A Table
4/24/2008
Recently Submitted Scripts
List Tables and the presence on Schema and FileGroup
12/24/2008
List the Indexes present in a database including all schemas
12/24/2008
ListAllTablesSizeinaDB
12/22/2008
Completed blocked spid report with what queries running
12/18/2008
ListallTableIndexes
10/1/2008
Account Login
Standard
LiveID
OpenID
User Name:
Password:
This site supports Windows LiveID login. If you have associated a Windows LiveID with your User Account, you can use your Windows LiveId to login, by clicking the "LogIn with LiveID" link below.