Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL 2005   (RSS)

Using SQL 2005 Snapshots As A Rollback Procedure

One of the great new features of SQL 2005 is database snapshots. With one simple transact SQL statement, you can provide your users with a read-only, static copy of their data. For example, you can take a snapshot on the last day of the month and users
Posted by MSCOM | 3 Comments
Filed under: ,

Doctor Strangedata, Or How I Learned to Love the Common Table Expression

SQL Server 2005 offers a plethora of innovative technologies designed to let everyone access data in a way that would make the information more useful to each individual. The purpose, of course, is to ensure that the developer can use the information
 
Page view tracker