1
  • High LATCH_EX wait

    What is LATCH_EX wait? Our LATCH_EX wait is very high. What do I need to look at to fix this?

    Rick Martinez585 pointsBadges:
  • 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....

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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?

    Rick Martinez585 pointsBadges:
  • 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...

    Rick Martinez585 pointsBadges:
  • 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...

    Ajmo25 pointsBadges:
  • 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 method...

    Redwine20 pointsBadges:
  • 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?

    Noyo775 pointsBadges:
  • 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 reinstall 2008. The 2005 is a trial for...

    Alan Dala30 pointsBadges:
  • 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...

    ROWENS07150 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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

    Sazzemokhalef5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following