Recently executed SQL Statements
SELECT last_execution_time , [text] AS [Statement] FROM sys . dm_exec_query_stats CROSS APPLY sys . dm_exec_sql_text ( sql_handle ) ORDER BY last_execution_time …
Showing posts from June, 2009
Failover Clustering
Failover Clustering High availability option, standby instance on a different node In case of failover: active transactions are rolled back, connections retry, reconnect to other node Single copy of …
SQL Server 2008 Database Mirroring
Database Mirroring Software solution for high availability. Per database and not per server. Increase data protection, availability, upgrade availability. Careful – A lot of things live outside the d…