My Humble SQL Tips

Sliding Partition Window Concept Before we continue, let’s remind ourselves of what the Sliding Partition Window is and what it gets u...

Introduction Table partitioning, as it was introduced in SQL Server 2005 Enterprise Edition, is an incredibly useful feature. It enhances ...

I've mentioned a set of DMV queries that I use in a previous post on this blog . I've been chopping and changing the base set of que...

The stored procedure /********************************************************************************* UPDATE: Bug fixes and increased ...

I find that one (well, actually, one of many) really annoying things of restoring databases to different servers is the orphaned user! I am ...

Generate UPDATE STATISTICS scripts In the  previous post of this series I provided the script that both determines the indexes that need ...

I'm just about to begin a big performance improvement project. I'll be starting with an evaluation of indexes. This will involve  sy...

In Part 1 and Part 2 of this series I discussed synchronizing index maintenance and index usage statistics logging as an important part of...

In my last post , I introduced the concept of synchronizing index maintenance and index usage statistics logging as an important part of a D...

Introduction As part of my regular performance tuning and maintenance schedule I rely heavily on queries that interrogate the DMV  sys....