Category Archives: SQL Server DBA

“Ctrl + R” is not working in SQL Server 2012: “Ctrl+R was pressed .Waiting for second key of chord..”

Posted on June 10, 2013 by uday arumilli

“Ctrl + R” is not working in SQL Server 2012: “Ctrl+R was pressed .Waiting for second key of chord..”   Keyboard short cut “Ctrl+R” is used to Show or hide the query results pane in SQL Server 2005/2008/R2 whereas in … Continue reading →

Posted in SQL Development, SQL Server DBA | Tagged , , , , , , | 3 Comments

SQL Server: Incorrect PFS free space information for page (1:xxxx) in object ID xxxxxx:

Posted on June 10, 2013 by uday arumilli

SQL Server: Incorrect PFS free space information for page (1:xxxx) in object ID xxxxxx:   “Incorrect PFS free space information for page (1:233791) in object ID 367392428, index ID 1, partition ID 72057594180730880, alloc unit ID 72057594222018560 (type LOB data). … Continue reading →

Posted in SQL Server DBA | Tagged , , , , , , , , , , | 3 Comments

SQL Server database backup automation using T-SQL

Posted on June 5, 2013 by uday arumilli

SQL Server database backup automation using T-SQL I have gone through a request as a part of daily maintenance. Found a backup maintenance plan has been failed due to low disk space.  “SQL Task     Description: Executing the query “BACKUP DATABASE … Continue reading →

Posted in SQL Server DBA | Tagged , , , , , , , | 1 Comment