Category Archives: SQL Server Limits

Physical SQL Server Hardware Configuration Planning Questionnaire

A DBA, need to consider the following point in mind, prior to fix Server Hardware Configuration. 1. Is this database designed for Online Transaction Processing (OLTP) or for a decision support system (DSS)? OLTP DSS OLTP and DSS both 2. Select a server platform for your database a. Dell Power edge b. Compaq c. Open [...]

Can I run SQL Server 2005 32 bit on a Windows Server 64 bit ?

YES, we can run SQL Server 32 bit on windows server 64 bit platforms. Will there be any changes required in SQL Server Configuration or application to run SQL Server 32 bit on a Windows Server 64 bit ? NO, no changes are required to run SQL Server 32 bit on a Windows Server 64 [...]

Can I use Profiler on SQL Server Express Edition ?

NO, SQL Server profiler is not supported on Express Edition. Recently, I came across with an incident, where one of my customer, wanted me to monitor SQL Statement on a Express Edition.¬† (Note: A Server, which has SQL Server Express edition installed, doesn’t host the profiler tool). So we have four workarounds available to run [...]

What are the Discontinued Features and Functionalities, which will not be available, in SQL Server Denali (2011)?

What are the features/functionalities, which will be removed in SQL Server Denali ? Denali Database Engine – Discontinued features / functionalities 80 compatibility levels will no longer supported in SQL Server Denali (2011) AWE feature will no more available. Need to use 64-bit OS to support over 4 GB of physical memory. Distributed Management Objects [...]

Can we use Network Drive for SQL Server Database creation?

Can we create SQL Server Database using Network Drives ? Can we use Network Drive for SQL Server Database creation? Can I create SQL Server databases on network drives? Can we Backup and restore using mapped network drive? Can We attach database from files which are hosted Network Drive? Yes, You can create a SQL [...]

Limitation – SQL Server 2008 R2 Express Edition

Maximum Number of CPUs : 1 Maximum Memory Used : 1 GB Maximum Database Size  : 10 GB   More on SQL Server 2008 R2 Express Edition Installation and Options