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

November 2004 - Posts

Saturday, 27 November 2004 10:50 AM

Using ::fn_dblog() to identify which indexes are experiencing page splits

I picked up an interesting tip from Gert Drapers (MS) in the private MVP forum this week which was helpful to me so I'll post it here in case it's useful to anyone else. I was trying to identify which specific indexes are suffering excessive page splits
posted by Greg_Linwood | 1 Comments
Tuesday, 23 November 2004 8:34 AM

That's one big, nasty TPC result from IBM

IBM posted a whopping TPC-C record a few days ago, more than triple Oracle's previous single server record & nearly triple Oracle's previous clustered server record. They've achieved 3.2 million transactions per minute @ US$5.19 tpmC. The server
posted by Greg_Linwood | 0 Comments
Monday, 22 November 2004 11:33 AM

SQL 05 Database Mirroring is a cool technology

SQL Server's current 3 High Availability features - Clusering, Replication & Log Shipping are all good for different purposes but each has it's own draw-backs & none are good for all scenarios. Eg, clustering can be expensive to implement &
posted by Greg_Linwood | 0 Comments