Welcome to Aussie SQL Server Bloggers Sign in | Join | Help

September 2006 - Posts

Thursday, 28 September 2006 9:39 PM

Blown away...

By this amazing child.. http://www.metacafe.com/watch/170944/amazing_11_year_old/ WHAT a talent!
posted by Greg_Linwood | 0 Comments
Monday, 25 September 2006 10:54 PM

Debunking myths about clustered indexes - part 4 (CIXs, TPC-C & Oracle clusters)

This is the fourth blog post in a series I am currently writing in an attempt to de-bunk the myth that "clustered indexes (CIXs) should be created on every table". I'm going to take a moment here to clarify that I'm NOT saying CIXs
posted by Greg_Linwood | 7 Comments
Filed Under:
Saturday, 23 September 2006 7:05 PM

The next version of SQL Server should be a blast!

Whilst reading Simon Winchester's "Krakatoa: The Day the World Exploded" (an interesting account of the biggest volcanic explosion in recorded history) this week, I learned that Katmai was one of only four or five volcanic explosions which scientists
posted by Greg_Linwood | 0 Comments
Wednesday, 20 September 2006 12:01 AM

A good article on trouble-shooting deadlocks

Mitch Wheat pointed out a good article on his blog recently on how to troubleshoot deadlocks, written by Microsoft PSS escalation engineer Bart Duncan. This article is definitely worth a read, but two observations I'd make about this article are:
posted by Greg_Linwood | 1 Comments
Filed Under:
Sunday, 17 September 2006 1:09 PM

An idea for indexing phone numbers (index reversed phone numbers)

A recent thread in microsoft.public.sqlserver.programming (http://tinyurl.com/pzuq4) prompted me to think about how to index phone numbers for efficient query performance. One problem with storing & indexing phone numbers in database systems
posted by Greg_Linwood | 2 Comments
Saturday, 16 September 2006 11:50 AM

Debunking myths about clustered indexes - part 3 (example script)

So far in this series of posts, I have discussed how clustered indexes (CIXs) can be less efficient for both bookmark lookups & range scans than non-clustered indexes (NCIXs). In this post, I'm providing a repro script that demonstrates these two
posted by Greg_Linwood | 2 Comments
Filed Under:
Thursday, 14 September 2006 12:41 AM

Over-skinny models banned from fashion shows..

What a great idea! I'd still have my sister if it weren't for these dreadful eating dis-orders. Congrats to the organisers of the Madrid fashion week for having the balls to make a controversial but important decision. http://www.cnn.com/2006/WORLD/europe/09/13/spain.models/index.html
posted by Greg_Linwood | 0 Comments
Filed Under:
Monday, 11 September 2006 8:34 PM

Debunking myths about clustered indexes - part 2 (CIXs are NOT better for range scans)

In my previous post on this topic, I discussed the ineffiency associated with performing bookmark lookups between Non-Clustered Indexes (NCIXs) and Clustered Indexes (CIXs), as opposed to when those same lookups are made from NCIXs to HEAP storage. Although
posted by Greg_Linwood | 2 Comments
Filed Under:
Monday, 11 September 2006 12:43 AM

In a New York state of mind...

Hard to believe 5 years have flown by. Still makes me angry remembering those poor people desperately jumping off the towers..
posted by Greg_Linwood | 0 Comments
Sunday, 10 September 2006 12:25 AM

Debunking myths about clustered indexes - part 1 (CIXs worsen bookmark lookups)

One of the most widely published indexing "best practises" is that you should create a clustered index (CIX) on every table in your database. For many years, I accepted this as one of the "golden indexing rules" but over the past few years I have
posted by Greg_Linwood | 3 Comments
Filed Under:
Thursday, 7 September 2006 10:34 PM

List of breaking changes in SQL 2005

Here's a handy list I just discovered today that shows the features supported in SQL 2000 which have been broken in SQL 2005. Handy for anyone doing upgrade projects.. http://msdn2.microsoft.com/en-us/library/ms143532.aspx
posted by Greg_Linwood | 0 Comments
Filed Under:
Wednesday, 6 September 2006 12:21 PM

Darn! Perth User Group presentations this week postponed.. )c:

Unfortunately, I am unable to deliver two planned User Group presentations in Perth this week due to an emergency customer issue at work that began last night & has still not been resolved today. I would like to apologise to everyone who had planned
posted by Greg_Linwood | 0 Comments
Tuesday, 5 September 2006 9:39 AM

Happy 60th Freddie

Freddie, you would've been 60 today & the whole world still misses you. Happy birthday to a champion who didn't want to live forever.. http://brianmay.com/brian/brianssb/brianssbsep06a.html#02
posted by Greg_Linwood | 0 Comments
Filed Under: