Subscribe
Categories
Archives
- October 2022
- July 2020
- May 2020
- September 2019
- April 2019
- December 2017
- October 2017
- September 2017
- August 2017
- July 2017
- June 2017
- May 2017
- April 2017
- March 2017
- January 2017
- December 2016
- November 2016
- October 2016
- July 2016
- June 2016
- May 2016
- April 2016
- March 2016
- February 2016
- December 2015
- November 2015
- October 2015
- September 2015
- August 2015
- July 2015
- June 2015
- May 2015
- April 2015
- December 2014
- November 2014
- October 2014
- September 2014
- February 2014
- January 2014
- July 2013
- June 2013
- May 2013
- April 2013
- March 2013
- October 2012
- September 2012
- August 2012
- May 2012
- March 2012
- November 2011
- September 2011
- August 2011
- June 2011
- May 2011
- March 2011
- February 2011
- January 2011
- December 2010
- July 2010
- May 2010
- February 2010
- January 2010
- December 2009
Meta
Tag Archives: Production Issues
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 DBCC, Errors, Production Issues, sp_spaceused, SQL Scripts, sql server, SQL Server errors, T-SQL, T-SQL Scripts
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
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