October 24, 2008 at 10:05 am
So here's my take on the whole selective indexing discussion. It would be GREATLY appreciated if I could get some opinions on both the script itself and the blog in general. I've never done the whole "blogger" thing and I'm trying to use it as a centralized location for my SQL Server thoughts, scripts, etc
http://benchmarkitconsulting.blogspot.com/2008/10/smart-reindexing-sql-server-2005-2008.html
Any feedback would be awesome!!!
Thanks
October 24, 2008 at 11:47 am
If you're intending that to be a generic script that can be used anywhere by anyone, you may want to add [ and ] around the index, schema and table names. Right now it will fail with a syntax error if someone has a table named for a SQL reserved word (like Transaction) or in cases where the object names are otherwise invalid (starting with numbers, containing spaces, etc)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2008 at 11:50 am
great!! thanks 🙂 (now changed on blog)
exactly the type of feedback I was looking to get (+1 karma points for you hehehe)
Thanks again
October 24, 2008 at 2:06 pm
Another Canadian, yeah!
1. Good article, informative, should make it clickable
http://benchmarkitconsulting.blogspot.com/2008/10/smart-reindexing-sql-server-2005-2008.html
2. should pretty up the code on HTML
http://extras.sqlservercentral.com/prettifier/prettifier.aspx
3. I think you should also mention ONLINE index vs OFFLINE index, and that ONLINE is only in Enterprise editions
from 2008 BOL - * Rebuilding an index can be executed online or offline. Reorganizing an index is always executed online. To achieve availability similar to the reorganize option, you should rebuild indexes online.
4. Maybe mention differences between REORGANIZE and REBUILD
Overall, good start, keep it up.
October 24, 2008 at 2:32 pm
Thanks for the ping back!! 🙂
2. should pretty up the code on HTML
http://extras.sqlservercentral.com/prettifier/prettifier.aspx%5B/quote%5D
Gold Star on that one 😀 I've been looking everywhere for something like that.
Every other comment/suggestion has been fixed/added as well
Thanks again
P.S. I recognize your blog template from somewhere hehehe 😎
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply