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 you would expect are not upto the mark, when using...
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 certificate-issuing authority, such as Verisign, or...
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications The "SQL Server:SSIS Pipeline" performance object does not appear in the "Performance object" list after you...
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 blogs on the web suggests that The fix for that error...