Here are the links for the past week. SQL Server: Jes Schultz Borland’s Improving the Performance of Backups suggests a few ways to improve the performance of backup operations. The comments also suggest further reading with additional great advice. Hugo Kornelis’s Parameterization and filtered indexes (part 1) and Parameterization and filtered indexes (part 2) address the issue...
Category: Cloud Computing
Post
My links of the week – December 8, 2013
Here is choice of links for this week. SQL Server: Phil Factor’s Primary Key Primer for SQL Server is an excellent primer on choosing primary keys for SQL Server databases. It also includes links to several related and relevant resources. Brent Ozar’s The Secrets of TempDB is a very interesting video on TempDB, one of SQL Server’s...