in

SQL Server Blogs

Voices from the UK SQL Server Community

Browse by Tags

  • What are the Crappy Code Games - Tips on how to win?

    This is part of a series on the Crappy Code Games The background Who can enter? What are the challenges? What are the prizes? Why should I attend? Tips on how to win Tips on how to win Each test has some different aspect that will define how you win. In this post we will give you some tips on how to...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Feb 16 2011
  • What are the Crappy Code Games - Why should I attend?

    This is part of a series on the Crappy Code Games The background Who can enter? What are the challenges? What are the prizes? Why should I attend? Tips on how to win Why should I attend? The crappy code games isn’t all about winning, its also about having a good time and learning about SQL Server. Even...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Feb 15 2011
  • What are the Crappy Code Games - What are the prizes?

    This is part of a series on the Crappy Code Games The background Who can enter? What are the challenges? What are the prizes? Why should I attend? Tips on how to win What are the prizes? There are loads of them at both the heats and the final. At the heats the top three coders at each event >will...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Mon, Feb 14 2011
  • What are the Crappy Code Games - Who can enter?

    This is part of a series on the Crappy Code Games The background Who can enter? What are the challenges? What are the prizes? Why should I attend? Tips on how to win Who can enter? Anyone can enter the competition, whats more anyone can just come along for the evening. All the evenings are aimed at being...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Feb 10 2011
  • What are the crappy code games - the background?

    This is part of a series on the Crappy Code Games The background Who can enter? What are the challenges? What are the prizes? Why should I attend? Tips on how to win   The Background Fusion IO came to us a while back wanting to run a competition to highlight the how bad code can really impact your...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Feb 9 2011
  • Make huge space savings by using SPARSE columns

    I’ve blogged before about Getting more than 1024 columns on a table , this is done by using sparse columns. Whilst this is potentially useful for people with insane table designs, sparse columns aren’t just for this. My experience over the past few years has shown that sparse columns are useful for almost...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Dec 17 2010
  • Trace Flag 610 – When should you use it?

    Thanks to Marcel van der Holst for providing this great information on the use of Trace Flag 610. This trace flag can be used to have minimal logging into a b tree (i.e. clustered table or an index on a heap) that already has data. It is a trace flag because in testing they found some scenarios where...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Nov 17 2010
Page 1 of 1 (7 items)
Powered by Community Server (Commercial Edition), by Telligent Systems