Browse by Tags

An interesting annecdote

A while ago I blogged about using the dmvs to identify lookups and scans on tables http://sqlblogcasts.com/blogs/grumpyolddba/archive/2010/05/19/analysing-indexes-reducing-scans.aspx Well continuing on from this I had discovered that two of the top scanning tables don't actually contain any data...

Posted to Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Wed, Jul 28 2010
Cursors 1 Sets 0

I had an interesting experience with a database I essentially know nothing about. On the server is a database which stores session state, Microsoft provide the code/database with their dot net, so I'm told. Anyway this database has sat happily on the production server for the past 4 years I guess...

Posted to Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Tue, Mar 23 2010
Things I learned today

I'm involved with some tuning as usually tends to be the case and amongst the work I've been doing a couple of interesting points arose. Firstly we upgraded the memory in the production cluster, what was unusual for me was that we added more memory than we had databases, I've never worked a production...

Posted to Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Wed, Jan 30 2008

Page 1 of 1 (3 items)

SQL Server Blogs