Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
 Posted - 2013-06-06 : 02:53:13
|
| Is there a way to identify which column in a table is the most searched on? I would like to identify the columns in each table that has the highest number of searches on it, e.g.Select * from table1 where column1 = 'blahblah'orSelect @ from table1 order by column1Is there a dmv(s) or whatever i can use to glean this information from?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
Posted - 2013-06-06 : 04:39:02
|
| Some have no index, but thanks for the pointer.B |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-06 : 04:42:48
|
| No prbs...you're welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-06-06 : 10:46:46
|
| if you have knowledge of the queries - such as , they are all stored procedures , you could do a serach on the column reference , and then monitor how often the stored procedure is executedJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Finding Column Usage?