Nandy (11/20/2008)

---

Hi,

Let me explain the issue, I have written the stored procedure to delete the data from the table based on some certain conditions. To check each row with the...

The system resource database must be in the same place as master. Where did you place the new master database?

Not enough information. If you want help, please give us enough info to help you....

Garadin (11/20/2008)

---

Indeed. The problem at the moment is that I don't really understand how to read execution plans / see the specifics of which might be better for what...

Something like this.

SELECT col1, col2, col3 from

t1 inner join (select col1, col2, col3 from t2) t2 on t1.col1 = t2.col1

I'm not sure I understand what you're doing. Please can you...

Please don't cross post. It just wastes people's time and fragments replies.

No replies to this thread please. Direct replies to

http://www.sqlservercentral.com/Forums/Topic606008-146-1.aspx

Try moving the subquery into the from clause and treating the subquery as a table.

What do the tables look like? What are the indexes?

Test, test, test....

Then read up on DBCC DBREINDEX

Please post in the correct forum from now on.

Databases need free space within them. They're not like word documents where white space is wasted. You should leave a fair amount of free space within the data file. If...

Garadin (11/20/2008)

---

Makes sense. That said, I've read that in certain circumstances, such as IN clauses, it's usually beneficial to add DISTINCT, even if you shouldn't really need it. ...

How do you do what? Rebuild indexes?

Look up ALTER INDEX in books online.

Why are you shrinking the database?

Script out the logins, with their sids and apply that script on the new server, then you can detach and attach the database without the users been orphaned.