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
Category: SQL 2008
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
Sub-Folder Grouping for Folders
When managing large SQL Server instances; the number of databases on a server sometimes start creating a headache to manage. If we can group the
Default Schema in SQL 2005/SQL 2008
When you create a new AD group login in SQL Server and then create the Database user based of that login it is not possible
Activity Monitor in SQL 2008 …
It disappeared … So it seems; it no longer shows up under Management -> Activity Monitor. Even on-line books state it is there. I still
Error 18456, Severity 14: Login Failed States
The document referenced below explains all the states, this is just a summary. State Description 1 Only state returned in SQL 2000. Seems to be
SQL Canada (SQLCAN) 