Well, that's interesting. I just checked and it took awhile for it to show up. There is now 70+ Gig in the primary data file and 40+G in...

PaulB-TheOneAndOnly (5/6/2010)

---

Whisper9999 (5/6/2010)We had a gig or two of free space in the data file before I dropped this table. I then dropped the table and then looked to...

Robert Biddle (5/6/2010)

---

We had a gig or two of free space in the data file before I dropped this table. I then dropped the table and then looked to...

We had a gig or two...

Thx to Paul White. This worked (once I put in the cursor commands from his query):

declare @dbname varchar(100)

declare @dbname_old varchar(100)

declare @sql varchar(4000)

set @dbname_old = ''

declare file_cursor cursor...

Thx. I tried using "LOCAL DYNAMIC" and that didn't fix it, but I am going to try some of the other things you did differently as well.

Below is what I was running. I think it should work because when I replace the "exec(@sql)" with print @sql, it runs through all databases and prints...

Kenneth Langner Jr. (4/30/2010)

---

Here is one that I believe I got off of SSC

-- Create the temp table for further querying

CREATE TABLE #temp(

rec_idint IDENTITY (1, 1),

table_namevarchar(128),

nbr_of_rowsint,

data_spacedecimal(15,2),

index_spacedecimal(15,2),

total_sizedecimal(15,2),

percent_of_dbdecimal(15,12),

db_sizedecimal(15,2))

-- Get all tables, names,...

Scott Coleman (4/30/2010)

---

According to the Microsoft engineers that wrote SQLOS (and were available for questioning at the PASS conference), SQL Server responds to memory pressure by recognizing when available physical...

Thx guys!

You know what's funny is that sometimes in interviews, they will ask q's that they don't themselves know the answer to. They're hoping that someone will solve a thorny...

Guys,

Thx for the many excellent comments.

TheSQLGuru (4/27/2010)

---

Whisper9999 (4/27/2010)

---

TheSQLGuru (4/27/2010)

---

Here's more insight for you: Low PLE simply means pages of data are being removed from the buffer pool so 'fresher' pages can be put in...

TheSQLGuru (4/27/2010)

---

Here's more insight for you: Low PLE simply means pages of data are being removed from the buffer pool so 'fresher' pages can be put in for processing....

bump.

Hoping to get some more insight.