30th September - 2nd October 2010

University of York

RSS
Login or Join
Skip Navigation Links
Skip Navigation Links
Home
SQLBits 7
Register
Agenda
Booking & Pricing
Training Day
Friday
Sessions
Speakers
FAQ
Travel & Accommodation
Sponsorship
Gold Sponsors
Exhibitors
News
Previous Events
SQLBits The 6th Sets (VI)
Sessions
Speakers
SQLBits goes West (V)
Sessions
Speakers
SQLBits goes Forth (IV)
Sessions
Speakers
SQLBits Cubed (III)
Sessions
Speakers
SQLBits II The SQL
Sessions
Speakers
SQLBits I
Sessions
Speakers
About
About SQLBits
Who's Who
Privacy
Contact
Community

Brought to you by the UK SQL Server Community.

Copyright © 2007-2010 SQLBits. All Rights Reserved.

Telerik

Orcsweb

Gold sponsors
    
Silver sponsors
    
Bronze sponsors
    
    

SQL Server’s storage engine

What does it mean that my index is fragmented? Why do I get a warning about index record sizes? How should I store images in SQL Server? Knowing how SQL Server stores data and what options there are to control this can help you to build more efficient applications. In this session we will look at how table and index data is stored on disk. We will look at the various data types available, from bits to filestreams, how indexes can be used to optimize read or write performance, and how row and page compression work.

Speaker focus

Dr András Belokosztolszki

András Belokosztolszki is a software architect at Red Gate Software Ltd. He is a frequent speaker at many UK user groups. He is primarily interested in database internals and change management. At Red Gate he has designed and led the development of many database tools that compare schemata and enable source control for databases (SQL Compare versions 4 to 8), refactor databases (SQL Refactor) and show the history of databases by analyzing the transaction log (SQL Log Rescue). András has a PhD from Cambridge and an MSc and BSc from ELTE, Hungary.

Dr András Belokosztolszki's blog http://www.simple-talk.com/community/blogs/andras/default.aspx


Downloads

File Type Ext ContentName
Presentation .pptx Slide Deck
<< 1 >> 

Other sessions from this conference

AddIns for SSMS - build your own
Comparing Azure storage and SQL Data Services
Data Mining and SSIS - makes sense.
Data Warehouse Data Modelling
Data Warehousing features in SQL 2008
Database Maintenance Optimization
Designing Effective Aggregations in Analysis Services 2008
Effective test-driven database development
End to End Report Creation and Management in SQL Server Reporting Services 2008
High Availability in SQL Server 2008
Implementing Clustering using SQL Server
Instrumenting, Monitoring and Auditing of SSIS ETL Solutions
Making the SQL developer one of the family with Visual Studio Team System
Message in a bottle: Service Broker from 1 to 100 in 75 minutes!
NHibernate – Open Source Object Relational Mapping (ORM)
Performance Optimization with SQL Server 2008
Performance Tuning your TSQL
Securing and Hardening a SQL Server Implementation - Notes from the Field
SQL Server Architecture: The life of a query
SSIS by example
SSIS Nuggets Live
Stop throwing hardware at the problem !
Understanding ADO.NET Data Services
Understanding Graphical Execution Plans
Universal calculated measures in MDX queries
Upgrading To SQL Server 2005 & 2008: Notes & Best Practices
What’s New in SQL Server 2008 T-SQL