Eric M Russell (5/2/2016)

---

However, the downside of this architectural approach is that I see a lot of queries written by the application developing teams that (in all fairness by necessity)...

Eric M Russell (5/2/2016)

---

Where I work now, most instances are virtualized and that's the default configuration for all new instances, so we can scale them up if needed. What that...

I recently did stress testing our new hardware, before we migrated our databases to it. I used Ditributed Replay to do the stress test (i.e. replay the workload from our...

Eric M Russell (4/23/2015)

---

If a database architect, IT support, executive, or BI developer needs eleveated permissions to troubleshoot performance issues or run ah-hoc queries in production, you can setup something...

Nowhere/never....

And did you ask what they want to be able to do?

Hi DominantDBA and all others who encountered this problem. For piecemeal restores to work as fast as they are suppose to, you have to backup your filegroups seperately. That way...

Hi Perry, what info exactly do you want? I want to give it to you, but I don't think it's the virtual disk or the VM itself, because other restores...

Hi Jeff, thanks for replying. I don't know how long a full restore on this particular test machine takes, but I suspect longer than 2 hours. The machine is in...

Thanks guys. I will alter the procedure to rebuild the indexes on the newly created partition after the SPLIT.

Sadly, this month's filegroup for the indexes isn't used 🙁 The positive part is that I'm pretty sure it's not the sliding window mechanism.

The partition scheme's and the partition...

Also, from BOL: "after a split operation is performed, there is no longer a designated NEXT USED filegroup"

So, the property NextUsedFileGroup should be empty after the SPLIT has occurred. Didn't...

I figured out where the sliding window procedure goes wrong: it was a typo in the stored procedure, so it could never have worked completely. It was hard to find,...

I wouldn't mind having 40.000 backup files in one directory. But that's me and it doesn't help solving your problem. So I took another look at the script. With the...

ok, I see. You should put the backup's in the same directory. That is what the script is made for. Otherwise you'll have to alter the script. But I strongly...