SELECT p.TABLE_NAME,c.CONSTRAINT_NAME,c.COLUMN_NAME

FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS p ,

INFORMATION_SCHEMA.KEY_COLUMN_USAGE c

WHERE CONSTRAINT_TYPE = 'PRIMARY KEY'

AND c.TABLE_NAME = p.TABLE_NAME

AND c.CONSTRAINT_NAME = p.CONSTRAINT_NAME

ORDER by c.TABLE_NAME

google it

for statistics i dont know but yes following query help you to figure out which indexes are not being used

select i.name as indexname,

object_name(s.[object_id]) as tablename, s.database_id, s.[object_id], s.User_seeks, last_user_seek,...

CirquedeSQLeil (4/7/2010)

---

Nah, I was referring to Steve's...

well your changes ? as soon steve will look into them and considered them worth 😀

this can be used for member who has scored maximum points in one year

Be careful when you drop statistics. Doing so may affect the execution plan chosen by the query optimizer.Statistics on indexes cannot be dropped by using DROP STATISTICS. Statistics remain as...

hennie7863 (4/6/2010)

---

Company wants to update the software and more Foreign keys are added. These Foreign keys will be indexed. I now know more about this issue: There are about 80...

why company asking to add more indexes, did they feel any bad performance in that table? and are all...

1. Use BULK INSERT method

2. Uss batch approach in DML operations(let says work on 10,0000 records one by one)

* Increases resource usage when modifying data since row versions are maintained in tempDB.

* Update and Delete...

Jeff Moden (4/6/2010)

---

There's still a way even in SQL Server 2000. Long before synonyms, we used "pass through views" which are nothing more than a view that does a...

try with OPENDATASOURCE

Yes, Customer is table

we can have more levels after SSCChampion like SSGuru or SSCoach ( for 15000 + or 25000 + points)