Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: June 2011

Non use of persisted data – Part deux

In my last blog I showed how persisted data may not be used if you have used the base data on an include on an index.

That wasn't the only problem ive had that showed the same symptom.  Using the same code as before,  I was executing similar to the… Read more

0 comments, 202 reads

Posted in Dave Ballantynes blog on 20 June 2011

Itzik Ben-Gan is in town

Not that you would know it from the page below,  but Itzik Ben-Gan is back in London to do a 5 day training course, start 03october. 

http://www.qa.com/training-courses/technical-it-training/microsoft/microsoft-sql-server/microsoft-sql-server-2008-and-r2/advanced-t-sql-querying,-programming-and-tuning-for-sql-server-2005--2008

Why QA are not screaming this from the rafters, I will never be able to fathom.  Its kind of like going for a physics… Read more

1 comments, 709 reads

Posted in Dave Ballantynes blog on 17 June 2011

Non use of persisted data

Working at a client site, that in itself is good to say, I ran into a set of circumstances that made me ponder, and appreciate, the optimizer engine a bit more.

Working on optimizing a stored procedure, I found a piece of code similar to :

select BillToAddressID,
Rowguid,
dbo.udfCleanGuid(rowguid)…

Read more

2 comments, 330 reads

Posted in Dave Ballantynes blog on 13 June 2011

Column order can matter

Ordinarily, column order of a SQL statement does not matter.

Select a,b,c 
from table

will produce the same execution plan as
 
Select c,b,a
from table

However, sometimes it can make a difference.
 
Consider this statement (maxdop is used to make a simpler plan and has no impact to…

Read more

10 comments, 1,184 reads

Posted in Dave Ballantynes blog on 6 June 2011

Kent .Net/SqlServer User Group – Upcoming events

At the Kent user group we have two upcoming events.  Both are to be held at F-Keys Training suite http://f-keys.co.uk/ in Rochester, Kent.

If you haven’t attended before please note the location here.


14-June

Is your code S.O.L.I.D ?

Nathan Gloyn

Everybody keeps on about SOLID principles but what… Read more

0 comments, 194 reads

Posted in Dave Ballantynes blog on 5 June 2011