<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 Farhan Sabzaali
»
SQL 2005 Rebuild\Reorganize Indexes with...
19 posts, Page 1 of 2
1
2
»»
SQL 2005 Rebuild\Reorganize Indexes with Reports
Rate Topic
Display Mode
Topic Options
Author
Message
Farhan Sabzaali
Farhan Sabzaali
Posted Wednesday, February 18, 2009 3:45 AM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, December 16, 2011 2:21 AM
Points: 76,
Visits: 135
Comments posted to this topic are about the item
SQL 2005 Rebuild\Reorganize Indexes with Reports
Farhan F. Sabzaali
PMP, MCP, MCDBA, MCSA, MCSE
Post #659216
Rome-828069
Rome-828069
Posted Monday, March 16, 2009 6:11 AM
Grasshopper
Group: General Forum Members
Last Login: Tuesday, December 01, 2009 7:50 AM
Points: 21,
Visits: 88
Maybe I am missing a step but this proc doesn't compile.
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near ' '.
Msg 102, Level 15, State 1, Line 57
Incorrect syntax near ' '.
Msg 102, Level 15, State 1, Line 146
....
edited out numerous errors.
Post #676405
Farhan Sabzaali
Farhan Sabzaali
Posted Monday, March 16, 2009 6:54 AM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, December 16, 2011 2:21 AM
Points: 76,
Visits: 135
It seems the script that got published has space unicode characters in it - I am attaching a zip file with compiled query - let me know if that works for you.
Thanks,
Farhan Sabzaali
Farhan F. Sabzaali
PMP, MCP, MCDBA, MCSA, MCSE
Post Attachments
ReorgScript-031609.zip
(
93 views,
9.69 KB
)
Post #676434
Rome-828069
Rome-828069
Posted Monday, March 16, 2009 7:21 AM
Grasshopper
Group: General Forum Members
Last Login: Tuesday, December 01, 2009 7:50 AM
Points: 21,
Visits: 88
That worked great. Very nice job.
Post #676456
icata
icata
Posted Monday, March 16, 2009 8:03 AM
SSC Veteran
Group: General Forum Members
Last Login: Thursday, May 16, 2013 8:07 AM
Points: 229,
Visits: 257
Nice, very comprehensive, lot of work.
Post #676512
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Monday, March 16, 2009 9:11 AM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 12:49 PM
Points: 31,432,
Visits: 13,742
I have updated the script with code from Farhan as well.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #676602
Paul-243651
Paul-243651
Posted Monday, March 16, 2009 6:19 PM
Forum Newbie
Group: General Forum Members
Last Login: Monday, March 23, 2009 11:39 PM
Points: 1,
Visits: 6
The comments in the sp say its for SQL 2005 only, but will it run on sql 2008?
Post #677084
Farhan Sabzaali
Farhan Sabzaali
Posted Monday, March 16, 2009 8:35 PM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, December 16, 2011 2:21 AM
Points: 76,
Visits: 135
To be honest, I have not tried as I don't have access to one - if you can test it on dev or test environment, it would help.
Farhan F. Sabzaali
PMP, MCP, MCDBA, MCSA, MCSE
Post #677127
jeff a
jeff a
Posted Monday, June 01, 2009 12:11 PM
Forum Newbie
Group: General Forum Members
Last Login: Friday, June 26, 2009 6:25 AM
Points: 2,
Visits: 9
This has been working well for me for several weeks, then we recently updated a vendor product and I'm getting an error. Looks like they updated their code to frequently create temporary tables and delete them. It appears the rebuild procedure doesn't handle tables that have been deleted after the procedure was started:
Msg 1088, Level 16, State 9, Line 1
Cannot find the object "NetPerfMon.dbo.NetFlowDetail_579_1382041" because it does not exist or you do not have permissions.
Any suggestions appreciated.
Post #726883
Farhan Sabzaali
Farhan Sabzaali
Posted Monday, June 01, 2009 12:17 PM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, December 16, 2011 2:21 AM
Points: 76,
Visits: 135
Ideally, you should run these type of jobs when database is in maintenance window - if possible, try to schedule it when the application is not using the DB. If that is not possible, try running it with Online option = 0 - that should only look for existing tables. If that does not work, I may have to review code in detail to help you.
Farhan F. Sabzaali
PMP, MCP, MCDBA, MCSA, MCSE
Post #726889
« Prev Topic
|
Next Topic »
19 posts, Page 1 of 2
1
2
»»
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.
