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 an Advisory Consultant at EMC Consulting. 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.

James Rowland-Jones's blog http://blogs.conchango.com/jamesrowlandjones

---

Downloads

File Type Ext ContentName Zip File .zip Slide Deck

<< 1 >>

---

Other sessions from this conference

"SELECT TOP(@x) Name FROM MyFavouriteDMVs ORDER BY MyRanking"

2005 SQLCMD Scripting

Administering SQL Server 2008 and 2005 with Windows PowerShell

Development Life Cycle using Visual Studio Team Edition for DB Professionals

Extending SSIS with custom Data Flow components

Getting to grips with Service Broker.

Introduction to SQL 2008 Performance Data Collector

Making more of SSIS in 2008

Making the leap into Advanced SQL

Master Data Management (MDM)

New Product Demos

Recruitment Open Panel

Reporting in SQL Server 2008

SQL Server 2008 – Declarative Management Framework concepts & database problem solutions with policy management.

SQL Server 2008 TSQL Enhancements

SQL Server High Availability and Disaster Recovery Overview

Transient data in SQL Server

Understanding LINQ in .NET Framework V3.5 and Beyond

Using Analysis Services as a data source for Reporting Services reports

What Are You Waiting For?

Where do you live? Intro to spatial indexing