Look at the Books Online entry for either sys.dm_exec_requests or sys.dm_exec_query_stats (or maybe sys.dm_exec_sql_text) as one of them has an example query using the statement offsets.

Kristen-173977 (9/15/2015)

---

john_rowles (9/14/2015)

---

OnTime = COUNT(CASE WHEN AttendanceReason = 0 THEN 1 END),

LatePost = COUNT(CASE WHEN AttendanceReason = 1 THEN 1 END),

PostOut = COUNT(CASE WHEN AttendanceReason = 2 THEN 1 END),

LateNoPost...

Gazareth (9/14/2015)

---

To avoid downtime, it could be possible to add a new logfile on F to each DB , then issue a shrinkfile with emptyfile on the old one; and...

jitendra.padhiyar (9/15/2015)

---

But as its not advisable I am looking for any other options. I suggested to change the recovery model to Full and start T-log backup, but client dont want...

Possibly an index rebuild, thought they're minimally logged in simple,...

stanlyn (9/14/2015)

---

Our databases and tables can easily tell prying eyes what we are up to, what our next product or service will be, and etc, and that we must protect...

Correct. Public (I believe) by default has the 'View any database' permission, so all logins get that by default (all logins are a member of public). You can deny that...

Auto shrink on?

Manual shrink operation after the index rebuild?

ORIGINAL_LOGIN()

Create them a login. Give that login a user in the database they should be allowed to access. Give the user whatever permissions it should have in the database. Give...

Never. The log can't be backed up in simple recovery because the log is marked reusable on checkpoint.

Please take a read through this http://www.sqlservercentral.com/articles/books/94938/ and have a chat with the...

Kristen-173977 (9/14/2015)

---

(we do it differently, setting the source database to READ_ONLY so it is relatively easy to re-mount it if we have a problem with the migration and need to...

First things first.

Taking log backups once a day is a bad idea. It means you're exposed to 24 hours of data loss. If that's tolerable, then you could achieve it...

jasona.work (9/14/2015)

---

So this week, I may be picking up a new server for my home lab...

It's a Craigslist deal, being sold by a business near Detroit...

Dell PowerEdge R900, quad quad-core...

It would, and it is not deprecated.