Browse by Tags

SQL Server 2008 - TSQL behavioural changes and enhancements

Published 31 March 8 2:0 PM | SSQA.net

As usual the new release of SQL Server version 2008 had few changes from 2000 to 2005 and as usual this control-of-flow sequence should occur in order to take advantage of performance with transaction/rollback advantages. Such direction of flow should...

Filed under: sql server, performance, transaction, article, 2008, tsql, enhancement, begin

How to find whether that service pack file is a 32 bit or 64 bit?

Published 1 November 7 6:44 AM | SSQA.net

Whenever a service pack is released it will be available for 32-bit and 64-bit that also includes for SQL Express 2005 edition too, as it was for MSDE earlier. Since last year (I think) Microsoft Development team has adopted a standard in naming schema...

Filed under: sql server, msdn, microsoft, blogs, technet, download, kba, best practices, x64, testing, begin

SQL Server MSDTC service - do you need it or not?

Published 11 October 7 7:2 AM | SSQA.net

MSDTC - Microsoft Distributed Transaction Coordinator should be installed (Service up and running) when executing the BEGIN DISTRIBUTED TRANSACTION statement that controls the completion of the transaction. So to complete this transaction with a subsequent...

Filed under: sql server, services, kba, transaction, clustering, msdtc, servers, end, begin