Videos

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

Refactoring T-SQL with Windowing Functions

SQL Server, T-SQL, Videos
6 Comments
You’ve been querying comparative numbers like Year To Date and Same Period Last Year by using tedious CTEs and subqueries. Beginning with SQL Server 2012, getting these numbers is easier than ever! Join Doug for a 30-minute T-SQL tune-up using window functions that will cut down dramatically on the amount of code you need to…
Read More

Watch Brent Tune Queries

SQL Server, Videos
17 Comments
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

Video: Documentation – It Doesn’t Suck!

SQL Server, Videos
1 Comment
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®?

SQL Server, Videos
0
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

Bob Dylan Explains TempDB (Video)

Humor, TempDB, Videos
8 Comments
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.
Read More

SQL Server Installation Best Practices Video

SQL Server, Videos
1 Comment
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…
Read More
Menu