<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by wfvdijk
»
Index usage overview
33 posts, Page 2 of 4
««
1
2
3
4
»
»»
Index usage overview
Rate Topic
Display Mode
Topic Options
Author
Message
2 Tim 3:16
2 Tim 3:16
Posted Tuesday, March 23, 2010 9:31 AM
Ten Centuries
Group: General Forum Members
Last Login: Friday, June 07, 2013 9:01 AM
Points: 1,081,
Visits: 1,456
I get 0 rows returned. tried it on several DB's.
Tim White
Post #888240
Wilfred van Dijk
Wilfred van Dijk
Posted Tuesday, March 23, 2010 10:04 AM
SSC Eights!
Group: General Forum Members
Last Login: Monday, June 10, 2013 7:21 AM
Points: 898,
Visits: 1,049
I guess it doesn't work on SQL 2000 (which is what I am using)?
Sorry, MSSQL 2005 and higher
Wilfred
The best things in life are the simple things
Post #888287
Madhu R
Madhu R
Posted Tuesday, March 23, 2010 7:02 PM
Forum Newbie
Group: General Forum Members
Last Login: Sunday, March 24, 2013 6:56 PM
Points: 6,
Visits: 42
Hi,
Thanks. I removed those empty spaces.. !! Its "completed" successfully.
However its turned out as 100% successfull, I can possibly run the view and its turns out as nothing. And I run across the same procedure into few DB's.
L
Post #888618
Wilfred van Dijk
Wilfred van Dijk
Posted Wednesday, March 24, 2010 1:36 AM
SSC Eights!
Group: General Forum Members
Last Login: Monday, June 10, 2013 7:21 AM
Points: 898,
Visits: 1,049
This view will only work in the database the view is created:
and a.database_id = DB_ID() -- for current database only
(that's the only thing which comes into my mind, or there are no indexes in the database
)
Try cutting this view into smaller pieces, for example first query the dm_ view, add join on sysindexes etc.
Wilfred
The best things in life are the simple things
Post #888723
Gail Wanabee
Gail Wanabee
Posted Monday, March 29, 2010 2:29 PM
SSC Veteran
Group: General Forum Members
Last Login: Thursday, June 13, 2013 5:09 PM
Points: 254,
Visits: 1,032
Wilfred,
What is the purpose of this elaborate query?
(NOTE: I have commented out the ALTER INDEX (DISABLE) statement until I get an explanation of what the query is supposed to do.)
I've run it against several test databases using SS2005 and SS2008. Without the ALTER INDEX (DISABLE) clause enabled, it appears to do nothing.
LC
Post #892198
SQLRNNR
SQLRNNR
Posted Monday, March 29, 2010 2:45 PM
SSCoach
Group: General Forum Members
Last Login: Today @ 12:32 AM
Points: 18,855,
Visits: 12,439
crainlee2 (3/29/2010)
Wilfred,
What is the purpose of this elaborate query?
(NOTE: I have commented out the ALTER INDEX (DISABLE) statement until I get an explanation of what the query is supposed to do.)
I've run it against several test databases using SS2005 and SS2008. Without the ALTER INDEX (DISABLE) clause enabled, it appears to do nothing.
LC
If I may, that line is to create the command to disable an index. It looks to be purely optional and is only the text of the command. The command would need to be copied and executed separately.
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #892213
SQLRNNR
SQLRNNR
Posted Monday, March 29, 2010 2:45 PM
SSCoach
Group: General Forum Members
Last Login: Today @ 12:32 AM
Points: 18,855,
Visits: 12,439
Nice Script. I think I can find some use for it.
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #892214
Wilfred van Dijk
Wilfred van Dijk
Posted Monday, March 29, 2010 4:03 PM
SSC Eights!
Group: General Forum Members
Last Login: Monday, June 10, 2013 7:21 AM
Points: 898,
Visits: 1,049
crainlee2 (3/29/2010)
Wilfred,
What is the purpose of this elaborate query?
(NOTE: I have commented out the ALTER INDEX (DISABLE) statement until I get an explanation of what the query is supposed to do.)
I've run it against several test databases using SS2005 and SS2008. Without the ALTER INDEX (DISABLE) clause enabled, it appears to do nothing.
LC
It's an easy way to disable a low performing index, by copy/paste this disable statement
Wilfred
The best things in life are the simple things
Post #892277
Gail Wanabee
Gail Wanabee
Posted Monday, March 29, 2010 6:13 PM
SSC Veteran
Group: General Forum Members
Last Login: Thursday, June 13, 2013 5:09 PM
Points: 254,
Visits: 1,032
Thanks.
LC
Post #892354
SQLRNNR
SQLRNNR
Posted Wednesday, March 31, 2010 4:18 PM
SSCoach
Group: General Forum Members
Last Login: Today @ 12:32 AM
Points: 18,855,
Visits: 12,439
I have taken this script provided by Wilfred and updated it to SQL 2005.
If interested, you can read about it at:
http://jasonbrimhall.info/?p=407
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #894277
« Prev Topic
|
Next Topic »
33 posts, Page 2 of 4
««
1
2
3
4
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
