Thank you Grant. This is definitely good from a discovery & inventory perspective; however my current goal is more so to target performance.

I just dusted off the old SQL Nexus...

Thanks for the response! Yeah I've used some of their material before, quite nice!

Ideally though, trying to also include the O/S. In a way, kind of recreating what a product...

Cody K (4/10/2014)

---

If you run the code regularly, and it fails from time to time, then wrap it in a try/catch block, and in the catch block have it insert...

Well, guess not. Regardless of the + 1 or + 2, I just found an instance where it will still randomly blow up.

It may even be the ending ) -...

Well, removing the +1 does fix it; however then there is a leading white space character.

This code is widely used online in a multitude of threads/blogs, etc.

So, back to working on this and seeing some very odd behavior.

Test #1) EMPTYFILE - left 20gb in the primary file

Test #2) EMPTYFILE - left 24mb in the primary file

Test...

Hey Perry,

Thanks for the response. You can indeed perform an EMPTYFILE on the primary file; however it will end in error as you can't move the system objects, yet it...

With the idea of creating a new db and migrating ... anything better/easier than built-in SSMS functionality and/or RedGate tools?

I don't think EMPTYFILE is a viable route though, after 48 hours, I still have 200+ gb in the file ... that's entirely too long on such a high traffic...

MysteryJimbo (3/12/2014)

---

Correct, it wont redistribute the blob pages to the new files. You...

Thanks for the suggestions Jeremy,

But, rebuilding indexes isn't going to move heaps/blobs though will it?

Perry Whittle (2/25/2014)

---

Adam Bean (2/24/2014)

---

Hey all,

When opening .sql files, I get a connect to database engine prompt every single time. Never had this problem before and not sure when it...

It sure does.

Well, happy to report, that I have fixed it. It was indeed the lack of an SPN for the virtual ... even though I said earlier I put it in,...

Matt Crowley (2/18/2014)

---

Well, I have been using DNS aliases for a while. It has helped me through a number of hardware upgrades. I highly recommend it.

To get through...