I've used SQL Backup from Red Gate. I'm currently using Quest tools - LiteSpeed for compressed backups, Spotlight on SQL Server for perf monitoring and reporting, Capacity planner for index...

Thanks Hall of Fame. I thought about using profiler so I will do this today on my test environment while the user creates objets. I have requested a call from...

well that worked, but the quirky thing with the application is this, the user has to have two tables (that the application creates) with the user name as the schema...

I can try to login as them into SSMS, that's a good thought.

Yeah, the application is weird. The user connects to a service, and then the service connects to the...

Sorry for the confusion, I want their default schema to be dbo. BUT, when I change their default schema and they try to create an object, through their application, it...

Thanks for the response! I'm glad to know you've done it - makes me feel a bit better 🙂

I'll post back afterwards to say how it all went in case...

Could be disk latency. I would also check your IO by file in Spotlight, you may be able to pinpoint the process that is holding up the disks.

So glad you got it to work faster!

You may want to index your view on the date of visit and patient id. Subqueries tend to run slower. Is the underlying table indexed - and if it is,...

ugh - was hoping there was some slick unknown method for doing this - hack the lsn and commit it or something.

Yes, I will have to look at re-engineering it....

Try:

SELECT Q1.*, Q2.DrFName

FROM (SELECT Patid, LastName, FirstName, Min(dos) as MinDate, Max(dos) as MaxDate

FROM @VwVisitDetails

GROUP BY Patid, LastName, FirstName) AS Q1

INNER JOIN

(SELECT Patid, LastName, FirstName, Max(dos) as MaxDate, DrFName

FROM...

Recommend benchmarking your performance, showing your decision makers how you can improve performance, and increase customer satisfaction by improving availability.

Slow reporting and other system processes leads to inefficient work -...

that was my thought also - are you using one login to identify the process?

From my experience it is better to have OLTP databases on a faster RAID and OLAP databases on a bigger disk with more redundancy. It seems you are trying to...

Is anything connecting to the file - a service, something you cannot see from SSMS?

-----

I don't know if it would help to visualize how much space is being consumed by...