Browse by Tags

All Tags » 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: , , ,
19 May 2010 20:44

Analysing Indexes - reducing scans.

The whole subject of database/application tuning is sometimes akin to a black art, it's pretty easy to find your worst 20 whatever but actually seeking to reduce operational overhead can be slightly more tricky. If you ever read through my analysing...
Posted by GrumpyOldDBA | 4 comment(s)
Filed under: , ,
17 May 2010 20:12

Just when you thought it was safe..........

One of my duties is to handle software releases to our Production system, as is my want I always run my eye down any schema changes, this new object stood out for a number of reasons. I may add this to my interview questions: SET ANSI_NULLS ON SET QUOTED_IDENTIFIER...
Posted by GrumpyOldDBA | 2 comment(s)
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: , , ,
28 January 2010 20:38

Index Rebuild Observations

As part of a series of migration tests carrying out an all index rebuild on a user database has been used to compare relative performance. As the application is a true 7 x 24, there are no maintenance windows so index rebuilds are very intrusive and elicit...
Posted by GrumpyOldDBA | with no comments
Filed under: , , ,
27 October 2009 07:40

Well there's a thing

Just noticed this post from the PSS Team http://blogs.msdn.com/psssql/archive/2009/10/26/reduce-locking-and-other-needs-when-updating-data-better-performance.aspx never knew you could do double assignment x = y = z.
Posted by GrumpyOldDBA | with no comments
Filed under: ,
More Posts Next page »