Platinum Sponsors
 

13th September 2008 Hatfield, Hertfordshire

Skip Navigation Links
RSS
Login or Join
Skip Navigation Links

Session Details - I/O! I/O! It’s off to disk we go...

You’ve issued your select query – the data isn’t in memory and so you’ve got to go to disk to get it. There are no dwarves to help you so the question is - How is this satisfied? What exactly is read-ahead? Does the edition you have installed affect how this is performed? Does partitioning alter anything? That’s just the half of it – there’s writes to talk about too. Understand the fundamentals of SQL Server I/O in this one hour practical session.
James Rowland-Jones
James is a Senior Technical Consultant at Conchango. His focus has been the development and technical direction of major, mission-critical, pan-European projects in the enterprise. His experience includes data and system architecture, information analysis, logical and physical database modelling and design, highly available implementations, ETL process architecture and client tools implementations including a number of major bespoke applications. He has worked in IT since 1998 and with SQL Server since 6.5.

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)
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)