80 compatibility can exists on 2008 also. but unless you change the compatibility to 2008 you can not take advantage of new features of 2008.

You can add more files to the file group. Files should be on different drive space. you can shrink the file to empty the file. this will move the data...

You need to identify the procedure(s) which are running slow and the reason for that. Just creating view will not help.

There could be many other ways to address the issue....

may be you are not passing correct number of required parameters while executing the procedure.

yes, file shrink is manual operation.

Recommend you to split the single update statment into multiple by adding appropriate where clause.

Is it giving the right results?

it works fine. not sure why this issue is there at ur end :w00t:

try to shut down the database using command [not using UI].

try using detach and attach [Not much sure about problems if any]

for example -

employee and skill many to many relation-

employee

empId [pk]

empName

Skills

skillId [Pk]

SkillName

EmployeeSkills

EmpId[Pk]

SkillId[Pk]

in any database system many to many relationship can be achieved only using third mapping table.

shrinking is definiely not recommended. If tempdb requires that much of space and if tempdb have emplty space, it will use it. If tempdb log is small and if any...

In my opinion - analyze the CPU requirement of each instance and allocate those many CPU's to each instance.

At any point of time if one instance takes all CPU's...

Cluster is for quick failover for the server. You dont need to worry about logins, DBmail settings, and many other server level settings when you have cluster because it shares...

maintenance plan just helps you to schedule the backups along with other maintenance activities. I dont see any harm if u use maintenance plan for backing up transaction log. I...

I dont think the information you are looking for is stored somewhere in the database.

You can set up auditing or DDL triggers to capture this information.