This is the DMV you need, sys.dm_db_index_usage_stats. As for querying it, it's really straight forward. You can join to other system views to get the table & index names. The...

There are a number of workarounds posted here at the Connect item. There's also a discussion around why it's occurring. Short answer, it's because they actually preallocate identity values as...

Microsoft does a pretty thorough job of documenting these right here in the Books Online.

So you're not checking consistency prior to running backups? Might want to start that going forward.

First, identify the exact object that is corrupted. If it's a nonclustered index, you have...

I don't see any way to capture that information. Even the existing_connection event which has more data than any other event around connections doesn't have IP addresses. I suspect this...

Before I immediately did the restore, I'd check that object_id to see what the object is that is misallocated. If it's a nonclustered index, you can drop it and recreate...

The best way to get this kind of thing done is not to put the database into single user mode. The best way is to put it into restricted user...

T_Peters (1/14/2015)

---

No, I didn't turn off compression or make any other changes to the maintenance jobs. Is there any way to query a backup file to see if it used...

I'm with Gail. You find out what the companies expectations are around Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO). RPO is the amount of information, measured in time,...

Steve Jones - SSC Editor (1/14/2015)

---

Grant Fritchey (1/14/2015)

---

Back on topic for a moment.

Maybe I'm in a weird head-space at the moment, but it seems like the questions have gotten... not...

Good to hear it.

Personal opinion, avoid system generated names. They just make everything harder.

Back on topic for a moment.

Maybe I'm in a weird head-space at the moment, but it seems like the questions have gotten... not worse, but weirder. Sort of off the...

Modify the syntax so that it includes the name you want:

ALTER TABLE [dbo].Mytable ADD CONSTRAINT xxx UNIQUE NONCLUSTERED

(

[ID] ASC

)

Not something I've tried, but you could look at Red Gate SQL Dependency Tracker[/url]. It does a pretty good job of finding everything that references a table (or other...

It aged out of cache is the first thing that comes to mind. Just because others were created earlier, they may also have been accessed more recently. Another thing is...