Well, as I said you have to take log backups, it's not optional (unless you want to run out of disk space). Since you have to take log backups when...

Max server memory limits the buffer pool. SQL can use a small amount of memory in addition to that. If it's using too much, reduce max server memory

For a database to be mirrored, it must be in full recovery model. If you don't take log backups of a database in full recovery, your log will grow until...

That's just a column alias. You could alias the column 'Whatchamacallit' if you like, won't make any difference.

Once you've done a conversion it's a varchar, not a date. Cast (or assign) back to a date datatype and formatting is stripped away. Formatting a date is only relevant...

Dird (2/6/2014)

---

It was an object in tempdb so my assumption is that it would be that local temporary table created/dropped by the procedure because when I try OBJECT_NAME on the...

What resource were the locks on?

By default there are 6 files. You won't be able to delete the active log and to be honest you shouldn't be messing directly with files that SQL works with.

Why...

Don't use Task Manager to check SQL's memory, it lies. The labels on the values are also not as clear as they could be.

If SQL is still using too much...

Evil Kraig F (2/5/2014)

---

DTA is... um... I'll find a polite word for it in a moment, hang on.

....

DTA is a best effort guess from an app to try to help...

Evil Kraig F (2/5/2014)

---

It's only, like, right there in huge letters, and not hidden under a link. I must scroll down more! Yeah, sorry. I disagree with...

That quote was actually from...

Yes they do and either order....

MinhTuCSharper (2/5/2014)

---

So beside .NET and SQL Server, what is the hot MS technical field out there that on high demand, I'm willing to learn whatever MS Technology to get my...

Maybe a server-side trace to identify what's happening.