Time for another episode of the SQL Friday, The Best SQL Server Links Of The Past Week show.
Here is what I found interesting this past week in SQL Land:
Lara Rubbelke points us to some good SQL Server 2008 Auditing Resources
Bob Beauchemin is letting us know that with SQL Server 2008 Service pack 1 Spatial Indexes require almost no hints at all
Alexander Kuznetsov summarizes his previous posts about defensive database programming and also gives you all the links to the previous posts
The PSS SQL Server Engineers show you how you can use computed columns to improve query performance
Tibor Karaszi explains what Instant File Initialization is and why it matters
Arnie Rowland suggests that there is a need for a completely ‘Isolated Transaction’. That is, a transaction that can be started in the midst of a ‘regular’ transaction (parent), and that will be durable regardless of the outcome of the parent transaction. Using this ‘Isolated Transaction’, once a commit occurs, even a rollback of the parent transaction will not undo the saved work. The activity log is properly persisted and durable.
Louis Davidson shows us a cool way to grant rights to all objects in a database
That is it for this week, I will tag the weekly posts with SQL Friday in case you want to see the whole archive in the future