Twitter Updates
- Mac malware signed with Apple ID infects activist’s laptop ars.to/16EkLX6 1 day ago
- iOS 6.0 gets US federal government's security stamp of approval imore.com/ios-60-gets-us… via @iMore 5 days ago
- Dear the Oatmeal, I see your Mantis Shrimp post, and I raise you my favorite animal… thedoghousediaries.com/5076 via @willrayraf 5 days ago
- RT @dursunovic: I Don't Want Your Fucking App idontwantyourfuckingapp.tumblr.com 6 days ago
- @gisellis that would be a wonderful silver lining if it worked out that way! 1 week ago
What I’m Reading
No data found
Tags
.NET airplay akamai asp.net awk books browser customer service cygwin debugging DNS experiments family google home technology iis iMovie iOS iPad iPhone ISP javascript jboss judaism location services memcached methodology mobile networking npr parenting performance personal finance photography powershell routing security shabbat shortcuts social media sql sqlserver television tomcat travel-
Recent Posts
- Caught cheating while reading my daughter’s bedtime story
- How I became one of those jackasses with a bluetooth headset
- Trying out GoldieBlox on my five year old daughter
- A parent’s emergency mnemonic for bolting out the door with kids
- TripIt Pro is absolutely worth the money, even if you travel infrequently
Archives
- May 2013
- April 2013
- March 2013
- February 2013
- January 2013
- December 2012
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
RSS
Categories
Meta
Tag Archives: sql
Performance: Alter a table’s clustered index in SQL Server while keeping the table online
Back in the old SQL Server 2000 days, creating an index was a major operation that would prevent queries and data modifications until it had completed. Unless the index could be created in a few seconds, any new indexes had … Continue reading
Performance: Query the sqlserver plan cache to find queries that use a particular index
Part of keeping a SQL Server database running smoothly is to keep indexes well tuned. As database schemas or usage change, indexes that were once important may fall out of use. Eliminating unnecessary indexes helps speed up inserts/updates/deletes, and it … Continue reading
