So, is it normal for a t-log to be over 10GB even though you are doing a t-log backup? If so, is there a way to manage the t-log...

Grant Fritchey (8/18/2011)

---

EjSQLme (8/18/2011)

---

Grant Fritchey (8/17/2011)

---

The size of the transaction log is usually reflective of the size of the transactions. Have you tried monitoring the freespace in the tran log...

Jeff Moden (8/18/2011)

---

Just in case you don't know... even though you're doing constant backups on the T-Log file during maintenance, IIRC, the TLog file will still grow to about 1.5...

Grant Fritchey (8/17/2011)

---

The size of the transaction log is usually reflective of the size of the transactions. Have you tried monitoring the freespace in the tran log during the index...

Thanks for the article; it is a nice article. I went through, but as the article indicated,...

Perry, thank you for the instruction. I'll try that and report back the results.

I want to move all...

I just looked at it, but not sure how? How would the file system task help me?

Thanks, that worked

select *

from table

where (location IN ('1234', '2456', '4567', '4567')

OR location LIKE '90%')

I got you... Thank you for your help!

The middle date part I mean the time in the middle on the same date. As I indicated on my example, there are about four the same dates with...

Very nice! Thank you.

If you do: select * from #EETime order by PersonID the last column is code, which is not part of the StartTime and EndTime.

TimeID ...

Hey Craig this was very slick and complex (not sure what you did in the case statement)... thanks.

How would I add the codes in this query. For...

This is the DDL, but didn't know where to go after that with the below code:

CREATE TABLE #EETime

(TimeID ...