Browse by Tags

All Tags » General Tuning » Code Tuning (RSS)
12 September 2011 20:52

Table Variables and Parallel Plans

I’m sure somewhere there must be carved into the side of a mountain those immortal words “ Well it seemed a good idea at the time!” ( with due homage to HHGTTG ) Hopefully there’s nothing in this post which you the reader will not know about already?...
Posted by GrumpyOldDBA | with no comments
Filed under: ,
05 September 2011 13:23

Posts of Interest

I don't make a habit of just posting links as I think it's like a form of cheating, however sometimes there are things I want to keep track of and I know If I put the link on my blog I'll find it again! so: a short one here; We've just...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
14 September 2010 22:08

IF Exits vs Count(*) – just when you thought it was safe ….

Here’s a couple more of the topics I covered in my presentation “ Gone in 60 Nano seconds “.  It’s tricky sometimes formatting posts to display correctly on the blog so for most of the material from the presentation I’m going to link to the pages...
Posted by GrumpyOldDBA | with no comments
Filed under: , , ,
28 July 2010 13:28

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...
Posted by GrumpyOldDBA | with no comments
Filed under: , , ,
06 April 2010 21:02

Would you expect this error ?

Now I know why, but what I'm thinking is that if I create an error should I get valid data returned? To explain, I was browsing through the dmvs for queries which might benefit from tuning and I identified a query with two clustered index scans (...
Posted by GrumpyOldDBA | 2 comment(s)
Filed under: ,
23 March 2010 19:33

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...
Posted by GrumpyOldDBA | 2 comment(s)
Filed under: , , ,
16 March 2009 20:38

Reasons to move to SQL 2008 MERGE pt 2

In my previous post with the MERGE statement it was assumed that the pairs of data would be unique and the second set would not already exist. I can’t say that I’d actually put together a really good example and I’m not saying that this is the most brilliant...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
30 January 2008 19:18

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...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: , , ,
22 July 2007 22:38

Analysing Indexes Part 2

Here's the next instalment, expect there to at least another two or three. I’m still only working with basic indexing No partitioning I’m not looking at xml indexes. 14.0 Collecting Raw Index usage data Collects table name, index name , reads and writes...
Posted by GrumpyOldDBA | 5 comment(s)
Filed under: , ,
15 June 2007 10:24

Maxdop hint for Views

With the advent of multi core processors the issue of parallelism is likely to cause more problems than before – the usual posted answer on forums to resolve parallelism ( CXPACKET ) locks is to disable or severely restrict processors. I’m sure this is...
Posted by GrumpyOldDBA | with no comments
Filed under: ,