First, sorry about that. I work for Redgate, and Backup Pro has lagged back a bit in development as MS has added many of our features to the native product....

This might help as well: http://www.sqlservercentral.com/blogs/robert_davis/2010/08/13/transferring_2D00_logins_2D00_to_2D00_a_2D00_database_2D00_mirror/

OS errors are typically permission or path errors.

This isn't about SQL, this is the service not being able to find/open the file itself.

Haven't seen one that caters to that topics. Sorry 🙁

Stop auto shrink. No reason to have that enabled.

The memory issue usually means the system has really experienced memory pressure from the workload. I'd say a reboot is a quick...

I don't mind one time jobs, but don't have them delete right away. I want the history and being able to look in the short term.

We had a few one...

There is also this: http://www.sqlservercentral.com/articles/Indexing/68439/

Short answer: with no index(heap), the data is on pages/extents (8 pages). It's written as it comes in. Typically this means every 8 page extent of...

Ed Wagner (2/26/2016)

---

Sean Lange (2/26/2016)

---

Ed Wagner (2/26/2016)

---

Grumpy DBA (2/26/2016)

---

Hugo Kornelis (2/26/2016)

---

Grumpy DBA (2/26/2016)

---

For some unknown reason a terrible song has been stuck in my head each morning this week... Sheena...

BOL does note this will return an error, but the "E" in the chart is very misleading. I'd say this is one of the poorer documentation efforts to not just...

I work with what I have. I don't have a wiki here, nor resources to...

Jeff Moden (2/26/2016)

---

Here's an interesting site by NANPA, the North American Numbering Plan Association.

It contains all of the active NPA/NXX combinations in various files (including one larger file that contains...

Added, and if you'd like to show how to get data from here and analyze..... 😀

Sector7G (2/26/2016)

---

Here's another list for healthcare data. This download contains info for healthcare providers. It includes name, business address, certification (MD, RN, LPN, etc.). The primary key...

That doesn't make sense. Breeds or colors.

How do you decide that item A (Pitbull) becomes Item B (Boxer)? I am guessing you assume that the ID is an order, and...

Good luck, and you are welcome. If you'd like to write up how you to this one thing, protecting this data, we'd love an article.

Steve