April 2007 - Posts

Database mail issues with maintenance plans & scheduled jobs

Published 30 April 7 9:40 AM | SqlServer-QA.net (SSQA)

Database Mail Fails For SQL Server Agent Jobs / Maintenace plans - Why ? As you are aware Database Maintenance plans are better in SQL 2005 and more better now after Service Pack 2 release with a cumulative hotfix release. Still there are few problems...

Filed under: sql server, ssms, maintenance plan, solution, database, mail

How to find that a query could benefit from an index?

Published 30 April 7 5:48 AM | SqlServer-QA.net (SSQA)

Performance is most required achievement in a multi-user environment, using SQL Server 2005 this can be achieved with a few statments execution. Firstly you need determine the issues by finding which query or queries are causing issues in achieving performance...

Filed under: sql server, performance, management, security, ssms, dmv