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.

Sorts are expensive operations and distinct requires a sort, as do most other methods of removing duplicates from a resuuklt set.

The best 'workaround' is to find out why there...

Depends. How big is your database? How fast does it grow?

You shouldn't ever shrink a database. By doing so you've fragmented all of your indexes. I would strongly suggest you...

Just make sure there's another sysadmin account before doing that.

Why? Quite frankly, as far as I'm concerned,...

What didn't you understand? What I posted is the syntax (as an example) of a grant statement that grants the permission to alter any user in the database Database1 to...