I don't remember if my .net version dropdown was blank or 2.0.50727 when I experienced my problem - I suspect I saw it both ways.

Try repairing .net (add/remove programs, scroll...

TRACEY (1/4/2009)

---

Is there a benefit of doing a partition on a table to the different filegroups and this still be on the same disk i.e F

I want to visit this...

Check the asp.net settings in the Reports virtual directory properties, ensure that .net 2 is being used. I hit a problem similar to this recently that required me to...

I believe that it's part of the standard install, unless you need the license server component.

noeld (12/30/2008)

---

I have seen this in the past and the problem is that you are missing info just by looking at the execution plan.

When you use the variable version and...

If a new thread requires the user to select the version / edition and subject area, perhaps that would provoke enough thought that they would get it right - I...

The_SQL_DBA (12/28/2008)

---

RAID 1 Disadvantages:

Highest disk overhead of all RAID types (100%) - inefficient

Typically the RAID function is done by system software, loading the CPU/Server and possibly degrading throughput at high...

Post the execution plans (in .sqlplan form) as a start. If you can also post table definitions and the queries that would help.

I doubt that there is much difference from a performance standpoint ... the raid 1 scenario would presumably require a tiny increase in system resources. Raid 10 would appear...

Why do you want to use service broker rather than a direct copy or extract/import? You need to provide more information on what you are trying to accomplish and...

The only problem I have had is connecting to SSIS 2005 (and I think the same applies to SSAS), so you may still need to install SSMS 2005. If...

Add service broker, which can be set to "auto-fire" procs.

No, sp_recompile should never be required after stats are updated or after a defrag. SQL should automatically detect when stats are stale and recompile as needed, and the defrag...

If you can use truncate then it will always be quicker as it doesn't have to delete (and log) each table individually - the price is that it is not...

If running sp_recompile corrects the problem, I would hazard a guess that they are doing something else significant after the stats are updated. Those changes won't cause the stats...