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...

Posted to SQL Server Knowledge Sharing Network (@sqlmaster) (Weblog) by ssqa.net on Tue, Feb 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 Mon, Dec 3 2007
Surendran

Posted to Surendran (Gallery) by Surendran on Wed, Oct 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 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 >