Videos

Home
Videos

Bob Dylan Explains TempDB (Video)

December 5, 2012

How many files must a TempDB have before it’s allowed to be fast? How many table variables must a server walk down before it’s considered a table? The answer, my friend, is blowin’ in the wind, and Bob Dylan will share it with you in this 25-minute video – hopefully you can understand him.

Introducing the SQL Server Plan Cache (and a Better sp_Blitz®)

November 19, 2012

Brent Ozar

Execution Plans, SQL Server, Videos

performance tuning, plan cache, procedure cache, sp_blitz

When you send your beautifully hand-crafted organic T-SQL statement to SQL Server, the database engine takes a moment to appreciate the poetry of your work. Before it turns your request into results, it has to build an execution plan. SQL Server considers: Which tables it needs to join together What subqueries it needs to execute…

SQL Server Installation Best Practices Video

October 17, 2012

Brent Ozar

SQL Server, Videos

installation, setup

Wait! You only get one chance to do this right. Before you run setup.exe, there are some basic configuration steps that will make all the difference in performance and troubleshooting. Brent Ozar will explain his SQL Server Setup Checklist covering the page file, service accounts, memory settings, and hardware stress testing. We won’t cover scripted…