If there is any performance issue within your queries then looking at query execution plan is the first step towards assessing the loss, you may be aware that execution plans of queries and queries on partitioned tables and indexes can be examined by using the TSQL SET statements such as SET SHOWPLAN_XML...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
03-04-2008
Filed under: sql server, performance, ssms, query, users, execution plan, monitoring, new features, .xml, plan cache, document, .sqlplan
In continuing from the series of Change-Data-Capture tags on this site I have been testing through this CDC feature on my test environment, which has proved fruitful results (to some extent). But the in the real world scenario do you really need to log all such activites? As you may be aware that logging...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
02-01-2008
Filed under: sql server, users, ctp, environment, cdc, best practice, testing, triggers, new features, audit trial, change data capture, stored procedures