The trial version of SQL Server is called Evaluation Edition, it has the features of Enterprise edition. You can download it from the Microsoft site.

Is the database going to grow again? If not, if you never expect it to get back to the 450GB, then do a once-off shrink. Be sure to leave enough...

That should all be obtainable from sys.dm_db_partition_stats

It's not, because the option only affects the process of rebuilding and has no...

What database context are you running it in?

What database shows Active Transaction as the log_reuse_wait in sys.databases?

That's normal, every single session will have a shared lock on the database it uses and it will hold that lock until the session ends. This is to ensure that...

I suggest you go and make sure you know exactly what it is before you kill it, what it was running and from where. You shouldn't be guessing as to...

Opentran is database-specific, run it in the database that has the growing log. If your log reuse wait is active transaction, then you have an open transaction.

The number of sessions...

Something's leaving a transaction open. Identify who that is (from DBCC OpenTran and sys.dm_exec_sessions) and either commit the transaction or kill the session and let it rollback. Then do some...

If you really do want to release space back to...

Without seeing the procedure, no.

rodjkidd (11/21/2013)

---

Problem here is the business is looking for a "this will make it faster" answer, and I'm saying it could help, we need to run some tests... Oh is...

Maybe. Depends on the query forms

If you find what...

Views can only be single SELECT statements. If you need looping or anything more than SELECT ... then consider a stored procedure.

I don't see an execution plan, I don't see complete index definitions and I only see part of the table definitions. Please read the article I referenced, trying to help...