Engine - SimonS Blog on SQL Server Stuff

Browse by Tags

All Tags » Engine (RSS)
06 November 2007 21:50

Is the rows figure stored in sysindexes accurate

It wasn't guaranteed to be in SQL 2000 and earlier, but work was done in SQL 2005 that should mean that the rows figure stored in sys.partitions should be accurate. Madhivanan has posted about the different ways to count rows and this is the quickest...
Posted by simonsabin | 2 comment(s)
Filed under: , ,
21 August 2007 21:52

What is the position of a row ?

The simple answer is there isn't one. If you insert 1000 rows into a table and then want to get back the 43rd row you inserted you can't. You can read through all rows and return the 43rd one that the database reads from the table but that is not the...
Posted by simonsabin | 1 comment(s)
Filed under: ,