Search Results for: Query Store

When was that object modified?

Posted on October 6, 2009 by | 1 comment

Yes, every once in a while when I am deploying an application I ask myself the following question.  What database objects (tables, stored procedures, functions etc..) did I modify with this release?   Ideally this is documented in the release plan but I … Continue reading →

1 Comment

Posted in Scripts, SQLServerPedia Syndication

Tagged ,

Get index fragmentation statistics

Posted on September 30, 2009 by | 3 comments

I recently attended a Pittsburgh SQL Server user group meeting where Brent Ozar gave a presentation on the silent performance killer.  This motivated me to create a stored procedure that could leverage the DMVs in SQL 2005/2008 to gather index … Continue reading →

3 Comments

Posted in Scripts, SQL Server, SQLServerPedia Syndication

Tagged ,

Building a Data Warehouse with SQL Server

Posted on September 29, 2009 by | 6 comments

Today, I am going to start a series of blogs on one of my favorite topics Data Warehousing with SQL Server.  I will start by defining a data warehouse.  I will then give some business cases that explain the benefits … Continue reading →

6 Comments

Posted in SQLServerPedia Syndication, Uncategorized

Tagged , , ,