SQL Server - Omer van Kloeten's .NET Zen

News

Note: This blog has moved to omervk.wordpress.com.

Omer has been professionally developing applications over the past 8 years, both at the IDF’s IT corps and later at the Sela Technology Center, but has had the programming bug ever since he can remember himself.
As a senior developer at NuConomy, a leading web analytics and advertising startup, he leads a wide range of technologies for its flagship products.

Navigation

.NET Resources

Lutz Roeder's Reflector

Articles :: CodeDom

Articles :: nGineer

Culture

Projects

Browse by Tags

All Tags » SQL Server (RSS)

Let SQL Server Tell You Which Indexes to Rebuild

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 + '].['...

Posted: Jan 05 2009, 01:37 PM by Omer van Kloeten | with 11 comment(s)

Filed under: SQL Server

SQL Server Management Studio 2008 IntelliSense Doesn't Recognize Special Characters

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...

Posted: Jan 05 2009, 11:16 AM by Omer van Kloeten | with 3 comment(s)