Report Definition Language XML Schema.xml (85.51 kb)

Step 1: Backup the current database transaction log

BACKUP LOG [@DBName] TO DISK='[Target physical path]' WITH FORMAT, NO_TRUNCATE

Step 2: Restore the database using a database backup file. (The create date of the backup file must ahead of the date when you want to recover to)

RESTORE DATABASE [@DBName] FROM DISK='[Complete database backup file physical path]' WITH NORECOVERY

Step 3: Restore to the log point

RESTORE LOG [@DBName] FROM DISK='[Log backup file physical path]' WITH RECOVERY , STOPAT='02/01/2009 00:00'

1. Linq to SQL的Select性能测试 (http://www.cnblogs.com/blusehuang/archive/2007/07/09/811075.html)

2. Linq to Sql Surprise Performance Hit (http://www.jdconley.com/blog/archive/2007/11/28/linq-to-sql-surprise-performance-hit.aspx)

3. 浅谈Linq To Sql集成数据库语言的优劣 (http://www.bccn.net/Article/sjk/sqlserver/jszl/200709/6578.html)

4. 使用DataLoadOptions 提高LINQ to SQL 查询性能 (http://tech.it168.com/d/2008-07-08/200807081206312.shtml)

5. Linq to SQL 应用场景 (http://msdn.microsoft.com/en-us/library/cc161164.aspx)