Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

Index usage overview Expand / Collapse
Author
Message
Posted Friday, March 12, 2010 2:25 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 8:52 AM
Points: 930, Visits: 1,135
Comments posted to this topic are about the item Index usage overview

Wilfred
The best things in life are the simple things
Post #882143
Posted Tuesday, March 23, 2010 12:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, March 24, 2013 6:56 PM
Points: 6, Visits: 42
Hi,

I am trying to run your index preview. But its turns out as error for my DB.

Here is the error

[color=#505050]Msg 102, Level 15, State 1, Procedure vw_index_usage, Line 3
Incorrect syntax near ' '.
Msg 102, Level 15, State 1, Procedure vw_index_usage, Line 21
Incorrect syntax near 'MB'.
Msg 102, Level 15, State 1, Procedure vw_index_usage, Line 22
Incorrect syntax near 'cols'.
Msg 102, Level 15, State 1, Procedure vw_index_usage, Line 23
Incorrect syntax near 'included'.[/color]
Post #887856
Posted Tuesday, March 23, 2010 3:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 28, 2011 7:31 AM
Points: 6, Visits: 70
This is because of the formatting when copying and pasting from the web.

Select one of the 'space' characters, for example the first character on the second line the do a 'replace all' and replace them all with a single space. This should sort it out.
Post #887933
Posted Tuesday, March 23, 2010 6:41 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 7:44 AM
Points: 20, Visits: 453
Not knocking the script... but for newbies would be nice to explain the column outputs in a brief description. They could probably find explanations in BOL (and common sense) but might be a nice to get the original thoughts form the OP
Post #888055
Posted Tuesday, March 23, 2010 6:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 6, 2011 10:30 AM
Points: 3, Visits: 37
That does not seem to fix things. Also, replacing the double quote (not space) does not fix things either...
Post #888060
Posted Tuesday, March 23, 2010 6:50 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 7:44 AM
Points: 20, Visits: 453
MOP (3/23/2010)
That does not seem to fix things. Also, replacing the double quote (not space) does not fix things either...


I can confirm that the fix mentioned works (for me). if all else fails with the find and replace, retype the query and you'll be able to run it fine.
Post #888064
Posted Tuesday, March 23, 2010 6:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 6, 2011 10:30 AM
Points: 3, Visits: 37
Yes, my bad. I picked the first character in the third line, did a replace with space and the script ran just fine.

Thanks!
Post #888073
Posted Tuesday, March 23, 2010 7:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 28, 2011 7:31 AM
Points: 6, Visits: 70
hfxDBA (3/23/2010)
Not knocking the script... but for newbies would be nice to explain the column outputs in a brief description. They could probably find explanations in BOL (and common sense) but might be a nice to get the original thoughts form the OP


I agree, and explaination would be nice.
Post #888113
Posted Tuesday, March 23, 2010 8:45 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 8:52 AM
Points: 930, Visits: 1,135
Got it, I'll post an explanation later this week.

Wilfred
The best things in life are the simple things
Post #888178
Posted Tuesday, March 23, 2010 9:30 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 10:15 AM
Points: 11, Visits: 96
Hi there,

I have encounted the following errors when trying the script:

Server: Msg 208, Level 16, State 1, Procedure vw_index_usage, Line 3
Invalid object name 'sys.index_columns'.
Server: Msg 208, Level 16, State 1, Procedure vw_index_usage, Line 3
Invalid object name 'sys.index_columns'.
Server: Msg 208, Level 16, State 1, Procedure vw_index_usage, Line 3
Invalid object name 'sys.dm_db_index_usage_stats'.
Server: Msg 208, Level 16, State 1, Procedure vw_index_usage, Line 3
Invalid object name 'sys.indexes'.
Server: Msg 208, Level 16, State 1, Procedure vw_index_usage, Line 3
Invalid object name 'sys.filegroups'.

I guess it doesn't work on SQL 2000 (which is what I am using)?

Thanks!

Yvonne
Post #888239
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse