01 2011 档案

摘要：AceBackupis a powerful tool to create completely secure backups of your data. Store your data on any local storage device, on CD, DVD or on your remote FTP server!A special advantage of AceBackup is the possibility to backup single files and groups of files, for example for important or confidential 阅读全文

摘要：In my case, the database files are located in the following directory:C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATAAs you may already know, you cannot backup the *.MDF and *.LDF database files directly because they are attached to the SQL Server. You could detach them, back the 阅读全文

摘要：记得用MySQl的时候，就有一个语法Explain sql。 这样可以解析出sql执行的过程，并且给出如何使用索引。SQL server当然也有这样的功能，而且更加强大。When it comes time to analyze the performance of a specific query, one of the best methods is to view the query execution plan. A query execution plan outlines how the SQL Server query optimizer actually ran (or wil 阅读全文