It's not really a good idea to have a job that Shrinks your database daily., this will cause massive fragmentation and will cause the database to run slowly. You...

I would use 5 seperate databases, rather than instances..

What problems do you expect with one database...

Ahmad Osama (2/5/2009)

---

GilaMonster (2/5/2009)

---

Ahmad Osama (2/5/2009)

---

I have a job to rebuild indexes..this increases the transaction log size....so i...

Okay Thanks,

Without updating the code or updating the data then there is not really much that can be easily done..

toni.sala (2/5/2009)

---

Hello,

We're using SQL Server 2005 as a Microsoft Business Solutions Navision Data Server and we're experiencing several performance problems that we solve in 2 ways:

1) Rebooting the server. We've...

'5.0' will not convert to an integer as it can not interpret the '.0' part, since INT can't handle decimals. Try using Numeric data type but this...

Make sure you also include log file backups

okay then you add this with a aggregate funciton in the select clause

SELECT

CL.ClientID,

GS.CodeDescription AS Specialty,

MAX(AAP.AppointmentDate) as MaxAppointmentDate

FROM

...

Is it only the posted query that is slow, or all queries?

Are you able to post the Actual Execution plan rather than the estimated one?

For the values that are repeating over the rows, such as referral source and speciality then you just add these to the select statement and group by clause.

But for...

SELECT

CL.ClientID,

GS.CodeDescription AS Specialty

FROM

AMSAppointment AAP INNER JOIN AMSAppointmentContact APC

ON APC.SequenceID =...

So you want to group by the ClientId and CodeDescription

Out of the other columns, which ones have values that are not distinct?

Or post a sample of the output of the...

select Distinct

or use Group by and Aggregate functions on the required columns.

if you want specific help then post the query and table structure..

i haven't really used the file system task a lot so may not be much help.

Checking if the file exits with a 'dir' command or something would be the best,...

Were you using a Flat-File Connection ?