Browse by Tags
All Tags »
SQL Server (
RSS)
Sorry, but there are no more tags available to filter with.
When index fragmentation becomes too high, indexes will be very inefficient. Other than planning a good index design, you should rebuild / reorganize your indexes every once in a while. SELECT 'ALTER INDEX [' + ix . name + '] ON [' + s . name + '].[' + t . name + '] '...
I just filed a new bug with Microsoft Connect . I certainly hope this one doesn’t get shrugged off like many of my other bugs did. Want to reproduce it yourselves? Just create a table with a character that can only be valid inside the context of brackets (like a comma or braces) and then try to select...