Browse by Tags

• 3gb
• awe
• database
• dba
• enterprise
• evaluation
• find
• install
• instances
• memory
• multiple
• pae
• performance
• security
• server
• services
• SQL Server
• sqlclr
• sqlcmd
• uninstall
• update
• upgrade
• windows
• x64

• Problem with migrating database from a SQL Server Evaluation edition to a purchased version

  During a user group meeting one of the user asked that If we were to migrate our databases over to the evaluation edition of SQL Server 2005, is there a way of upgrading to the purchased (licensed) version (before the 180 day expires) without uninstalling Read More... Posted Friday, August 31, 2007 8:25 PM from SSQA.net | (Comments Off) Filed under: SQL Server, edition, database, update, upgrade, evaluation, uninstall, install

• How many DBAs you need to manage show in multi-server environment?

  This sounds like a joke that "How many DBAs you need to change a light bulb?". I have come across this less technical question from SSP forum asking for recommended practices. They wanted to have information that How many servers should be managed by Read More... Posted Friday, August 31, 2007 8:24 AM from SSQA.net | (Comments Off) Filed under: SQL Server, edition, server, services, dba, multiple

• More than 3GB memory is not used even though boot.ini has these switches on /3GB /PAE /AWE.

  Yet another AWE memory settings blog post here that I'm posting for the issues we have had recently. Before going into details review about 3GBPAE blurb here and also refer to this KBA274750 to enable more than 2GB memory within your SQL Server Enterprise Read More... Posted Thursday, August 23, 2007 7:33 PM from SSQA.net | (Comments Off) Filed under: security, SQL Server, performance, edition, awe, pae, memory, windows, instances, 3gb, enterprise

• How to find whether Sql Server 2005 x86 is installed or x64 is installed?

  Say you have multiple instances of SQL Server and on mixed platforms such as 32 bit and X64 bit platforms, so how do you find which version of SQL you have installed. If you are well versed with the environment then by looking at the servernames you can Read More... Posted Monday, July 30, 2007 12:36 AM from SSQA.net | (Comments Off) Filed under: SQL Server, edition, x64, find, sqlclr, sqlcmd