Project Phoenix Sometime people need a hand up – an opportunity to rise from the ashes. Over the last couple of years the economy and unemployment has taken its toll on many of those in the community. Along with that the charities that have often risen to help those in need have themselves suffered with … Continue reading Project Phoenix
Time for part two of my continued Index Analysis query. The previous posts in this series are: Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output Analyze Your Indexes Part 2 – Find existing duplicate and overlapping indexes Analyze Your Indexes Part 3 – Find the relationship … Continue reading Return of Index Analysis Part 2
With 5-weeks until the PASS Summit it’s time to start getting ready for the event. As I’ve discussed a couple times before (1, 2) the upcoming PASS Summit. Over the next few weeks I plan to write about some of the things to make sure you do to make sure you get the most out … Continue reading 5-Weeks to PASS Summit 2010 Countdown
Conference Time! The SSWUG Fall 2010 Virtual Conference is coming up. On October 20-22, you can attend a conference from the comforts of your living room, office, or couch. And while you are at it you’ll get to sit in on some incredible presentations, interaction with speakers, and chat with other attendees. All of this … Continue reading SSWUG Fall 2010 Virtual Conference This Month
Time for part two of my continued Index Analysis query. The previous posts in this series are: Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output Analyze Your Indexes Part 2 – Find existing duplicate and overlapping indexes Analyze Your Indexes Part 3 – Find the relationship … Continue reading Return of Index Analysis Part 1
Now that I've finished going through some of the details for sys.dm_db_index_operational_stats, it’s time to take that information and incorporate it into a query that I wrote about a while back. This query is an index analysis query that I often use when I go out to clients. The query provides a information about the … Continue reading Return of Index Analysis
In my TSQL2sDay index summary post, that I’d be writing a few posts on the information that is contained in sys.dm_db_index_operational_stats. The posts are the following: Index Black Ops Part 1 – Locking and Blocking Index Black Ops Part 2 – Page IO Latch, Page Latch Index Black Ops Part 3 – Index Usage Index … Continue reading Index Black Ops Part 6 – Fill Factor vs. Page Splits
I need an empty Raw file for my SQL Server Integration Services (SSIS) package. Over the last summer I’ve discovered how incredibly useful these are and will hopefully have some blogs coming out soon that go through some of this. But for now – please trust me and help the SQL community fight the good … Continue reading Create Empty Raw File
In my TSQL2sDay index summary post, that I’d be writing a few posts on the information that is contained in sys.dm_db_index_operational_stats. The posts are the following: Index Black Ops Part 1 – Locking and Blocking Index Black Ops Part 2 – Page IO Latch, Page Latch Index Black Ops Part 3 – Index Usage Index … Continue reading Index Black Ops Part 5 – Page Splits
Some of my clients and I have been waiting on this for a little while – SQL Server 2008 Service Pack 2 has been released. It includes resolutions for 21 issues and the inclusion of fixes for 61 issues previously resolved. Along with the resolution of those issues, Service Pack 2 includes a few new … Continue reading SQL Server 2008 Service Pack 2 Released
Strate SQL 