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
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
Earlier this week, PASS opened up the Schedule Builder for the those that are registered for the PASS Summit. You can also take a look at the full schedule with the At A Glance schedule. This is your opportunity to find out what sessions are going to be when during the summit. And for those … Continue reading PASS Summit Schedule
Are you ready for Seattle? Have you registered for the PASS Summit? Hopefully with some good reasons you will be inspired to attend the summit this year. Ten Reasons to Attend There are, of course, countless reasons to attend the PASS Summit in November. To hopefully inspire a few of you holdouts, I am count … Continue reading To Be There Or Not To Be There
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 will be 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 … Continue reading Index Black Ops Part 4 – Index Overhead and Maintenance
Strate SQL 