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...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
June 29, 2012 at 10:11 am
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...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
June 29, 2012 at 8:25 am
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...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
June 29, 2012 at 7:08 am
Viewing 3 posts - 841 through 844 (of 844 total)