Michael L John (5/18/2015)

---

One of the shortcomings of using the maintenance plan wizard is that it blindly re indexes everything, regardless if the index is fragmented or not.

Subsequently, maintenance...

Thanks for the...

John Mitchell-245523 (5/18/2015)

---

The ALTER INDEX statement that was the deadlock victim will roll back. What happens after that depends on the severity of the error and how your code...

This had occurred to me, but I am not sure of the level of SQL competence of those who use this database...in other words, is the dot notation gonna throw...

Perry Whittle (3/27/2015)

---

certain operations rely on the logical filename but mostly system stuff. It's a good practice to ensure your logical filenames are unique, having 100 databases on the server...

John Mitchell-245523 (3/27/2015)

---

I didn't even know you could do that. Can I ask why you want to, please? I can't think of any problems it would cause, since...

Hey, thanks very much for this. I never knew, but I do now. Since it only came to my attention some 5 days later, whomever it was probably...

Pardon my ignorance (I'm still learning) but what is the "default trace", or...

Gratzi sir....

May I ask you where this permission granted as in "GRANT EXECUTE TO TESTROLE" is enumerated?

Bingo, and thank you!

Still learning as my duties allow 😉

Perry Whittle (11/21/2014)

---

Once TDE is enabled in the database all backups will be dependant upon...

homebrew01 (7/7/2014)

---

Do some practice restores to another location. You can use the GUI to get all the settings in place, then "script to new query window".

This will show you the...

GilaMonster (7/7/2014)

---

It doesn't matter if they run simultaneously.

If you really don't want the full & diff to run at the same time (only one that makes sense to worry about),...

humbleDBA (3/17/2014)

---

Siberian Khatru (3/14/2014)

---

humbleDBA (3/14/2014)

---

GilaMonster (3/14/2014)

---

Well....

Both delete...