in

SQL Server Community Blogs

Voices of the SQL Server Community
All Tags » SQL (RSS)

Browse by Tags

  • 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 04-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 02-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...
    Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by ssqa.net on 02-12-2008

  • 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 12-03-2007

  • Surendran

    Posted to Surendran (Gallery) by Surendran on 10-17-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 09-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 09-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 07-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 have...
    Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 06-26-2007

  • ProClarity 6.3 available on MSDN downloads

    I've just logged into MSDN downloads and was very shocked to see ProClarity available for download. Both server and desktop versions are available. You can read more on Proclarity here http://www.proclarity.com/ if (socialButtons!=null) { socialButtons(); } - google_ad_client = "pub-9351707026400773...
    Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 04-04-2007
Page 1 of 4 (36 items) 1 2 3 4 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems