What is the grouping for which you wish to return average tenure?

It looks your query is returning per-person data, do you need average tenure in addition to this data or...

It would be easier to answer your question if you provided the table schemas involved. See the links in my signature for how to post questions.

Now on to an...

Sure you can add filtering to a table in a report so you only make 1 round trip to the database.

Go to the Table Properties -> Filters Tab, add the...

Can you post the code?

Are you doing any grouping or sorting on the report? Obviously sorting on the report will override any sorting in the dataset, and...

This is the power of XML in that it does allow you some flexibility, but with flexibility many times comes lack of readability and lower performance, as you note. ...

Have you considered replication or database snapshots?

As far as performance, I would think that batching it will have less of an overall impact then triggers. It really depends on...

Taking the backup is really a better way to do it.

But yes your 1st 2 steps will work. Then step 3 on the server would be copy/paste the...

If you take the database offline you can copy the mdf and ldf and then attach them on the next server. Then put the database back on-line. I...

It depends on how much latency your users are willing to have in their reports, how busy your system is, will triggers or a batch process put less load on...

Does it get on the podcast now?

Yamachari (8/15/2008)

---

What is this "training" thing you speak of? I must have had a bad streak of companies. I'm almost entirely self-taught through books, work experience, and of...

fixfox8 (8/15/2008)

---

I have tryed DBCC ShrinkDatabase (filename, filesize), but it gave me previous error. By the way the database is in the SIMPLE recovery model.

As I know if we use...

Jack Corbett (8/15/2008)

---

Doesn't sound like it on this server. Is the msdb database on-line? The only time I have seen a...

Doesn't sound like it on this server. Is the msdb database on-line? The only time I have seen a problem like...

Sounds like a permissions issue. What account is this script running under?