GilaMonster (11/12/2012)

---

Written correctly, just about all the time. Please read that blog post and maybe BoL on how the IN function...

GilaMonster (11/12/2012)

---

Well, those aren't written correctly. The correct form would be

--1

select T1.Col1 from T1

where exists

(select * from T2 where T2.Col1 = T1.Col1)

--2

select T1.Col1 from T1

where T1.Col1 ...

Sean Lange (11/9/2012)

---

I would write that query a little differently. I would instead write it as

select t1.Col1

from Tbl1 t1

join Tbl2 t2 on t1.Col1 = t2.Col2

where t1.Col1 = '52'

That to...

GilaMonster (11/9/2012)

---

SQLSACT (11/9/2012)

---

I'm trying to understand what happens to clean pages in the buffer pool (when a select statement brings pages into the buffer pool).

What happens to the pages once...

capnhector (11/9/2012)

---

SQLSACT (11/9/2012)

---

GilaMonster (11/9/2012)

---

SQLSACT (11/9/2012)

---

I'm trying to understand what happens to clean pages in the buffer pool (when a select statement brings pages into the buffer pool).

What happens to the...

Roland Alexander STL (11/9/2012)

---

Maybe, maybe not. Depends on many factors such as indexing, clustering, number of rows in the tables, etc. Check the execution plan to see what's getting processed...

GilaMonster (11/9/2012)

---

SQLSACT (11/9/2012)

---

I'm trying to understand what happens to clean pages in the buffer pool (when a select statement brings pages into the buffer pool).

What happens to the pages once...

Joie Andrew (11/9/2012)

---

Once a dirty page has been written to disk it is either kept in the buffer pool for further access or it is returned to the free buffer...

Bhuvnesh (11/9/2012)

---

see this

"Dirty" pages are pages where data has been changed but has not yet...

Thanks

Those articles deal with Dirty pages in the buffer pool

I'm trying to understand the behaviour of clean pages in the buffer pool

Thanks

George M Parker (11/7/2012)

---

Thanks for this

Do you know of a way to check if my an instance is experiecing a plan cache bloat? What I mean is, how can I...

George M Parker (11/7/2012)

---

Check out the following: http://www.sqlservercentral.com/Forums/Topic1340744-391-1.aspx

If you order by Virtual_memory_committed_kb, you should see MEMORYCLERK_SQLBUFFERPOOL as the largest consumer of memory.

select * FROM sys.dm_os_memory_clerks

order by Virtual_memory_committed_kb desc

I'm still trying...

George M Parker (11/7/2012)

---

SQLSACT (11/7/2012)

---

kylesway (11/7/2012)

---

CACHESTORE_SQLCP

These are cached SQL statements or batches that aren't in stored procedures, functions and triggers. This includes any dynamic SQL or raw SELECT...

kylesway (11/7/2012)

---

CACHESTORE_SQLCP

These are cached SQL statements or batches that aren't in stored procedures, functions and triggers. This includes any dynamic SQL or raw SELECT statements sent to the...

Thanks