Other News

Uncategorized

Tips for using indexes in SQL Server 2005 (Part 3)

Featured Article(s) Tips for using indexes in SQL Server 2005 (Part 3) Here are some helpful tips to performance tune and optimize SQL Server 2005 indexes. SQL Server Show – Watch Here SelectViews: SharePoint Feedback Results, Discussion Watch, Information Overload and Gaming – What It Could Mean For DBAs. Also – Newsletter Feedback, Upcoming SQL Server Events, Baselines and SQL […]

Community

The Myth of Human Readability in XML

(Bill Chessman) If you’ve seen my past posts, you know I’ve spent a lot of time on the discussion of EDI vs. XML. In part it’s been a quest to understand why trends seem to flow as they do. Back in December, in response to a post I wrote, Tom Reynolds said as part of his comment, “Let’s admit that […]

Community

Mapping Application to Dynamic SQL

(Radhesh Kumar) If you need to find out dynamic SQL statements in the database package cache, you can do so using Dynamic SQL Snapshot. If you need to check the details of your application, you can use Application snapshot. If you are accessing application snapshot through table function, you have t

Community

Recovery catalog for RMAN backup

(Famy Rasheed) It is always recommended to have the recovery catalog. If the target database controlfiles are lost recovery can become difficult if not impossible.Having recovery catalog makes the DBA life easier at the time of critical scenario. Even for larger system the use of a recovery catalog