1. begin transaction

2. set statistics time, io on

3. select t.N from util.dbo.Tally1K (a 1000-row tally table available to everyone)

4. dateadd(day, 0, datediff(day, 0, getdate())) --many times on a column instead

5....

Jeff Moden (8/22/2015)

---

Ed Wagner (8/21/2015)

---

If you haven't downloaded Grant's book on execution plans, I would do it. It's an excellent book that explains a lot of things and it...

Yes, I'd like to see if one of the guesses was right or if it was something else.

Peaches

A pretty easy way to start the week, but I'm sure some of us are still a bit tired from the weekend.

rajeshjaiswalraj (8/21/2015)

---

Thank you for your reply.

My database mail was stooped working from 19th.

When I ran given code by you. I got below result. Please help me on this..

The mail...

It's really too bad if the security training is more about legal garbage than about teaching people how to do things properly. Maybe, just maybe, if it were about...

If you haven't downloaded Grant's book on execution plans, I would do it. It's an excellent book that explains a lot of things and it would give you good...

Jeff Moden (8/21/2015)

---

lgluna20 (8/21/2015)

---

Hello

Thanks you very much for your answer

Sorry in case of the questions number 3 I was not clear about it.

Basically as you know SQL Server...

I've found the database mail system to be pretty reliable, so you have to ask yourself what changed between the time it was working and the time it stopped working....

I'm glad it's helpful, but did you figure out the answer to your original question?

Politics

Counter

Luis Cazares (8/21/2015)

---

Are you looking in the server or your personal computer? Are they the same or different machines?

Remember that those are local paths for the server but might not...

So you're currently in the master database. That's the file the system looks at to find the file, so that's where it should be.

Also, if you have permission to...