16th April 2010

Church House Conference Centre, London

Platinum Sponsors
Microsoft
Gold sponsors
Silver sponsors
Bronze sponsors

Transient data in SQL Server

This session is focused on transient data in SQL Server. We will look at questions like: What is stored in tempdb? Is tempdb a performance bottleneck? What are the differences between temporary tables and table variables? What is stored in the transaction log file and how can its size be kept under control?

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

No items to download

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.
I/O! I/O! It’s off to disk we go...
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
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