Over the past month or two I been saving any link I find interesting for SQL Server sometimes other topics. To build a library and
Default Backup Path in SQL 2008
In the SQL Server 2008 setup you can now set the default backup location but in case you set it wrong or need to change
Execution Related Dynamic Management Views and Functions Differences
sys.dm_exec_query_stats SQL 2008: Added two new fields the the DMV (query_hash and query_plan_hash); designed to help performance tune queries with similar logic, you can read
DMV/DMF
I have used many different queries of DMV/DMF over the past years to get various information for SQL Server OS. So I am going to
Install SQL Server 2008
Microsoft has made the SQL Server 2008 install more function rich then the previous version. They have included functionality into this install which make it
Mirroring FAQ
I plan to update this as I run across questions; I really like mirroring. Comparing to Clustering it is cheaper to setup also. I like
SQL Canada (SQLCAN) 