SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: June 2010

Kent Sql Server UserGroup

One of my back burner projects is to setup a local user group.  I'm delighted to now say that this is up and running.  Over the next few months, I hope to provide some great quality sessions and also provide some ‘virgin’ speakers, myself included, with an environment to practice.  If… Read more

0 comments, 387 reads

Posted in Dave Ballantynes blog on 28 June 2010

SQL 101 : Without “ORDER BY”, order is not guaranteed.

It’s as simple as that. If you don’t specify ORDER BY, then the order of your result set is not guaranteed. Oh sure , there may be situations where the data looks like it is being returned ordered, but this is not really the case. So, for example :


Read more

0 comments, 693 reads

Posted in Dave Ballantynes blog on 26 June 2010

SQL Server XML Schemas

Ever been curious about the schema of , say an SSRS rdl file ?  How about the execution plan ?

Not only should you already have the .XSD files , check out the folder ‘Microsoft SQL Server\100\Tools\Binn\schemas\sqlserver’ , but they are also available online hereRead more

0 comments, 481 reads

Posted in Dave Ballantynes blog on 15 June 2010