Browse by Tags

• best practice
• certificate
• dashboard
• hotfix
• http
• indexes
• performance
• plan guide
• planning
• reporting
• reports
• security
• service pack
• ssl
• ssrs
• start
• testing

SQL Server 2005 standard query tuning options - plan guide for performance testing how to?
30 October 07 08:41 PM | SQL Master | 2 Comments   

You may be aware that plan guides will help the optimizer to perform better and a general recommendation is to use the relevant USE PLAN query hint when the other standard query tuning options are failed. It is also necessary to test through the results Read More...

Filed under: performance, sql server, indexes, planning, testing, hotfix, services, best practice, service pack, plan guide

Unable to start SQL Server service with a specific certificate?
31 August 07 06:05 AM | SQL Master | 3 Comments   

You may be aware that using SSL communications a HTTP server can have encryption for us, in this regard certificates must be authorized for server authentication. Microsoft recommends that you can do this by either obtaining an SSL certificate from a Read More...

Filed under: performance, sql server, security, certificate, services, start, http, ssl

Spurious errors when using SQL Server 2005 Performance Dashboard Reports
16 August 07 06:25 AM | SQL Master | 4 Comments   

You might have observed errors when using Performance Dashboard reports that is available (recently) for SQL Server 2005, the error below is mostly ocurred: Difference of two datetime columns caused overflow at runtime. Based on the forums & other Read More...

Filed under: performance, sql server, reporting, dashboard, ssrs, reports, services