Browse by Tags

64 bit computing configuration with SQL Server 2005 - what you can take-on?

Published 23 April 8 6:31 PM | SSQA.net

It has been a while in posting X64 related information here, so that comes now about configuration gotchas you may need, for a starter though. X64 computing platforms have become common installations now a days due to the hardware reduced costing and...

Filed under: application, sql server, performance, x64, hardware, computing, sap, compatability, 64-bit

A service pack does not install on a x64-based passive node cluster computer that is running SQL Server 2005

Published 10 February 8 1:7 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications A service pack does not install on a x64-based passive node cluster computer...

Filed under: sql server, kba, x64, clustering, service pack, passive node

FIX: Error message when you run a stored procedure that references a linked server that is linked to the local server itself in SQL Server 2005: "Transaction context in use by another session"

Published 4 February 8 3:1 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: Error message when you run a stored procedure that references a linked server...

Filed under: sql server, kba, x64, 2005, transactions, context, linked server

How to find which types [32bit or 64bit] and versions of SQL Server can be installed?

Published 20 December 7 8:9 AM | SSQA.net

As there are more tools defaulted to 32 bit it is bit confusing for the software applications that will support X64 based installations. IN the same manner it is a common question out in the newsgroups referring to which types and versions of SQL Server...

Filed under: sql server, download, edition, x64, 32 bit, types, ia64

What are advantages of 64-bit system in relation to SQL Server?

Published 19 December 7 8:40 AM | SSQA.net

We have most of our database systems on 64-bit environment, but one of the application user asked the question what is the advantage of a 64-bit environment in relation to SQL Server application. I would say with the evolution of SQL Server 2005 it has...

Filed under: sql server, package, management, microsoft, server, windows, best practices, 2008, consolidation, planning, x64, 2005, advantages, policies

FIX: A federated database server stops responding when you run parallel queries on a multiprocessor computer that uses NUMA architecture in SQL Server 2005

Published 16 December 7 6:57 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: A federated database server stops responding when you run parallel queries...

Filed under: sql server, databases, x64, 2005, multi-processor, parallel queries, numa, federated, architecture

You may receive an error message when a SQL Server 2005 client requests encryption and connects to 127.0.0.1 on a Windows XP-based computer

Published 20 November 7 3:9 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, kba, enterprise, encryption, client, x64, xp, 127.0.0.1

Installing SQL Server Integration Services on 64-bit Computers

Published 19 November 7 8:29 AM | SSQA.net

I had tough time working with Integration Services (SSIS) on one of the 64 bit machine that will be used for a 24/7 based application. So here goes my ranting and things you need to take care when having installation of SQL Server 2005 on 64 bit platform...

Filed under: sql server, microsoft, ssis, download, dts, database mirroring, x64, etl, integration services, compatability, backward

You may receive an error message when you try to export a table by using the SQL Server Import and Export Wizard

Published 18 November 7 3:15 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, error, kba, import, table, x64, wizard, export

List of modified Knowledge Base articles in SQL Server 2005 Enterprise X64 Edition

Published 16 November 7 5:14 PM | SSQA.net

The following pages were recently modified, rather than posting each as a blog post I have included them here: Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: A gradual...

Filed under: sql server, restore, database, kba, service pack2, x64, backups, modified

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

FIX: The process stops responding when you run an SSIS package that contains a Flat File destination in x64 versions of Microsoft SQL Server 2005

Published 7 October 7 7:52 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: The process stops responding when you run an SSIS package that contains...

Filed under: sql server, package, ssis, kba, x64, flat file

Installing SQL Server X64 on a 64-bit Operating System - problem with .NET framework package

Published 12 September 7 9:40 AM | SSQA.net

I have had problem when installing SQL Server 2005 on one of the 64-bit server, the error was: There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information. So as per the message...

Filed under: sql server, package, server, error log, directory, x64, .NET, distributed, client tools

Number of databases limit for Database Mirroring within X64 environment?

Published 30 August 7 5:27 AM | SSQA.net

We have had a request from one of the solutions company stating they have to mirror 15 SQL Servers that are dispersed across the European locations to a central location. For this they have deployed the X64 environment for operating system and SQL Server...

Filed under: sql server, performance, high availability, server, database mirroring, x64, geographic

How to reduce paging of buffer pool memory in the 64-bit version of SQL Server 2005

Published 29 August 7 1:9 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications How to reduce paging of buffer pool memory in the 64-bit version of SQL Server...

Filed under: sql server, memory, kba, x64, buffer pool, paging

SQL Server Express installation on X64 platform?

Published 28 August 7 6:5 AM | SSQA.net

Can we get install SQL Server Express 2005 edition on X64 environment? Yes and No. Yes for SQL Server Express on X64 and EMT64 that too in Windows on Windows ( WOW ), but No it is not supported on IA64 systems. This enhancement is enabled since the service...

Filed under: application, sql server, performance, x64, service pack, platform

The "SQL Server:SSIS Pipeline" performance object does not appear in the "Performance object" list after you install Integration Services from a 64-bit version of SQL Server 2005

Published 25 August 7 4:29 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications The "SQL Server:SSIS Pipeline" performance object does not appear in...

Filed under: sql server, performance, ssis, services, kba, x64, int

FIX: Error message when you run a stored procedure that starts a transaction that contains a Transact-SQL statement in SQL Server 2005: "New request is not allowed to start because it should come with valid transaction descriptor"

Published 23 August 7 6:25 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, kba, transaction, enterprise, x64, stored procedure, tsql

The auto update statistics option, the auto create statistics option, and the Parallelism setting are turned off in the SQL Server 2000 or SQL Server 2005 database instance that hosts the BizTalk Server 2004 or BizTalk Server 2006 BizTalkMsgBoxDB database

Published 23 August 7 6:24 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications...

Filed under: sql server, database, kba, enterprise, x64, statistics, parallelism, biztalk, auto

FIX: Error message when you run a query that is associated with a parallel execution plan in SQL Server 2005: "SQL Server Assertion: File: <lckmgr.cpp>, line=10850 Failed Assertion = 'GetLocalLockPartition () == xactLockInfo->GetLocalLockPart

Published 19 August 7 4:37 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: Error message when you run a query that is...

Filed under: sql server, error, kba, error log, x64, assertion