Viewing 6 posts - 1 through 7 (of 7 total)
I ran the following query to see the progress of the command...
selectT.text, R.Status, R.Command, DatabaseName = db_name(R.database_id)
, R.cpu_time, R.total_elapsed_time, R.percent_complete
fromsys.dm_exec_requests R
cross apply sys.dm_exec_sql_text(R.sql_handle) T
It says 86.43314 percent complete now. ...
May 30, 2015 at 10:33 am
I started the shrink file last night but I forgot to script it and instead just hit the "OK" button. I see the task running in activity monitor. If...
May 30, 2015 at 8:29 am
I guess because I had never used SQL Server before and they sounded odd to me, so I've just always used non-clustered. Sounds like I should reconsider?
Check out the...
May 29, 2015 at 6:26 pm
I don't use any clustered indexes actually... all of mine are non-clustered...
May 29, 2015 at 3:07 pm
Is it just the indexes that get fragmented? If so, can I just drop and recreate them all?
May 29, 2015 at 2:24 pm
152 tables....
But with only 20g free... I don't think I would have room to move the other tables over... The next smallest table is 40g....
May 29, 2015 at 12:58 pm
Viewing 6 posts - 1 through 7 (of 7 total)