You missed a zero

with a thousand separator added your filter was: duration>200 000, so filtering for duration greater than 0.2 seconds

Run Management Studio as the admin user, then connect to SQL as normal.

They're asking for...

With a heap, if you delete all the rows, the only time the pages are deallocated is if the delete took a table lock (by force or by choice iirc)

Safest...

My only difference there would be

DS9...

TRUNCATE, which is what was...

Ed Wagner (11/10/2016)

Heh - Did you direct them to...

I'd take this opportunity to switch from maintenance plans for index rebuilds (which are inefficient and error-prone) to Ola's index maintenance solution (http://ola.hallengren.com/), as well as fixing the other identified...

Um, ok...

To start with, fix that broken caps lock.

I'd start by speaking with SAP, they'll have more insight on what's required to port one of their applications to a different DB...

While...

That's not an upgrade, that's a complete re-write on the new platform.

All tables will need to be re-done with Oracle's data types, all stored procedures, functions and views will need...

Seriously? Why on earth not? Do you want to find out about corruption only after it's too late to fix?

DBCC CheckDB ('<database name>') WITH...

You might have corruption in that DB. When did you last run a successful checkDB?

Since the consequence of making too low a log reservation can be very severe (DB goes SUSPECT if a rollback can't complete), the algorithm that estimates how much space will...