Browse by Tags

All Tags » sql server   (RSS)
SQL Server - 64 bit drivers and issues
01 December 08 12:22 AM | SQL Master | 2 Comments   
SQL Server 64 bit edition, a primer to address the requirements surrounding applications and data are growing in complexity and size. Many applications running on 32-bit platforms today are approaching or have exceeded the limits of the platform, specifically Read More...
Address Windowing Extensions (AWE) requires the 'lock pages in memory' privilege which is not currently present in the access token of the process
21 May 08 02:20 AM | SQL Master | 2 Comments   
The main difference betwen 32 bit and 64 bit server is Memory, you may be aware about 'Lock Page in memory' privilege to be granted to the SQL Server service accout within 32 bit based servers. This is a operating system based privilege that is required Read More...
64 bit computing configuration with SQL Server 2005 - what you can take-on?
23 April 08 04:31 PM | SQL Master | 2 Comments   
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 Read More...
How to find which types [32bit or 64bit] and versions of SQL Server can be installed?
20 December 07 07:09 AM | SQL Master | 2 Comments   
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 Read More...
What are advantages of 64-bit system in relation to SQL Server?
19 December 07 07:40 AM | SQL Master | 2 Comments   
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 Read More...
Installing SQL Server Integration Services on 64-bit Computers
19 November 07 07:29 AM | SQL Master | 2 Comments   
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, Read More...
Installing SQL Server X64 on a 64-bit Operating System - problem with .NET framework package
12 September 07 07:40 AM | SQL Master | 2 Comments   
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 Read More...
Number of databases limit for Database Mirroring within X64 environment?
30 August 07 03:27 AM | SQL Master | 2 Comments   
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 Read More...
SQL Server Express installation on X64 platform?
28 August 07 04:05 AM | SQL Master | 2 Comments   
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 Read More...
32bit vs 64 bit what other factors you need to consider?
14 August 07 06:16 AM | SQL Master | 3 Comments   
Is 64 bit means more memory? Yes, to be precise. Microsoft has been investing heavily on X64 bit and within couple of years there will be no more development on 32-bit applications, as per the recent road map. So within 32-bit application it is one of Read More...
Why 64-bit SQL Server been slow during query performance?
11 August 07 02:34 AM | SQL Master | 3 Comments   
As usual for every performance issue there are many considerations that need to be evaluated when determining how to investigate the root cause for slower performance of many SQL Server databases. I would suggest that an important consideration is whether Read More...
Whats with 64 bit computing on SQL Server
04 August 07 07:41 AM | SQL Master | 2 Comments   
What advantages we took when deployed the 64-bit computing within SQL Server As you aware 64 bit computing with 64-bit processors have become the standard for systems ranging from the most scalable servers to desktop PCs. The way to take full advantage Read More...