Peter Daniels comments

Results 5 comments of


                                            Peter Daniels

IndexOptimize: Heap (de)fragmentation

+1. I'm managing a vendor DB with 1400+ heap tables. An option to rebuild heaps would be quite welcome. :)

IndexOptimize: Heap (de)fragmentation

Thanks, @EmilioBoucau . I have also been working on a sproc to help rebuild heaps. It only rebuilds ones that have user scans in the last x # of days...

Find-Module -AllowPrerelease Fails

I recently ran into this issue. After installing the latest PowershellGet and then closing and restarting my posh console, it was cleared up..

Change the SchemaVersions location to another instance

For me, it's important to keep the SchemaVersions (migration log) table in the target DB so it can follow it along if it is copied/moved somewhere. I could see some...

Change the SchemaVersions location to another instance

Ah. Of course. Actually working with an external table or view (ie files) in serverless SQL would be a pretty tricky endeavor indeed. Not impossible, but definitely not simple like...