Case statement is probably what you're looking for, but not enough information to be sure.

All this is in one table? What do you want the model size column to show...

sqlfriends (2/1/2013)

---

SQL Pizza (2/1/2013)

---

Hi sqlfriends,

as you've already learned, memory management in sql server is a very complicated topic. Could you please describe your problem more precise, to give us a...

That was a poor threshold when Microsoft...

No, it means that SQL is ramping up its memory usage.

Which command did you run? The repair? If so, what was the output?

Do you know what those killed sessions were doing and the consequences of killing them?

Blocking: chapter 6 of http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

Stop SQL agent.

ALTER DATABASE msdb SET Single_User WITH ROLLBACK IMMEDIATE

Exec plan without forceplan please, need to see what SQL's doing wrong to help.

Sergiy (2/3/2013)

---

Different story when you apply the WHERE clause.

Because there is no way any index can be used SQL Server needs to build the recordset from the subquery as a...

Considering how many times Seacom has developed faults off the Senegalese coast, sometimes I think they don't.

Robert Davis (2/3/2013)

---

Uwe, if I'm not mistaken, the latency problem for Gail that would prompt her to travel to Europe to do the lab exam is due to issues with...

GilaMonster (2/3/2013)

---

That's an informational message informing you that deleting logins does not delete the associated database users and to complete the delete you have to delete the database users yourself,...

Well that's about 3 times the best...

Missing, no, seriously, majorly overcomplicating, yes. For what you describe you'll need unsafe CLR, elevated permissions on the client computer (so that SQL can talk to the client machine), lots...

Same way. No, just once. The settings...