jrestuccio (4/9/2013)

---

Thank you SO MUCH for the replies, I am trying to take it all in.

Let me describe a little bit about why the data is deleted so regularly and...

Kwisatz78 (4/10/2013)

---

Yes thats right I was really just trying to understand the differences between the est. and actual number of rows, and the explanations you have given go some way...

This article by Benjamin Nevarez confirms what @sharky pointed out - if the user isn't the owner of the table or doesn't belong to the sysadmin, db_owner, or db_ddladmin roles...

ggjjbb1983 (4/9/2013)

---

Hi,

Could anyone tell me why the following query is timing out please?

SELECT PLAN_HANDLE FROM SYS.DM_EXEC_PROCEDURE_STATS PS WHERE PS.PLAN_HANDLE = 0x05000A00ED4FE245402231CC000000000000000000000000

If there is a better way to check if a...

Sean Lange (4/9/2013)

---

Interesting question. Unfortunately it is testing our knowledge of a deprecated datatype and its usage in a trigger. Like several others I managed to get it right but...

A few years ago my son asked me to buy him The Unincorporated Man. After he finished it, he gave it to me and we read all four books in...

Why would I want a DML trigger that could succeed or fail independently of the triggering transaction? If the use case is important enough to create a trigger to log...

How did you handle the Lynns, Ashleys, Taylors, and all...

@SixStringSQL, I think this probably has something to do with your use of the TOP 9999 clause and/or the fact that the WHERE clause includes conditions on columns other than...

jasona.work (3/29/2013)

---

SQLRNNR (3/29/2013)

---

jasona.work (3/29/2013)

---

Steve Jones - SSC Editor (3/28/2013)

---

jasona.work (3/28/2013)

---

Anyone thinking of going to see the popcorn movie that is "GIJoe: Retaliation"?

I'm debating between waiting until tomorrow, or going to...

tafountain (3/21/2013)

---

@matt-2 & Sergiy - I'll have to repost a better example. I think the point was missed. The predicate applied by the WHERE clause is not pushed...

I knew about the "window split" feature in SSMS and use it often by clicking Window --> Split, but didn't know about the button. That's helpful! Thanks!

tafountain (3/19/2013)

---

@TheSQLGuru,

Why the developer used ISNULL / CAST - not sure. Didn't make sense to me but even without those the execution plan remains the same. I'm also...

pooya1072 (3/17/2013)

---

GilaMonster (3/16/2013)

---

It means that Management Studio's local intellisense cache...

David.Poole (3/15/2013)

---

I've changed my mind about the existence of superiority of one technology vs another.

If you look at the comments following a ZDNet article there is rabid hatred of Microsoft...