Here is the query:

SELECT OBJECT_NAME([object_id]),index_id,SUM(record_count),SUM(page_count)

FROM sys.dm_db_index_physical_stats(DB_ID(),NULL,NULL,0,'DETAILED')

GROUP BY OBJECT_NAME([object_id]),index_id

ORDER BY 3 DESC

My question: do the record_count and page_count mean for both data and index, or for index only?

Thanks,

SQLKnowItAll (4/23/2012)

---

Did you do your upgrade on the day that is referenced as the last day the services were running? Is everything running correctly now? Those would be my first...

Any help please?

Thank you, but my questions still not being answered.

I read the article, and I do have that link in my post too.

The article says the report is upgraded, but not...

Thanks all, I am not an English native speaker, sometimes it is hard to find a word that is vividly describe what I want.

This helps a lot.

As you told, I reset max memory, I have not seen theat error since yesterday, hopefully it will last.

Thanks,

Any one knows if spatial data load use a lot of memory,...

Thanks, now I remove the where clause, it works.

The processID should take care of those.

And I learned too, in the future to post more about DDLs.

Thanks all.

This is hard for me too everytime to post on T-SQL forum, try to make it simple to get some hint, and not post all complicated table structures and...

SQLKnowItAll (4/17/2012)

---

No, look:

ALTER TABLE [dbo].[batSchoolRangeProgramResult] WITH CHECK ADD CONSTRAINT [FK_batSchoolRangeProgramResult_appSchoolRangeProgramSnapshot] FOREIGN KEY([ProcessID], [SchoolYear], [SchoolID], [RangeCd], [ProgramID])

REFERENCES [dbo].[appSchoolRangeProgramSnapshot] ([ProcessID], [SchoolYear], [SchoolID], [RangeCd], [ProgramID])

So the constraint is on batSchoolRangeProgramResult and...

I specifically pay attention to the order. So I delete from the child first, then parent table.

But I still get the error, I also tried to reverse the order, I...

might be what the op is looking for, the op may also be designing a back end SP that only certian users use. i have several SP's that only...

Thank you, I will read it.

By the way, I see in microsoft site:

http://msdn.microsoft.com/en-us/library/ms178067(v=sql.100).aspx

Server Memory Options

It says:

Allowing SQL Server to use memory dynamically is recommended; however, you can set...

I just did a dbcc checkdb for one of the readonly archived db, it takes about 8 minutes. we have about 60 archived database, so 6 hours may make sense.

The...

Yes, this is very very helpful.

It is a good start, we will soon have a meeting to talk about how to do the process.

I will come to update more if...

Thanks, our company doesn't allow automatic update on some of our application servers that hosts some in house developed applications, which include web server, application server and database server.

So it...