Subscribe to this blog
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, 90 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 :
CREATE…
0 comments, 93 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 here. Read more
0 comments, 92 reads
Posted in Dave Ballantynes blog on 15 June 2010