Memorial

Control

Ship

Lynn Pettis (9/19/2014)

---

GilaMonster (9/19/2014)

---

Someone's either having the worst day, or is asking interview questions.

Database goes into Restoring mode

Performance tuning it so critical can any one plz figure it out...

Do you know what NOLOCK does? It may be perfectly fine in your situation, but you want to make sure you understand it.

http://www.jasonstrate.com/2012/06/the-side-effect-of-nolock/

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/10/1280.aspx

http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx

HanShi (9/19/2014)

---

GilaMonster (9/19/2014)

---

Someone's either having the worst day, or is asking interview questions.

Database goes into Restoring mode

Performance tuning it so critical can any one plz figure it out urgent...

This will get you a list of the sessions running, including the one you use to run the query.

select r.session_id,

r.blocking_session_id,

r.total_elapsed_time,

...

TomThomson (9/18/2014)

---

Jeff Moden (9/17/2014)

---

Out of context, it looks...

I wouldn't use a maintenance plan either. Write a procedure to backup your databases instead. The log entries for the plans don't generally tell you what the problem...

Sean Lange (9/18/2014)

---

Ed Wagner (9/18/2014)

---

Sean Lange (9/18/2014)

---

Ed Wagner (9/18/2014)

---

Sean Lange (9/17/2014)

---

WayneS (9/17/2014)

---

Sean Lange (9/17/2014)

---

ROFLMAO!!!! I just got a dev ticket to look into a website that was written and deployed...

Sean Lange (9/18/2014)

---

Ed Wagner (9/18/2014)

---

Sean Lange (9/17/2014)

---

WayneS (9/17/2014)

---

Sean Lange (9/17/2014)

---

ROFLMAO!!!! I just got a dev ticket to look into a website that was written and deployed about 3 years before...

Roy Ernest (9/18/2014)

---

Ed Wagner (9/18/2014)

---

Roy Ernest (9/18/2014)

---

Why would SQL Pass want to list the candidates in the order of committee ranking? The slate has been ratified, so it should be...

Roy Ernest (9/18/2014)

---

Why would SQL Pass want to list the candidates in the order of committee ranking? The slate has been ratified, so it should be just the names of...

Jeff Moden (9/18/2014)

---

Grant Fritchey (9/17/2014)

---

Jack Corbett (9/17/2014)

---

Grant Fritchey (9/17/2014)

---

So this is happening[/url]. If any of the Threadizens are inclined to make a blog post (or three) in support,...

I'd say those are right. I also like the one in the forum about not rushing in with a knee-jerk reaction.

The one I would add is a Modenism: ...