Viewing 3 posts - 841 through 844 (of 844 total)
It could be either your table does not have an index set up, or the database doesn't have any tables that have indexes.
You need to be connected to...
June 29, 2012 at 10:11 am
#1507203
Here is a query to find all the indexes on a table.
select r.[name] as table_name, i.[name] as index_name, c.[name] as column_name
FROM sys.index_columns l
inner join sys.tables r on
l.object_id = r.object_id
inner join...
June 29, 2012 at 8:25 am
#1507147
I like the ides of this, I would add ordering the columns as they are defined in the key. And for the programmers in my area I would add...
June 29, 2012 at 7:08 am
#1507114