Recently we were troubleshooting an issue with uploading files on a Sharepoint Site. When we were trying to upload any file we would get an exception message similar to this one: Unable to complete this operation. Please contact your administrator...

Sometimes a Service Pack or a Cumulative Update Package will not be applied successfully to your SQL Server failover instance. It is not always easy to find out the exact root cause – you need to review the hotfix logs which by default are found...

Consider the following scenario: - You are facing a performance issue in your SQL Server. - You suspect that your indexes may be fragmented. - You execute one query that reports the fragmentation, but you do not understand the output. ...

Autogrow of file 'XXXX' in database 'YYYY' was cancelled by user or timed out after ZZZZZ milliseconds Consider the following scenario: - You have not configured the autogrow of your SQL Server files manually and instead rely on the default...

Consider this scenario: - You are using Analysis Services 2008 (SSAS 2008). - Your DBA has created a new Database. - You have been given the database admin role. - However when you try to deploy your SSAS project, you get an error like...

There is insufficient system memory to run this query (Msg 701) Consider this scenario: - You have scheduled a Maintenance Plan for your databases. - Part of the Maintenance plan is to do an integrity check on your databases. - When...