Thank you for posting proper DDL and DML so we can see what you see.

For your query needs look up GROUP BY, and the AVG aggregate.

Code re-posted with formatting:

----DDL

CREATE...

wendy elizabeth (3/29/2012)

---

Since I am new to setting up a database on sql server 2008 r2 and creating tables that are referenced by foreign keys, I would like to ask...

How cool! I am wondering whether the Mechanical Turk workflow follows most other groups of humans in IT...where we look to automate the repetitive incrementally over time. I suppose the...

Pete Bishop (3/28/2012)

---

We have a specific security requirement whereby a linked server is permissioned using login mapping. If a user is not in the list of mappings, they can't use...

Lynn Pettis (3/28/2012)

---

opc.three (3/28/2012)

---

I agree with everything that's been said so far in terms of using NT Groups instead of SQL Logins. One item that was not explicitly addressed that...

What are you using to "read the contents of a file into the database" that brings it in as one row per line?

Never seen that error before... relevant? http://stackoverflow.com/questions/7898169/ssis-error-failed-to-set-the-xml-persistence-events-property-for-the-data-flow

vs.satheesh (3/28/2012)

---

Its returned this result

DBCC SHRINKDATABASE(iedb, NOTRUNCATE);

19 1 17579232 128 ...

In order to survive you need to know one thing: are there valid backups? And by valid I mean, can they be restored? Along the line of backups, you could...

The only way I know is to try accessing the file in a try/catch and if you catch a file access exception sleep for 5 seconds before trying again. Using...

Obit? Hopefully it does not come to that! 😛

If you get shot down on hardware for the second server know that you can replicate or log ship to different instances...

That's a lot of data, but I'll second what Jeff said, a second server to migrate to would be my ideal choice.

It was extenuating circumstances, but I have used...

General question, so general answer...generally speaking all connections to SQL Server cause network traffic, provided you are not accessing SQL Server from the server on which SQL Server is hosted.

What...

I agree with everything that's been said so far in terms of using NT Groups instead of SQL Logins. One item that was not explicitly addressed that you mentioned is...

GilaMonster (3/28/2012)

---

Neither do I. What I do is log index fragmentation and...