From MSDN

In a heavily loaded system under memory pressure, queries with merge join, sort and bitmap in the query plan can drop the bitmap when the queries do not get...

i dont think , it should be in same database.

Golfer22 (1/1/2013)

---

I understand that change tracking writes changes to "internal tables." Are these in the database that the change tracking is occuring on?

Do internal tables include inserted and deleted...

opc.three (1/1/2013)

---

With the query written this way I can highlight the SELECT statement in the USING clause to see what would be deleted without changing the query or carrying additional...

Duplicate post :alien: please post reply here http://www.sqlservercentral.com/Forums/Topic1401550-392-1.aspx

chandan_jha18 (12/27/2012)

---

in my update statement, the condition is such that the column may get changed from 1 to 2 and next time when update happens that set of data with...

It should be but doesnt...

john 60195 (12/31/2012)

---

One of the problems which I am trying to solve is once a user accesses (checks out) a secific record in a table, I would like all subsequent...

i am...

Luis Cazares (12/28/2012)

---

As others have said, neither CURSORS or WHILE LOOPS are effective. Here's a better solution that might help with this problem. I'm just publishing this to avoid that...

thats why i asked you to use trace when ...

YOu are basically asking about LOck mechanism. in your case when DML operation performs then exclusive locks are used by sql engine and it can get eslcalated from...

burgergetsbored (12/30/2012)

---

What I want to do is only return the visual that has the highest number next to it rather than all of them, am I able to do this...

you can think try this Quest : Spot light . its pretty handy. i have used this.

see http://www.quest.com/spotlight-on-sql-server-enterprise/

gkganeshbe (12/28/2012)

---

It showed the pages count as 10. If we insert data for 8 pages it should use uniform extent. So only 2 extents should be used but it used...