High LATCH_EX wait
What is LATCH_EX wait? Our LATCH_EX wait are very high, what do I need to look at to fix this?

Answer Question   |  May 3, 2011  6:19 PM
SQL Server, SQL Server 2008, SQL Server Enterprise Edition, SQL Server performance

Should I enable service broker on SQL Server 2008?
I am not too familiar with service broker, should I enable it on all databases on my production server? If yes why?

Answer Question   |  March 23, 2011  7:05 PM
Service Broker, SQL, SQL Server, SQL Server 2008, SQL Server Enterprise Edition

Server Timeout on initial web connection to SQLServer
We run a couple of websites (hosted on different webservers) that connect to an SQL Server. The data was recently moved to another SQL Server (called SQLCLUSTER) and now the first time the site is accessed, it takes over 20 seconds to bring up the page. If I don’t set the Connection Timeout in the [...]

Answer Question   |  January 20, 2011  3:21 AM
SQL Express 2008, SQL Server, SQL Server Enterprise Edition, Web Server, Web server administration

Microsoft SQL Server BCP Utility password
I am executing a Microsoft SQL Server Job that runs a BCP Utility.  The utility loads a table from a file using the ‘in’ argument, a format file and an error file.  I have ‘hard coded’ the user name and password in the command line using the ‘U’ and ‘P’ arguments. I am looking for a [...]

Answer Question   |  November 23, 2010  7:42 PM
BCP Utility, BCP Utility password, SQL Jobs, SQL Server, SQL Server 2005, SQL Server 2005 Enterprise Edition, SQL Server Enterprise Edition

SQL Server 2005 Enterprise Edition SP3 Performance
We have SQL SERVER 2005 SP3 Enterprise 32-bit running on a windows server 2003 Enterprise 32-bit with 32GB of RAM and 8 dual core processors. Our CPU, RAM, and I/O are always through the roof and the application is always running slow. We use AWE for buffer cache the maximum memory is 28GB, the PAGEIOLATCH_SH [...]

Answer Question   |  January 31, 2011  3:27 AM
SQL, SQL performance, SQL Server, SQL Server 2005, SQL Server 2005 SP3, SQL Server Enterprise Edition

Sql Server CAL
I have a Sql Server Enterprise 2005 64X, installed licesed by processor, I what to cut budget so thougt if I change to CAL licensing could save money, but know how to calculate how many users are currently conecting to my server. How can I get this info?

Answer Question   |  May 27, 2010  9:29 PM
SQL, SQL Server, SQL Server CAL licensing, SQL Server Enterprise Edition

SQL 2005 trial version update
I installed SQL 2005 trial version on a production server and the 6 months are almost up. I would like to go to SQL 2008 since I can get a very good deal for it. What options do I have? Can I just upgrade over the trial version or I need to uninstall 2005 and [...]

Answer Question   |  November 10, 2008  7:13 PM
SQL, SQL 2005, SQL 2008, SQL Server Enterprise Edition, SQL Server upgrades

Errors while attempting the mirroring process in SQL Server 2005
I am using SQL Server 2005 Enterprise Edition, and I’m having a problem beginning the mirroring process. I am receiving the error messages: “Alter failed for Database ‘db_muthu’. (Microsoft.SqlServer.Smo)” “An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)” “Database Mirroring Transport is disabled in the endpoint configuration. (Microsoft SQL Server, Error: 1486)” What [...]

Answer Question   |  September 10, 2008  7:33 PM
Mirroring, SQL Server 2005, SQL Server Enterprise Edition, SQL Server errors

Installing SQL Server Enterprise Edition on Windows XP
I have two questions. First, how do I install SQL Server Enterprise Edition on Windows XP? And second, how can I find the SQL password without using an application?

Answer Question   |  June 19, 2008  8:13 PM
Installation, Password, SQL Server Enterprise Edition, SQL Server installation, Windows XP

installing SQL server enterprise edition on XP
how can I install SQL server enterprise edition on windows XP? I know there is a way but I dont know it if some body know it tell me plz

Answer Question   |  June 9, 2008  10:30 AM
SQL Server Enterprise Edition, SQL Server installation, Windows XP

RAID Levels on SAN
When deploying SQL Server 2005 Enterprise whether it is 32-bit or 64-bit versions using a SAN backend, does the Storage Methodologies regarding RAID1 (VRAID1) or RAID5 (VRAID5) change? There are differences of opinions in our organization regarding this issue. From the DBA Standpoint we strive to implement the correct solution using RAID1 or VRAID1 for [...]

Answer Question   |  July 15, 2008  11:13 AM
RAID, RAID 1, RAID 5, SAN, SQL Server 2005, SQL Server Enterprise Edition, VRAID1, VRAID5