Search Results for “index fragmentation”

  1. Home
  2. Search Results
  3. (Page 2)
Pocket Square

Self Loathing Indexes

Diagnosis: Self-Loathing Index Disorder. Your indexes may seem like they’re not quite living up to their potential– because they probably aren’t. Our data says that your indexes may need your help to fully respect themselves again. Low Fill Factor We looks for any index where the fill factor is 80% or less. Fill factor is…
Read More
Pocket Square

sp_BlitzIndex®

sp_BlitzIndex® – SQL Server’s Index Sanity Test Your SQL Server indexes may be less sane than you think. Download sp_BlitzIndex® to find out– or scroll on down and watch a video to see how it help you find out: Do you have duplicate indexes wasting your storage and memory? Would you like help to find unused…
Read More

Indexing for Deletes

Indexing, SQL Server
21 Comments
If you’re only indexing to make reads faster, you need to think again. Indexes can make every operation in the database faster, even deletes. The Problem: Deletes are Very Slow I was lazily researching new development techniques one day when I received an email from a client asking why deletes could be slow. I rattled…
Read More
It's a trick question.

DBA Training Plan 14: POP QUIZ!

DBA Training Plan
10 Comments
AH-HA! You didn’t know there would be one of these, did you, hotshot? You’ve been reading along in the series, just smiling and nodding, pretending you’re keeping up, but not really doing the homework. BUSTED! Put your books away and get your pencils out. Backup & Recovery Questions: How many production SQL Servers do you…
Read More

[Video] Office Hours 2017/08/23 (With Transcriptions)

SQL Server, Videos
0
This week, Brent, Erik, Tara, and Richie discuss index fragmentation, Azure disk speeds, Availability Groups, database restores, optimize for ad hoc setting, forced parameterization, BI consultants, index views, SPN registrations, and more. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. Enjoy…
Read More

[Video] Office Hours 2016/09/07 (With Transcriptions)

This week, Brent, Richie, Erik, and Tara discuss parameter sniffing, database backups, referential integrity in databases, clustering, creating and using indexes, in-place upgrades, bench marking tools, and more. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. Enjoy the Podcast? Don’t miss…
Read More

[Video] Office Hours 2016 2016/05/25 (With Transcriptions)

This week, Angie, Erik, Tara, and Richie discuss Veeam, replication, setting up alerts, using multiple instances, and much more. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. Office Hours Webcast – 2016-05-25 Does turning on trace flag 2861 cancel out optimize for…
Read More

[Video] Office Hours 2016 2016/05/18 (With Transcriptions)

This week, Brent, Angie, Erik, Jessica, and Richie discuss sp_Blitz® updates, merge replication, detecting index fragmentation, how to punish your DBAs, and Brent’s new chroma key backdrop. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. Jessica Connors: Let’s talk about some merge…
Read More
Menu