Platinum Sponsors
 

13th September 2008 Hatfield, Hertfordshire

Session Details - SQL Server 2005 Online index operations for DML concurrency – guidelines & best practices

SQL Server 2005 Enterprise Edition, the online index feature provides a powerful way to perform maintenance operations such as rebuilding or creating indexes in a production system without sacrificing DML concurrency. This presentation involves my experience with a demo & discussion of the index process and provides guidelines and best practices for implementing this feature in a production environment.

Satya Shyam K Jayanty
Knowledge is the power and you will gain by sharing it; I'm an Independent Database expert, with over 16 years of experience in application designing, developing and managing database technologies using industry famous technologies & software. I have been working with SQL Server since version 4.2 (1996) and active member & moderator in Technet, MSDN, SQL-Server-Performance.com forums/websites and also writing for http://www.sql-server-performance.com website. I'm a regular speaker and volunteer (Ask The Experts) at SQL Server events such as SQLPASS, Tech-ed etc. and I was awarded as SQL Server MVP since the year 2006. I also update content & manage the website http://www.sqlserver-qa.net.

Other sessions from this conference

"SELECT TOP(@x) Name FROM MyFavouriteDMVs ORDER BY MyRanking" (Downloads) (Video)
2005 SQLCMD Scripting (Downloads) (Video)
Administering SQL Server 2008 and 2005 with Windows PowerShell (Downloads) (Video)
Development Life Cycle using Visual Studio Team Edition for DB Professionals (Downloads) (Video)
Extending SSIS with custom Data Flow components (Downloads) (Video)
Getting to grips with Service Broker. (Downloads) (Video)
I/O! I/O! It’s off to disk we go... (Downloads) (Video)
Introduction to SQL 2008 Performance Data Collector (Downloads) (Video)
Making more of SSIS in 2008 (Downloads) (Video)
Making the leap into Advanced SQL (Downloads) (Video)
Master Data Management (MDM) (Downloads) (Video)
New Product Demos (Downloads) (Video)
Recruitment Open Panel (Downloads) (Video)
Reporting in SQL Server 2008 (Downloads) (Video)
SQL Server 2008 – Declarative Management Framework concepts & database problem solutions with policy management. (Downloads) (Video)
SQL Server 2008 TSQL Enhancements (Downloads) (Video)
SQL Server High Availability and Disaster Recovery Overview (Downloads) (Video)
Transient data in SQL Server (Downloads) (Video)
Understanding LINQ in .NET Framework V3.5 and Beyond (Downloads) (Video)
Using Analysis Services as a data source for Reporting Services reports (Downloads) (Video)
What Are You Waiting For? (Downloads) (Video)
Where do you live? Intro to spatial indexing (Downloads) (Video)