November 2007 - Posts

• Geek City: New Geeky Words

  I've always been amazed at the ability of the IT community to come up with new words on an almost daily basis. The thing that's really scary about it is that if you're truly geeky enough, you know what the new words mean without being told. The first Read More... Posted Friday, November 30, 2007 1:11 PM by Kalen Delaney | 16 Comments

• Did You Know? I'm Going Down Under Again!

  Most of my trips to the Southern Hemisphere have been in my summer, or their winter, which doesn't lend itself to the best weather conditions. Although on my last trip, I was able to take a week holiday with my husband and travel North to the Whitsunday Read More... Posted Thursday, November 29, 2007 1:17 PM by Kalen Delaney | 0 Comments Filed under: internals, training, Inside SQL Server, Australia

• Did you know? Cloning is Legal (and Available in SQL Server 2005)

  I first heard about the possibility of database cloning way back in version 7.0 and thought it sounded like a great idea. Who wouldn't love to have a bunch of identical little databases running around, of smaller size and easier manageability? Cloning Read More... Posted Wednesday, November 21, 2007 11:50 AM by Kalen Delaney | 5 Comments Filed under: metadata, Tools, execution plan, scripts, statistics

• Geek City: Playing with Metadata for Statistics - Part 2

  When I got back to class this morning, I showed the class this blog, and the solution I had written to the question from yesterday. It was only then that I found out the need was for SQL Server 2000. Where SQL 2005 has the catalog view sys.stats with Read More... Posted Wednesday, November 07, 2007 7:58 PM by Kalen Delaney | 0 Comments

• Geek City: Playing with Metadata for Statistics

  In class today, we were talking about automatic updating of statistics, and that you could use sp_autostats to turn off the automatic updating for just a single table, which is vastly preferable to turning it off for the entire database. One of the students Read More... Posted Tuesday, November 06, 2007 7:38 PM by Kalen Delaney | 1 Comments

• Did You Know? SP2 does NOT limit the amount of plan cache you can have

  As I am preparing my talk for the UK SQL Server Users Group on November 16, I was going through other presentations on plan cache management. At the PASS Conference in Denver in September there was a session on management of cache, and I was surprised Read More... Posted Sunday, November 04, 2007 7:39 PM by Kalen Delaney | 10 Comments Filed under: internals, Inside SQL Server, plan cache, UK