pbyrum (11/24/2009)

---

Hi,

Current version of Backup Exec on the server is 12 rev 1364?

Do you know what version Backup Exec is in the SP3? I can run updates for Symantec...

I would also suggest reading the Articles posted here at SSC. Some articles are geared toward training, while others may be more in-depth. Pick a topic, read an...

Here is a blog a podcast that should get you on your way.

http://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/

GilaMonster (11/24/2009)

---

I assume...

It could very well be a large project. However, it could prove very useful. If it could ensure accurate testing, reduce development time due to an environment more...

Nice Article

Lowell (11/24/2009)

---

we have a third party database on our server, and if an issue is found in thier application, they often need a backup of the database to diagnose.

I simply...

What version of BackupExec? Is BE updated to the latest patch?

Those pieces of information are also necessary to try to find a matching resolution for you.

Thanks for the update. Glad I could be of some help.

Definitely agree with the others - thanks Bob for taking that initiative.

Lemon

http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm

The site has a script and a discussion about it.

I setup some tables with test data based on your query

minor change

, ROW_NUMBER() OVER (Partition by e.emp_code ORDER BY SUM(are2.balance) DESC ) AS [Rank]

This might be a little closer to...

Bob,

Why not make it 3? I can review it too if you want a 3rd set of eyes.

You should be able to manipulate the query to be able to get your desired results.

The idea of the CTE is to make the code more readable and less complex....