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 [...]
Category Archives: SQL Server Limits
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 [...]
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 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 [...]