But she's talking about variables within the query, not parameters. Parameters are sampled by default, variables can only be sampled during a recompile situation. The other issue is, if your...

I'm just referencing the...

The two queries seem to be taking out locks in different orders. On a guess, you have some type of SELECT statement that's part of the procedure UpdatePurchaseOrderWorkQueueStatus that...

It sounds like either the disk is full, or you have a transaction that's so big that it's going to fill the disk and/or the filegroup.

Please don't cross post, it just confuses the discussion. All answers to this link

Check your code. Are you using a function on a column or something along those lines. That might prevent the existing index from being used.

More likely it's suggesting something with...

If the index isn't needed by the data load process, yeah, I'd drop and recreate it. But verify that it's not needed first.

For the most part updating statistics runs in a similar fashion to any other query in the system. The degree of parallelism is set at the system level and SQL...

You'll only see output for the things that return an output from your statements.

Deepak Burkul (7/11/2014)

---

Thank you......

yes this is interview question and i am going to learn more on execution plan of SQL server that time i get this confusion about Physhical Join...

SQLRNNR (7/10/2014)

---

Grant Fritchey (7/10/2014)

---

SQLRNNR (7/10/2014)

---

Grant Fritchey (7/10/2014)

---

I get it. I'm not the brightest bulb in the box, but I can usually understand the logic of processing data most of the...

SQLRNNR (7/10/2014)

---

Grant Fritchey (7/10/2014)

---

I get it. I'm not the brightest bulb in the box, but I can usually understand the logic of processing data most of the time. I'm utterly...

Chowdary's (7/10/2014)

---

Thank Alllllllllllllllllllllllllllllllllll......

I think this is ok for all of us if i say like Thank you all...

But one thing whenever i post a query i get the answers...

I get it. I'm not the brightest bulb in the box, but I can usually understand the logic of processing data most of the time. I'm utterly at a loss...

Without the wild card on the comparison to 'R' you might as well drop the LIKE statement and say <> instead.