August 2007 - Posts

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