Tag Archives: SQL Server errors

SP_SPACEUSED is giving wrong counts

SP_SPACEUSED is giving wrong counts !!! SP_SPACEUSED: is a system stored procedure and used to capture number of rows, total size, data and index size information. Sometimes SP_SPACEUSED may give incorrect information or SP_SPACEUSED  give wrong counts. Below are some … Continue reading

Posted in SQL Development | Tagged , , , , , , , , | 1 Comment

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

“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:

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