• Home
  • Contact

John Sansom

SQL Server DBA Blog

  • About
    • The Blog
    • John Sansom
    • Contact
  • Ebook
  • Archives
    • Start Here
    • Popular Posts
    • All Posts
    • SFTW
  • Becoming a DBA
    • What it’s Really Like
    • Interview Tips
    • Certification
    • FAQ
  • Books
  • Resources
    • Blog Tools and Technology
    • UK Events Schedule
    • References & Resource Lists
  • Subscribe

How does the sys.dm_db_index_physical_stats DMV work?

September 13, 2010 by John Sansom Leave a Comment

Every so often whilst going about my DBA business I encounter a Blog post that is just too good not to share. There are stacks of excellent resources available on the interweb and those that I wish to keep for future reference I add to the SQL Server Resources area of this site. On this […]

Filed Under: Administration, Index Optimisation

The Definitive Introduction to SQL Server Indexes

June 29, 2009 by John Sansom Leave a Comment

It normally is not my style to write a blog post solely about a particular article someone else has published. Typically I just go ahead and add quality resources to the SQL Server Resources area of this site that I have either found myself or had recommended to me. In this case however an exception […]

Filed Under: Administration, Index Optimisation, Performance Tuning Tagged With: Indexes

SQL Server Index Defrag Script: Update

June 25, 2009 by John Sansom Leave a Comment

Michelle Ufford (aka SQLFool) has released an update to her excellent index optimisation script. If you are not already using something similar to simplify your index optimisation database maintenance processes then you will find this to be extremely useful. Check it out here: Index Defrag Script, V3.0 Michelle Ufford (aka SQLFool) has released an update […]

Filed Under: Administration, Index Optimisation, Performance Tuning

Automate SQL Server Index Defragmentation,Optimisation

March 20, 2009 by John Sansom Leave a Comment

This week I came across what could quite possibly be, the best SQL Server index defrag script I have seen. This little beauty is fully customisable and is freely available courtesy of Michelle Ufford (aka SQL Fool) on her blog SQLFool.com As you know, it is just not practical to use a SQL Server Maintenance […]

Filed Under: Administration, Disaster Recovery, Index Optimisation, Performance Tuning, Tools

Performance Comparison of (SELECT TOP 1) Verses MAX()

February 26, 2009 by John Sansom 19 Comments

I recently came across a post on Stackoverflow regarding the performance of using a SELECT TOP 1 query in comparison to using the MAX() function. My initial thoughts on this were that the MAX() function would provide the best performance however, in order to be absolutely certain and prove my initial hypothesis I decided to […]

Filed Under: Administration, Index Optimisation, Performance Tuning, Tools Tagged With: MAX()

Finding Bad Indexes Using SQL Server DMVs

February 24, 2009 by John Sansom 1 Comment

Today I want to show you how to go about finding bad indexes. SQL Server indexes are often promoted as the answer to all of our performance optimisation needs. It may then surprise you to hear that indexes can also be bad for performance. “What are you yapping on about John” I hear you shout. […]

Filed Under: Index Optimisation Tagged With: Bad Indexes, DMV Queries

Popular Articles

  • Top 10 Free SQL Server Tools
  • Performing fast SQL Server delete operations
  • How to identify the most costly SQL Server queries using DMV’s
  • Top 10 Junior DBA Interview Tips
  • The Database Administrator’s Primary Responsibility
  • Your Road to Becoming a DBA: Laying a Strong Foundation
  • Top 5 SQL Forums
  • SQL Server Memory Configuration, Determining MemToLeave Settings
  • Script SQL Server Agent Jobs Using PowerShell
  • Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues

Categories

  • Administration (38)
  • Blogging (8)
  • Customer Service (5)
  • Disaster Recovery (5)
  • DMVs (4)
  • Index Optimisation (6)
  • Interviews (1)
  • Link Posts (243)
  • Memory (2)
  • Performance Tuning (15)
  • Professional Development (70)
  • Reporting Services (5)
  • Reviews (1)
  • SQL Server Community (144)
  • SQL Server Tips (11)
  • SQLServerCentral Syndication (112)
  • SQLServerPedia Syndication (116)
  • Tools (7)

Copyright © 2023 · Santech Solutions Limited · Powered by the Genesis Framework · Privacy Policy