.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links


Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server
Does anyone know what will happen to sys.sysindexes.rowmodctr?

In Books Online it says that sys.sysindexes will go away in a future version of SQL Server, but there is no new way to check if there has been any modifications since the statistics was last updated.

Ola Hallengren

View Complete Post

More Related Resource Links

SQL Server 2000 DB corruption with sysindexes

Here is the output: Server: Msg 8929, Level 16, State 1, Line 8 Object ID 2: Errors found in text ID 26839948591104 owned by data record identified by RID = (1:1959472:7) id = 469576711 and indid = 1. Server: Msg 8961, Level 16, State 1, Line 8 Table error: Object ID 2. The text, ntext, or image node at page (1:1442767), slot 7, text ID 26847561842688 does not match its reference from page (1:1959472), slot 7. Server: Msg 8980, Level 16, State 1, Line 8 Table error: Object ID 469576711, index ID 1. Index node page (0:0), slot 0 refers to child page (1:230) and previous child (0:0), but they were not encountered. Server: Msg 8906, Level 16, State 1, Line 8 Page (1:1056529) in database ID 8 is allocated in the SGAM (1:1022465) and PFS (1:1051440), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED   0_PCT_FULL'. CHECKDB found 1 allocation errors and 0 consistency errors in table '(Object ID -58537307)' (object ID -58537307). CHECKDB found 0 allocation errors and 2 consistency errors in table 'sysindexes' (object ID 2). CHECKDB found 1 allocation errors and 1 consistency errors in table 'Connections' (object ID 469576711). CHECKDB found 2 allocation errors and 3 consistency errors in database 'CompanyDB. Windows Server 2000, Sql Server 2000 Enterprise Edition 8.00.760 I've thought about using SQL recovery tool but since this is pointing to system

Deprecated Features - Sysindexes table


Hi All,

I read an article about deprecated features and sysindexes is marked as not supported under list "Features Not Supported in a Future Version of SQL Server" (system tables).

However I am surprised to see that sp_udpatestats procedure still uses sysindexes table for picking up rowmodctr column for verifying the indexes that got modified after last stats calculation, and this procedure is not using the new DMV's introduced in SQL 2005 like physical index stats, stats calculated date, last_user_modified_date etc.

Also sp_updatestats is not marked for deprecation. When applications depending on SQL server are modifying the code/re-writting to move to the new catalog views/DMV's, I would expect SQL Server system stored procedures also get modified accordingly.

It's just a thought and never know if MS can consider this request...



Thanks, Kumar
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend