A few suggestions:

1) use differential backups - they could help you meet your goal by themselves if your 95% figure is accurate. Schedule periodic full backups at quiet times...

If the machines are the same regarding cpu/memory, all settings at server and database are identical, and the databases are the same then you should get the same results in...

Can you post the plans in .sqlplan (xml) format?

In report server you will have a datasource set up (DataSource1). If you view it's properties in report manager you will see the credentials it is using to connect...

If you can have the original database offline for a period:

1) detach the original database (right click the database in the object explorer and select Tasks -> Detach)

2) copy the...

Being as you only want to keep a small number of the rows(approx 1 in 60) you probably would find it quickest to

a) copy those rows that you want...

If only 1 in 40 are capable enough to answer it and bothered enough to reply, then you have weeded out 39 candidates that you wouldn't want to employ. ...

Certification (or working towards it) is useful in that it will give you some exposure to aspects of SQL that you might never touch otherwise ... service broker, XML, the...

shekihan (11/26/2008)

---

By putting small table first you do assure that if the Query Optimizer (not a Query Analyzer of course) for some reason fails and decides to go your way...

shekihan (11/24/2008)

---

2. Query Optimizer uses statistics heavily to get optimal execution plan and there is no guarantee that statistics are up to date at all the times. So it is...

shekihan (11/24/2008)

---

I was trying to address the same problem "Which JOIN order is better ?" and came to the following conclusion. It IS BETTER when the first table in JOIN...

Are you comfortable enough with Profiler to capture the XML execution plans for the proc (and any statements within it)? They would help you determine which statement was causing...

If the mirror is unavailable then the principal will continue to run if you are not using a witness ... you can set up alerts to notify you when this...

I think you should specify it .... if you start up the app and it attempts to connect to the principal, but failover has already occurred, then it won't know...

It's been a while since I tried this and my memory is hazy, but I believe that when the connection to the principal is made the mirror information is stored...