:laugh: By the way, it's not often code produces a 'whoa!' reaction from me.

Jeff,

In my experience, BOL is a bit optimistic here. In "Databases created on SQL Server 2005 should never experience incorrect counts", the operative word is 'should'. If the...

Whoa! This is a stop-and-start-again situation I am afraid. The code looks like it is based on some attempt at...

This script demonstrates some concepts to answer some of your questions:

USE tempdb

GO

CREATE PARTITION FUNCTION PF(date) AS

RANGE RIGHT FOR VALUES ('2012-02-01', '2012-03-01', '2012-04-01');

GO ...

I would pay particular attention to whether the filter is 64-bit or 32-bit.

Well it is documented as being not guaranteed - that says it all really. ...

In fact sp_spaceused uses sys.dm_db_partition_stats:

SELECT

@reservedpages = SUM (reserved_page_count),

@usedpages = SUM (used_page_count),

@pages = SUM (

CASE

WHEN (index_id < 2) THEN (in_row_data_page_count + lob_used_page_count + row_overflow_used_page_count)

ELSE lob_used_page_count + row_overflow_used_page_count

END

),

@rowCount = SUM (

CASE

WHEN...

It seems the metadata is slightly out of sync for this heap. This can happen for lots of reasons, and the rows column in sys.partitions is documented in Books...

Also, what's the result of SELECT COUNT(*) FROM {table} WITH (INDEX(0))?

What version & build of SQL Server is this?

Have you run a DBCC check on the database, or at least on the table?

Is there anything unusual about the table/view?

Can you...

One very fast method is detailed here:

http://pavelpawlowski.wordpress.com/2010/09/30/sql-server-and-fastest-running-totals-using-clr/

CTRL+Tab is one option. See SQL Server Management Studio Keyboard Shortcuts for a fairly comprehensive list.

Steve Jones - SSC Editor (1/25/2012)

---

SQL Kiwi (1/25/2012)

---

If we had ever met in person, you would not need to even...

There is a SQL Saturday in Auckland in 48 hours 🙂

Steve Jones - SSC Editor (1/25/2012)

---

SQL Kiwi (1/24/2012)

---

Henrico Bekker (1/24/2012)

---

Some people might see this as a trick question, because no where does it state "Full Backup & Shrink THE SAME...