July 2008 - Posts

• Personal backups

  I finally got to spend some time on how to backup my machines, my home machines and laptop. This was triggered from when I got back from a week in Egypt and my LaCie NAS wouldn't start. I finally did manage to get it started by connecting through USB Read More... Posted Monday, July 28, 2008 1:52 PM by TiborKaraszi | 3 Comments Filed under: Backup

• Yet some more fixes for sp_indexinfo...

  I got some more feedback (see yesterday's blog post on this) which I now incorporated into sp_indexinfo. See change log at bottom of the article for details. http://www.karaszi.com/SQLServer/util_sp_indexinfo.asp Share this post: email it! | bookmark Read More... Posted Wednesday, July 09, 2008 11:03 AM by TiborKaraszi | 3 Comments Filed under: Performance, indexes

• New version of sp_indexinfo

  (See my initial blog post for general information about this proc.) I just updated sp_indexinfo a bit: I added the schema name as a new column in the output of the first resultset. I added an optional second resultset with missing index information. This Read More... Posted Tuesday, July 08, 2008 10:58 AM by TiborKaraszi | 7 Comments Filed under: Performance, indexes

• Fed up with hunting physical index details?

  I am. I find myself endlessly hunting for index information when working against the various SQL Servers I come in contact with. And, sure, the information is there. You just need to go and get it. This generally means that I start with sp_helpindex. Read More... Posted Monday, July 07, 2008 3:17 PM by TiborKaraszi | 9 Comments Filed under: Performance, indexes

• And here's another Software Development Meme

  I was called out by my friend Kalen Delaney on the Software Development Meme (something I've never heard about before, I had to look it up on the Internet ;-) ). Here goes: How old were you when you first started programming? I can't say for sure, I don't Read More... Posted Saturday, July 05, 2008 11:02 AM by TiborKaraszi | 2 Comments