Search Results for “index fragmentation”

What’s Covered in the Senior DBA Class of 2016?

Last Updated April 9, 2017

You’re a SQL Server DBA who is ready to advance to the next level in your career but aren’t sure how to fully master your environment and drive the right architectural changes. That’s about to change in one week of learning and adventure with me, Brent Ozar. Join me to learn how size, architect, maintain, and troubleshoot…

Performance Tuning SQL Server Transactional Replication: A Checklist

Last Updated September 14, 2018

Kendra Little

Replication

Swim faster! SQL Server transactional replication is a blessing and a curse. It’s a great developer tool that lets you scale out data to multiple servers, even using Standard Edition. But as your business picks up, your datasets get larger, and your customers grow more demanding, replication can start to fall behind. You need to…

3 Things You Need to Start Doing to Your Database Server

Last Updated February 13, 2017

Jes Schultz

CHECKDB and Corruption, SQL Server

Taking care of your health is incredibly important (says the marathon runner). Eating right, exercising, and getting plenty of rest help you stay healthy and perform optimally. Does “an apple a day keep the doctor away” apply to cupcake apples? Your database server’s health is important to your company’s health. You need to take regular…

3 Things You Need to Stop Doing to Your Database Server

Last Updated April 9, 2013

Jes Schultz

SQL Server

No one knows everything, especially about SQL Server. When you encounter a problem, especially for the first time, you may not know how to solve it. I’ve seen some crazy approaches taken to fix problems – like duct tape on a car. Many times, instead of fixing the root cause of a problem, such as…

Kendra Little’s Resume

Last Updated October 11, 2012

Kendra Little’s Resume Microsoft Certified Master, SQL Server 2008 Speaker and Trainer Creator of Magical Posters Microsoft MVP Three Recent Projects Server Hardware Transplant: I designed a migration plan to move an OLTP database requiring four nines of uptime to new hardware. The plan included testing, validation, monitoring, and rollback steps. My client executed the…

Kendra Little’s Resume

Last Updated October 19, 2012

Kendra Little

I’m a Microsoft Certified Master in SQL Server 2008. Microsoft Certified Master, SQL Server 2008 Speaker, Trainer, Creator of Magical Posters Microsoft MVP Three Awesome Things I Did This Year One of our readers commented that a consultant’s best resume is stories about their work which makes them proud. Here’s my current top three achievements:…

Five Things That Fix Bad SQL Server Performance

Last Updated April 2, 2017

Jeremiah Peschka

SQL Server

Is your SQL Server slowing you down? Are bad queries giving your application a case of the blues? Before you go looking for help with SQL Server, make sure that you’ve done everything you can to solve the problems on your own. Many of SQL Server’s ills can be solved with some easy preventative maintenance,…

We’re Presenting at the #SQLPASS Summit 2012!

Last Updated February 9, 2017

Brent Ozar Unlimited Team

#SQLPass

All four of us – Brent, Jeremiah, Jes, and Kendra – got sessions approved for the PASS Summit in November! Here’s what we’ll be covering: Shazam! We’re speaking at the PASS Summit! A Developer’s Guide to Dangerous Queries – Jeremiah Peschka Jeremiah says: “SQL Server does a good job of working with whatever garbage we…

How To Decide if You Should Use Table Partitioning

Last Updated July 12, 2023

Kendra Little

Partitioning, SQL Server

159

Great volumes have been written about table partitioning. It’s a complex feature and you can read for days to just understand how you might apply it. But will it improve performance for you? Table partitioning produces great benefits for some applications, but causes giant headaches for others. How do you know if you should invest your…

Auto-Shrink Enabled

Last Updated July 27, 2020

Brent Ozar

Auto-Shrink Enabled or Job has Shrink Steps Running out of disk space sucks. SQL Server can help: it can automatically shrink databases to remove unused space. However, this option has way more drawbacks than positives. We check sys.databases to see if is_auto_shrink_on = 1 for any of the databases. We can also create our own Agent…

Sex Panther: 60% of the time, it works every time.

5 Things SQL Server Should Truncate

Last Updated May 12, 2010

Brent Ozar

Paul Randal (Blog – @PaulRandal) nailed a blog post to the church wall entitled, “What 5 things should SQL Server get rid of?” His choices included auto-shrink, putting databases in full recovery by default, GUIDs as clustered indexes, and more. He tagged me, and I knew right away what I’d say. 5. IntelliSense restrictions on…

Switching to Cassandra

Last Updated June 15, 2010

Brent Ozar

NoSQL is a good idea with a bad name. You wouldn’t put on your NoJeans to drive to work in your NoFord. But put away the crappy label for a minute and check out what the NoSQL movement has going for it, because they’ve got some good points. In the Microsoft Certified Master training, I’ve…

Starting a Data Warehouse PASS Virtual Chapter

Last Updated February 12, 2017

Brent Ozar

#SQLPass

The Professional Association for SQL Server (PASS) has several sub-groups for specialized groups of people: Application Developers – people who code applications that store data in SQL Server. Auditing and Compliance – people who need to secure their SQL Servers and be compliant with regulations. Business Intelligence – people who write reports, design cubes, and…

SQL Server 2005 Setup Checklist Part 2: After The Install

Last Updated June 27, 2017

Brent Ozar

SQL Server

I’ve covered what needs to happen before you install SQL Server – now, let’s talk about what to do immediately after the setup finishes. Install not just the service packs, but also the cumulative updates. Starting with SQL Server 2005’s Service Pack 2, Microsoft releases hotfixes in cumulative packs. These updates do more than just…

Search Results for “index fragmentation”

Hi! I’m Brent Ozar.