Search Results for “index fragmentation”

  1. Home
  2. Search Results
  3. (Page 5)
Tara Kizer

Spring Cleaning Your Databases

Index Maintenance, SQL Server
11 Comments
Even with lots of monitoring in place, we should perform periodic checks of our SQL Servers. Think of this like “Spring Cleaning”, except I would recommend that it be more frequently than just once a year. Doing it monthly might be a bit ambitious due to our busy schedules, but quarterly could be achievable. Below are…
Read More

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

SQL Server
13 Comments
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…
Read More

How to Configure Ola Hallengren’s Maintenance Scripts

If you’re a production database administrator responsible for backups, corruption checking, and index maintenance on SQL Server, try Ola Hallengren’s free database maintenance scripts. They’re better than yours (trust me), and they give you more flexibility than built-in maintenance plans. However, the index maintenance defaults aren’t good for everyone. Here’s how they ship: Transact-SQL CREATE PROCEDURE…
Read More

3 Things You Need to Start Doing to Your Database 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…
Read More
Pocket Square

Kendra Little’s Resume

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…
Read More
Pocket Square

Kendra Little’s Resume

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:…
Read More

We’re Presenting at the #SQLPASS Summit 2012!

#SQLPass
0
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…
Read More
Pocket Square

Auto-Shrink Enabled

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…
Read More
Sex Panther: 60% of the time, it works every time.

5 Things SQL Server Should Truncate

49 Comments
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…
Read More
NoSQL DBA

Switching to Cassandra

16 Comments
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…
Read More

Starting a Data Warehouse PASS Virtual Chapter

#SQLPass
4 Comments
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…
Read More
Menu