Abu Dina (11/12/2012)

---

Very good! I have much to learn.... 😛

I'm glad you asked about what I'm doing.

Let me try to explain, I have:

1 SQL Server Instance with 25 databases (I...

are you running multiple instances? Also our former server admin had an extra couple of 0's in the max server memory when he first set it up. couple...

mickyT (11/12/2012)

---

As an example

select 'Count IsPrimary', [0], [1]

from (select isprimary, blockid...

every thing in the dynamic sql is correct since the extra...

One thing i do when i need something like these requirements is create a consistent uniquifier using something like ROW_NUMBER() and have the base of my pivot something like this:

SELECT...

it looks like there is an extra minus sign in your query at whereisnull(h.ldatuitdienst, getdate()+1) > pd.eddatum - @DaysMinus -

Other than that with out some sample data it...

what i might do is manually shut down the service then disable the SQL Server service while they do their multiple reboots then once they are done restart and re-enable...

well to generate the table here is a faster and more direct way. it uses a tally table to generate the dates (posted as a cte Tally Table). ...

Bobby Glover (11/10/2012)

---

capnhector (11/9/2012)

---

Bobby Glover (11/9/2012)

---

Praise the lord for this post. I have the same issue 1000 tables 750 are heaps, the wierd thing is they have NON-CLUSTERED PKs in...

these are clean pages. SQL Server only drops pages from the buffer if there is not enough memory (or the server is...

Revenant (11/9/2012)

---

crookj (11/9/2012)

---

JAZZ Master (11/9/2012)

---

anthony.green (11/9/2012)

---

capnhector (11/8/2012)

---

apple built self...

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 pages...

muthyala_51 (11/9/2012)

---

Sorry for the confusion. It doesn't release space to OS, I mean to say free space in the DB increases, when we rebuild PK. Probably the best way to...

Nathan check out my post above yours. the outputed data was demonstrating how the 2 ROW_NUMBER()'s worked together. if you run the actual query it will return the...

sdvandeslunt (11/9/2012)

---

Thanks for the reply. Unfortunately that answer is exactly what I was afraid was the truth. (When you say version you mean SQL server version right, not...