You could take a look at this:

http://msdn.microsoft.com/en-us/library/aa964124(SQL.90).aspx

+1 for the Redgate tools. They have saved me tons of hours.

It's sounds like someone has given you a task but not the authority to efficiently complete it.

Try this in escalating order:

1) request temporary access to query the DMV's

2) give...

I believe if you are logged in as 'sa' when you do the move the owner should be sa. Is that an option for you?

Maybe I am missing something here, could someone elaborate on why this is not good in this situation?

I prefer scripting everything I can. I want to know exactly what is happening, no surprises. You can easily port a script to another server if need be or...

If the table has 0 rows in it then why not just drop and recreate it to the size you want?

Tobias Ortmann (9/27/2010)

---

Hi guys,

I'm checking sys.dm_db_index_usage_stats with the script below to find unused and rarley used indexes.

I've many indexes on Indexed Views where [Maintenance Cost] = [Retrieval Usage].

How do you...

Hi James,

Yes it does seem like your query (and ultimately the underlying view) is filling up the log file and the CROSS JOIN is the problem. Is it really needed...

Are they running on different servers?

"Slow performance in a cursor"... I stopped reading here.

Seriously though, this is a little different than what you asked for, but in addition to looking at your sub select you...

Thank you. The code worked great.

I'm still a little confused though as to how doing the Cartesian Product helps here and hoping you or someone can add a little...