Conference Time! The SSWUG Fall 2010 Virtual Conference is starting today. It’ll go on from today through Friday – if might be getting late but you can still attend the conference. It doesn’t matter if you are in the comforts of your living room, office, or couch. You can still sit back where ever you … Continue reading SSWUG Fall 2010 Virtual Conference Starts Today!
Conference Time! The SSWUG Fall 2010 Virtual Conference is coming up this week. 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 … Continue reading SSWUG Fall 2010 Virtual Conference This Week
Missing Numbers Today a developer came up to me and wanted help solving a problem he was running into with a list of numbers. He had a list of 53 numbers in a comma separated list. Unfortunately, the 53 numbers were not all in the table that he was querying. He wanted to know if … Continue reading Finding Missing Values from an Array
Time for part three 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 3
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
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
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
Strate SQL 