This probably won't answer your question directly, but have you update the statistics on the 2005 instance after restoring it? I would start with...
So the one that takes forever is a linked server and maybe an openquery? are you using stored procedures for the crystal report?
Do you really feel that dumps will give you the experience you need to not only hold the MCDBA title but have the skills necessary to do the job...
I'm sure you've seen this link : http://support.microsoft.com/kb/224071 One thing that has gotten me before is changing the path to the new files in...
I would start with this link : http://msdn.microsoft.com/en-us/library/ms137525(SQL.90).aspx Try here :...
If you are doing a full backup the answer is yes. In your situation, having a database that is in simple recovery mode has no bearing on the backup....
It is often suggested that simple recovery not be used for production databases because you are not able to recover the activity since the last...
The view takes up space is something else to manage. My opinion is that you use a view when you can justify it, but don't use it just because you...
The two main reasons that I know of are the size of the drives becomming an issue or disk I/O for active tables. It also appears that all of yours...
From what I've learned the first question to ask is why are you using the view. Is it for security reasons? I'll share a quote I just found which...
I went to Security, Logins, select the login, properties, Database Access tab, select the database, add db_denydatareader for that user and then...
Wouldn't you just change the database role for that user? Which SQL version are you on?
How are you measuring the difference in performance? Are you comparing the Execution plan? CPU Costs? I've found that we gained performance on a...
Have you applied at least SP4? If that doesn't work I guess you could try to reinstall that component.
I don't have extensive experience with this since I'm just now learning 2005 but I did just read the following sentence: "The external program...
Separate names with a comma.
