in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » SQL (RSS)

Browse by Tags

  • SQLBits evening do

    We have finally got finalised that, at SQLBits, we will be having a drinks reception after the sessions finish. There will FREE beer (other drinks will be available) and pizza. We've also got some entertainment planned so it should be a good evening
    Posted to SQLBits (Weblog) by simonsabin on Tue, Sep 2 2008
  • New MSDN SQL Server Wiki

    The Volunteer Moderators and Answerers who support the Microsoft MSDN SQL Server Forums have created a new wiki to present Solutions to Common T-SQL Problems at http://code.msdn.microsoft.com/SQLExamples . At the moment mere mortals can't update the solutions but you can leave comments.
    Posted to Jon Sayce (Weblog) by jonsayce on Thu, Apr 17 2008
  • SqlClrProject version 2.6 Released

    I have just released a new version - 2.6 - of the deployment tool for SQLCLR assemblies. It is a minor release, but it implements some changes that are fundamental for coming versions and also fixes a couple of minor bugs. The download page for it is here , and if you want general information about what...
    Posted to Niels SQL Server Blog (Weblog) by nielsb on Wed, Feb 27 2008
  • Certification path for SQL Server 2008, whats your choice?

    Are you ready for your SQL Server 2008 Certification? As SQL Server 2008 is still in CTP process Microsoft learning has already announced the process in getting certification in this new version. Not only with Learning opportunities Microsoft Press also offering freebies by the way of ebooks and press...
  • Using ...WHERE NOT IN (SELECT... with NULLs

    I was asked to look at a query today and explain why using a NOT IN clause wasn't returning any rows. Switching the NOT IN to an IN resulted in 38 rows, and removing the clause completely returned 431 rows. So what was happening to the other 393? Surely if a row is not in IN, then it should be in NOT...
    Posted to Jon Sayce (Weblog) by jonsayce on Mon, Dec 3 2007
  • Cumulative update package 3 for SQL Server 2005 Service Pack 2

    There is a new hotfix available for SQL Server 2005 SP2. There are number of fixes in this. http://support.microsoft.com/kb/939537/ This is not publicly available. You would need to subit a request and you will get a reply within few hours stating the location and password where you can download the...
    Posted to Sutha's SQL BI Blog (Weblog) by tsutha on Wed, Sep 19 2007
  • SQL Server 2005 Performance Dashboard Reports

    If you have come across performance issues in SQL Server 2005, you might find this useful. http://www.microsoft.com/downloads/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en Thanks Sutha
    Posted to Sutha's SQL BI Blog (Weblog) by tsutha on Wed, Sep 19 2007
  • Loading Date Dimension

    I am sure all of you seen this script before. More than anything I am putting this here for my reference in the future. Last couple of client sites I have worked, their fiscal year is aligned with calendar year and therefore it made life much easier. The SP below can populate the dates as you specify...
    Posted to Sutha's SQL BI Blog (Weblog) by tsutha on Tue, Jul 24 2007
  • To cluster of not

    Tony's blogged about the use of heaps http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/06/24/row-fragmentation-hopscotch-heap-v-clustered-and-io-cost.aspx . Whilst this highlights data on a page being out of sequence and thus yoyoing when you scan the data, it doesn't mean you should always...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Jun 26 2007
Page 2 of 5 (47 items) < Previous 1 2 3 4 5 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems