1. Home
  2. Videos
  3. (Page 9)

Doug Broke It: Minimal Logging [Video]

In this 5-minute video, Doug explains how he kept filling SQL Server’s transaction log during ETL development, and how minimal logging could have prevented a lot of the log writes. You’ll learn about: What minimal logging is How to turn minimal logging on How to tell if minimal logging is working Using minimal logging for…
Read More

Watch Brent Tune Queries

Ever wonder how someone else does it? There’s no right way or wrong way, but in this 20-minute session, you can peer over Brent’s shoulder (virtually) while he takes a few Stack Overflow queries, tries various techniques to make them faster, and shows how he measures the before-and-after results. For the links and scripts, check…
Read More

SQL Server Table Partitioning Tutorial: Videos and Scripts

There’s a secret to learning about SQL Server’s table partitioning feature: you need to get your hands on some code and really play with it in a test environment. In this tutorial, Kendra will walk you through test scripts that set up a sample table partitioning environment. These scripts demonstrate gotchas to look out for…
Read More

Video: Documentation – It Doesn’t Suck!

Without documentation, you could probably do your taxes, build a new piece of “some assembly required” furniture, or manage a database instance – but you’d probably end up living in prison, living with broken furniture, or living in fear of your servers. Writing documentation might not seem as important or exciting as developing or tuning…
Read More

Does Your SQL Server Need Critical Care®?

Overwhelmed with problems on your SQL Servers? Maybe it’s time you stopped playing around with bandages and got some Critical Care®.  In this 30-minute video, we’ll introduce our Critical Care® process, explain what we look for, and show you how to explain it to your manager. Let’s make your SQL Server faster and more reliable…
Read More

Introducing the SQL Server Plan Cache (and a Better 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…
Read More