XML FeedsHere we are with another fascinating episode of the SQL Friday, The Best SQL Server Links Of The Past Week show
Obviously this week is another slow week, here is what I found interesting this past week in SQL Land:
Using SQLIOSim to Diagnose SQL Server Reported Checksum (Error 824/823) Failures
Another good post by the PSS SQL Server Engineers
Enabling compression on a HEAP
Sunil Agarwal explains how to enable compression on a table that is a heap (i.e. it does not have a clustered index)
DML operations on a HEAP and compression
This is a follow-up to the previous article and describes the implications of DML operations on a heap
Managing TempDB in SQL Server and part 2 of this series
TempDB basics are explained, this is a must read!!
Indexing for Partitioned Tables
Michelle Ufford has a post showing if you should partition your index
LINQ to SQL: Does it have much of a future?
Greg Low has a nice article about the future of LINQ to SQL. Will LINQ to SQL die and be replaced by the Entity Framework?
What should I do when my Windows Admin wants to put an anti-virus on the SQL Servers?
Denny Cherry explains how to configure anti virus software if someone wants to put it on your precious SQL box
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.
LTD Social Sitings
Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.