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

December 2006 - Posts

Tuesday, 19 December 2006 11:55 PM

Why the Relational Model is Insufficient (part 1)

Paul Nielsen has pointed out a couple of interesting deficiencies in the relational model on his blog: http://sqlblog.com/blogs/paul_nielsen/archive/2006/12/18/430.aspx
posted by Greg_Linwood | 0 Comments
Filed Under:
Saturday, 16 December 2006 10:46 AM

List of KBs on SQL Server DB engine IO by Bob Dorr

Here's a useful list of IO KBs, put together by Microsoft PSS Escalation Engineer Bob Dorr http://blogs.msdn.com/psssql/archive/2006/11/27/what-do-i-need-to-know-about-sql-server-database-engine-i-o.aspx
posted by Greg_Linwood | 0 Comments
Filed Under:
Thursday, 14 December 2006 12:23 PM

I've been elf'd!

They're an interesting bunch over in Adelaide. I spoke at the SQL User Group over there today & was duely Elf'd by UG leader Rob Farley (thx Rob!) http://www.elfyourself.com/?userid=47dfff6ef46bcba36bd3033G06121318 I always have an interesting
posted by Greg_Linwood | 0 Comments
Filed Under:
Monday, 11 December 2006 11:20 PM

Using Reads, CPU, Duration or Writes for query tuning with SQL Trace

Whilst high level tools such as Windows Perfmon can give you an overview of server performance and Waitstats can provide you with an insight into where bottlenecks are occuring within the database engine, seeking out the source of most SQL Server performance
posted by Greg_Linwood | 2 Comments
Filed Under:
Tuesday, 5 December 2006 9:56 PM

Presenting in Sydney / Something to vote for

I presented a session on designing & managing high performance indexes at the Sydney SQL Server User Group tonight - had a great time & scored a nice bottle of Shiraz from McLaren Vale from local UG organiser Grant Paisley (thanks Grant!). We
posted by Greg_Linwood | 0 Comments
Friday, 1 December 2006 6:13 AM

More on TPC-C & Clustered Indexes

Prime & Oracle published another TPC-C benchmark this morning, achieving 1.2M transactions per minute @ $3.94 tpmC. This pushes HP & SQL Server's top result down to 4th & leaves SQL Server with only one result in the top 10 TPC-C benchmarks.
posted by Greg_Linwood | 0 Comments
Filed Under: