born2achieve (9/14/2013)

---

i am done with my requirement using below three concepts.

1. using Not In

2. Using Left Join

3.Using Not Exists.

Which one is the best choice to achieve this...

Those two queries are completely different, and the first has a syntax error to boot.

First the syntax error

select * from label

where label.uniqueCode not in (select uniqueCode from...

Maybe possible, maybe not.

You'll need to hack the database back into the server (google for hack attach Paul Randal)

Then, if that's successful, you'll need to see if you can take...

You need to figure out what is causing Windows to issue low memory alerts. SQL will not reduce its memory usage unless Windows tells it to.

The answer to that was to take a tail-log backup before you restored over the damaged database....

There's minimal awareness of the MCSM in industry as it is (which is what you'll get if you pass the 2012 exams, not the older MCM), that awareness is not...

You're looking for something other than SQL allocating memory, probably lots of memory. The memory-based counters and/or the process object and its memory counters for each and every process running.

Your assumption is correct,...

Or could make it worse. 15000 rows locked at the row level is above the threshold...

To be honest, if you're planning to write it I'd say don't bother. You're looking at $3000, assuming passing both the first time (which many people don't), 3 months is...

They wouldn't have reduced memory usage without a lowmem signal from windows, so if SQL is reducing memory usage, there's something outside of SQL allocating and requesting memory and causing...

No.

The snapshot isolations aren't the only things that use versioning. Off the top of my head online index rebuilds use versioning and triggers use the row version store. I know...

Yes. 😀

When windows is under memory pressure and requests SQL to reduce its memory usage.

Do we...