polasabhushan (6/20/2011)

---

Thank you both "Grant Fritchey" and "Brandie Tarvin" for your valuable suggestions.

I have not found anything on errorlog , probably not sure where to look and what to look....

Agile development, when done correctly, is one of the most disciplined approaches to development I've ever seen. Yes, designing the database without complete requirements can be difficult, but in general,...

Functions like that on your columns is going to lead to scans. Period. You can't get around it. I would not recommend that approach. As you add data to the...

You might want to make a case for upgrading to 2008. Then you can turn on optimize for ad hoc workload which will only store plan stubs for the first...

I suspect some other processes are being run. Have you checked all scheduling to validate all the jobs that are run against the server? Have you checked to see if...

Nope. If you're hitting the limit, you're hitting the limit. No way around it. You either have to dump data or you have to purchase a licensed copy of the...

iancadwallader (6/20/2011)

---

Hi Jeff

Thanks for this, and yes I agree its not the best way to be doing things.

The idea really behind it is that the helpdesk system being incorporated could...

Jeff, I'd never admonish you... much.

However, in this case, I agree, but only to a point. JOIN order does matter, and your choice of JOIN order, especially on more complex...

blake colson-405790 (6/17/2011)

---

Check out Benjamin Nevarez if you're still pursuing this. I had several exchanges with him a while back about how calculations were derived by the optimizer. ...

WayneS (6/15/2011)

---

I've been doing some research into how temporary tables work in SQL Azure, and I have a few questions that I can't find answers for.

My questions:

1. Can you build...

george sibbald (6/17/2011)

---

Grant Fritchey (6/17/2011)

---

george sibbald (6/17/2011)

---

cheers guys, not too far off my views, though I am not sure about security admin.

Gus, SA in dev, really? Should that ever be...

george sibbald (6/17/2011)

---

cheers guys, not too far off my views, though I am not sure about security admin.

Gus, SA in dev, really? Should that ever be a necessity?

any more for...

Sandbox - Everything, sa

Shared Environment - generally ddl_admin, security_admin, data_reader, data_writer...

End time you're only going to get by inference. If you check for the lock regularly and it's gone, that's when it ended.

Start time on a lock is pretty easy...

There's blocking or resource contention or something. I'd start working off of wait states. If you can see the processes as they're running, what are they waiting on? If you...