• SQL SERVER 2005 MAINTENANCE PLAN PROBLEM

    HI, SQL2K5 Maintenance plan does not delete old backups even when 'backups older than 1 days' is selected.so my backups are piling up and have to remove them manulally everyday. any solution? Marshall

    Marshall01275 pointsBadges:
  • Tuning a simple SQL statement in SQL Server 2005

    How would I tune a simple SQL statement, like "SELECT @eno = eno FROM emp WHERE dno = @dno," in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Running a performance baseline trace on a SQL server

    When you are running a performance baseline trace on a SQL server, how long do you typically run the trace? Or, do you run multiple traces at various times of the day?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Implementing indexed views on a SQL Server

    How can I implement indexed views on our SQL Server? Is there an example that shows how they would improve query performance?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2000 (Performance Trace)

    Hi All, I have a job which is running since last 6 months. The job was taking around 2-3 hrs to be completed. However, for the last couple of weeks, its taking more than required time (Max-26 hours)and we have to kill the job for users to acces the database. I am not able to find any clue to it. I...

    Bakash0 pointsBadges:
  • Improving I/O performance on SQL Server 2000

    I have SQL Server 2000 SP4 running on an Intel Xeon 2.33 GHz CPU with a 2GB RAM server. We have a total of eight workstations connected to this server, and Performance Monitoring says that the Avg. Disk Queue Length is at about 20 when all users are working concurrently. My tempdb logs are at 500MB...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL server – Stocks Data -How to Push Data To Client Application

    My client application providing real time stock quotes takes data using a xml webservice which pulls data from sql server 2005.with number of clients increasing for same piece of data, the sql server is being queried again and again.Is there a way to push data from sql 2005 to client application...

    Rak9995 pointsBadges:
  • sql server 2005 slow

    Several times during the day SQL Server 2005 Express is becoming very very slow (actually freezes), even if there was no activitry at all. After restart it is normal again for a couple of hours, then freezes again.

    Vad20 pointsBadges:
  • Slowdown on a server running SQL Server 2000 and Windows Server 2003

    I have a server with SQL Server 2000 SP4 and Windows Server 2003 Standard Edition SP1 that runs SAP Business One. The server's specs are: ML350G5 XEON 2.0DC 4GB RAM 6 UNITS SAS 72GB C:=>Raid 1+0, D:=>DATA Files, E:LOG files, F:TempDB files Swith Hub: 3COM 2924 SFP plus 3COM 4210 Cable: CAT5E...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Allowing SQL Server 2000 Enterprise Edition to utilize free physical memory

    I have two identical SQL Server 2000 Enterprise Editions running on Windows 2003 Enterprise servers. They both have 8GB of RAM with /PAW and /3GB switches configured. The max server memory is set to 7GB on both. On one of the servers, the available physical memory under Task Manager Is always...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Dealing with a hyperactive SQL Server

    On occassion, our SQL Server goes hyper - 100% disk activity with I/O queues. It happens only once a year, lasts for a couple of days and then stops. We have our database administration staff look at it, but we have no real idea what the cause is. Can you suggest a direction or idea?

    SQL Server Ask the Experts2,585 pointsBadges:
  • disk activity is running at 100%

    24 hrs ago disk i/o and activity shot up to 100* with quues grwoing. our average i/o queue is normally around zero with disk activity at <15% we have had this before - lasts a couple of days and then stops. we have never found out why? can anyone help?

    Salmonthefish5 pointsBadges:
  • Flush the query plan from the RAM.

    Our clients are reporting that the sql server is slowing down over a period of time. Once the SQL Server is restarted everything is fine.SQL server slowing down over a period of time though has technical reasons. SQL server caches (in memory) the queries that are sent it to, expecting to reuse it...

    MNA20 pointsBadges:
  • Upgrade to SQL Server 2005 resulted in 100% CPU utilization and application timeout error

    My server is DL580 running on Intel Xeon Dual core Dual CPU. I have recently migrated from SQL Server 2000 to SQL Server 2005. The server is dying and showing 100% CPU utilization and applications are getting Server Timeout expired error. What can I do?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Can SQL Server 2003 provide CPU usage information by application?

    I have a Windows Server 2003 Service Pack 1 (SP1) machine and need to find out how much of the central processing unit (CPU) each application is using. I am familiar with task list for Windows XP, but the only task list I see on the Windows 2003 machine is a command line tool and it does not...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server – I would like a stored procedure that will take the name of a table as input.

    I would like a stored procedure that will take the name of a table as input. What the procedure would do is drop all indexes on that table except any index that ends with U1 or P1, and save the information on the ones it drops. Then I would like another stored procedure that takes a table name as...

    SQL Server Ask the Experts2,585 pointsBadges:

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