Roy Ernest (10/7/2009)

---

Congrats Lynn. You are a patriot as well. You are letting your offspring go into the army... 🙂 I am not sure how I will take it if...

Can you post the code for your view as well? Are you hardcoding the date parameters?

Haven't tested it, but it is possible the if a Full Backup and Differential Backup start at (or about) the same time, one may block the other until it is...

It depends. Are you getting reports of problems with queries being slow or sow response times in your application(s)? If so, instead of looking at the number of...

Please read the first article I reference below in my signature block regarding asking for assistance. To really help you it would help to have the DDL for the...

Very!! I can't wait to see her on October 15th!!

I'd recommend you read about database mirroring in BOL (Books Online, the SQL Server Help System). That should provide you was some basic knowledge regarding DB Mirroring. After...

IIRC, Index Seeks are better than Index Scans for the most part. If I am wrong, I'm sure someone else will come along and correct me.

Not really. If you need help it would be better to ask for it giving the a complete description instead of in small pieces here and there. I'd...

Jack Corbett (10/7/2009)

---

Lynn Pettis (10/6/2009)

---

RBarryYoung (10/6/2009)

---

Lynn Pettis (10/5/2009)

---

Sorry, but I'd rather be here in person for those events.

I'm taking a 2 week vacation starting next week, and I may or...

I am curious what it is you are trying to accomplish and why you think you need to use a loop to accomplish it?

Steve Jones - Editor (10/6/2009)

---

It's hard to stay in the top 5-10 here since you get points for questions. It seems that we'll have a few people every month answering...

RBarryYoung (10/6/2009)

---

Lynn Pettis (10/5/2009)

---

RBarryYoung (10/5/2009)

---

Woo-hoo! Back in 6th place. 🙂

Now all I need to do is to keep this up for three years... And for at least...

Hari.Sharma (10/6/2009)

---

ramonaraujop (10/5/2009)

---

to do rollback in a right way,

I wrote:

-----------------

BEGIN Tran t1

DROP TABLE T

go

ROLLBACK

GO

----------------

SELECT * FROM T

the Question of the Day was wrong, I guess, so, was completed...

Grant Fritchey (10/6/2009)

---

RBarryYoung (10/5/2009)

---

Woo-hoo! Back in 6th place. 🙂

Now all I need to do is to keep this up for three years... And for at least four...