GilaMonster (1/31/2013)

---

That's the rowmodctr column, not rows.

Rowmodctr = row modification counter, number of rows changed since that statistic was last updated. Set to 0 when the index is rebuilt or...

This quote from the MSDN page I referenced seems to indicate some relation.

"Counts the total number of inserted, deleted,...

Lowell (1/31/2013)

---

i thought you had to get the actual counts from sys.indexes; since the index must have a heap/PK index for every table, teh row counts are materialized exactly correct...

This is the fastest and most reliable way I have found.

SELECT SUM (row_count)

FROM sys.dm_db_partition_stats

WHERE object_id = OBJECT_ID('dbo.MovimentosFuncionarios')

AND (index_id=0 or index_id=1);

Enjoy!

Good editorial Steve!

I vaguely remember a similar debate, many years ago, regarding 16 or 32 bit. I guess the more things change the more they stay the same. :laugh:

There may...

prathibha_aviator (1/22/2013)

---

SET @OrgName = N'SELECT ORG_ID ' + CONVERT(varchar(10), @orgid) +' '+ '[Description]' + ' ' +'('+ CONVERT(varchar(20),+ 'pol_id)'

+')'+ 'from'+ @dbname + '.dbo.Organization'+ 'where OrganizationID =' + @orgid;

Above is the...

Hugo Kornelis (1/22/2013)

---

... showing or suppressing the "xx rows affected" message is an option you can change. See my first message in this topic. In the message just above yours,...

venkat9.sql (1/22/2013)

---

Thanks for the reply. I didn't execute the code. I just used the display estimated execution plan.

I checked the messages tab and didnt get the 1 row affected message.

I...

Hello,...

L' Eomot Inversé (1/18/2013)

---

... But if you want to know how many rows that code affects, which is what you asked, you have to run the code as well as...

I don't even agree with this statement because I gave a clear and...

bitbucket-25253 (1/18/2013)

---

I think the message tab is...

Try this:

1) Paste code into SSMS query analyzer

2) Click...

Because I would expect that someone who has been visiting this site longer than me...

That sounds logical. But of course...