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:
SQL Server 2008 Auditing Resources
Lara Rubbelke points us to some good SQL Server 2008 Auditing Resources
Spatial Indexes in SP1, almost no hints required
Bob Beauchemin is letting us know that with SQL Server 2008 Service pack 1 Spatial Indexes require almost no hints at all
Summarizing previous posts about defensive database programming
Alexander Kuznetsov summarizes his previous posts about defensive database programming and also gives you all the links to the previous posts
How to use computed columns to improve query performance
The PSS SQL Server Engineers show you how you can use computed columns to improve query performance
Do you have Instant File Initialization?
Tibor Karaszi explains what Instant File Initialization is and why it matters
Is it time for SQL Server to have Isolated Transactions?
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.
Granting rights to all objects in a database
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
*** If you have a SQL related question try our Microsoft SQL Server Programming forum or our Microsoft SQL Server Admin forum
Denis has been working with SQL Server since version 6.5. Although he worked as an ASP/JSP/ColdFusion developer before the dot com bust, he has been working exclusively as a database developer/architect since 2002. In addition to English, Denis is also fluent in Croatian and Dutch, but he can curse in many other languages and dialects (just ask the SQL optimizer) He lives in Princeton, NJ with his wife and three kids.
