Skip to content

SQL Nuggets

Nuggets Of SQL Server Knowledge

Menu
  • Home
  • Blog
  • Speaking
  • Presentations
  • Downloads
  • About

Tag: Index Basics

SQL Scripts: How To Find Missing Indexes

Posted on June 5, 2018 by Eric Cobb

One of the really cool things that SQL Server does is keep up with index statistics behind the scenes.  It knows how an index has been used, how often it …

SQL Scripts: How To Find Filtered Indexes

Posted on May 9, 2018 by Eric Cobb

Filtered indexes are one of those neat little SQL Server features that a lot of people don’t seem to know about, or if they do they don’t use them very …

Index Basics: Find Tables That Do Not Have A Clustered Index

Posted on October 17, 2017October 17, 2017 by Eric Cobb

In a previous Index Basics post we went over the importance of having a Clustered Index on your tables, and we learned that SQL Server will automatically create a Clustered …

Index Basics: Hidden Costs Associated With Indexes

Posted on September 26, 2017September 26, 2017 by Eric Cobb

I have a confession. When I was a developer, I didn’t understand indexes in SQL Server. I rarely added them to my tables, and when I did there was not …

Persist And Aggregate Index Stats Across Server Restarts

Posted on March 10, 2017April 27, 2018 by Eric Cobb

(This script is part of my SQL Server Metrics Pack project that is now available on GitHub.  If you like the code below and find it useful, I encourage you to check …

Using PowerShell To Store sp_BlitzIndex Results In A Table

Posted on November 22, 2016March 31, 2017 by Eric Cobb

I really like Brent Ozar’s sp_BlitzIndex procedure.  It offers a lot of great insight into the indexes in your databases.  If you are not currently using it, you should check it …

Finding Recurring Index Fragmentation Issues

Posted on November 8, 2016 by Eric Cobb

One of the nice things about Ola Hallengren’s maintenance solution is that it has the option to log its operations to a table.  This gives you ability to do a …

Index Basics: Nonclustered Indexes, Part 1

Posted on February 18, 2016 by Eric Cobb

In SQL Server, an index is used to speed the retrieval of data from a table. Indexes are built from one or more columns in the table, and SQL Server uses these Indexes …

Index Basics: Clustered Indexes

Posted on January 21, 2016October 17, 2017 by Eric Cobb

In SQL Server, an index is used to speed the retrieval of data from a table. Indexes are built from one or more columns in the table, and SQL Server uses these Indexes …

MSCE: Data Platform

Search

Subscribe via Email

Receive notifications of new posts by email.

SUBSCRIBE VIA RSS

RSS Feed RSS - Posts

Categories

  • Availability Groups
  • Azure
  • Backups
  • Career
  • Conferences
  • Corruption
  • DB Engine
  • Errors
  • Extended Events
  • Indexes
  • MongoDB
  • Monitoring
  • Open Source Projects
  • PowerShell
  • Security
  • SQL Scripts
  • SSIS
  • System Views
  • T-SQL
  • Tools

Recent Posts

  • SQL Server Permissions Manager Updates – January 2019
  • 2018 Speaking Review
  • Speaking At Adobe ColdFusion Summit East 2019
  • Using dbatools PowerShell Module To Set MAXDOP And Max Memory
  • Using dbatools PowerShell Module To Configure SQL Server

Top Posts

  • SQL Scripts: How To Find Missing Indexes
  • SQL Scripts: How To Check Logins And Permissions
  • SQL Scripts: How To Find Index Fragmentation
  • SQL Scripts: How To Change The Owner Of A Database
  • Encrypting Passwords Using EncryptByPassPhrase

Tags

Automation Azure Migration Backups Bad T-SQL Client Tools Clustered Indexes Database Mail Database Maintenance Data Files Data Storage dbatools DBCC CheckDB Encryption Execution Plans Express Edition Getting Started Index Basics Internals NOLOCK Nonclustered Indexes NoSQL Performance Permissions Presentations Quickies Server Administration Speaking SQL Agent SQL Index Insight SQL Metrics Pack SQL Permissions Manager SQL Saturday SQL Sentry SQL Server 2008 R2 SSMS Storing Passwords System Procedures Top Developer Tips Trace Flags Transaction Isolation Levels Visual Studio
Copyright © 2019 SQL Nuggets – OnePress theme by FameThemes
This website uses cookies to improve your experience. To find out more see our Privacy & Cookies Policy. Accept
Privacy & Cookies Policy