mckinnj1 (5/5/2010)

---

I don't believe so.

When we restore the 1 month old BAK file with the ldf file, we get I/O errors when accessing some tables. I am guessing this...

Exciting baseball action:

http://www.philly.com/inquirer/local/philadelphia/20100504_Fan_on_Phils__field_subdued_with_Taser.html

But not as excitiing as this:

http://sports.espn.go.com/mlb/news/story?id=5098407

It's most likely the problem is in the code, not the database.

>>>"He is getting duplicate inserts"

What exactly does that mean?

Giving this a hopeful bump.

where

DateTime >=

-- First Day of Month for yesterdays date

dateadd(mm,datediff(mm,0,dateadd(dd,-1,getdate())),0)and

DateTime <

-- First Day of Next Month for yesterdays date

dateadd(mm,datediff(mm,0,dateadd(dd,-1,getdate()))+1,0)

This should give you what you are after.

Script to analyze table space usage

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61762

Steve Jones - Editor (4/29/2010)

---

Look at that, it does. I hadn't realized that I could get more granular there. However the docs...

I really doubt there is an 800 TB database being managed by someone who has to ask questions here about how to do backups.

hor_netuk (4/29/2010)

---

Steve Jones - Editor (4/29/2010)

---

Also, I'm curious how you are backing up the log every 10 sec. Are you using some external program. AFAIK, jobs to schedule can be...

If you have a lot of unused space reported in tables, run the following command in that database to make sure your space usage is up to date:

exec sp_spaceused @updateusage...

dbowlin (4/27/2010)

---

I find it interesting that you show a picture of a collapsed concrete structure. I was reminded of the recent earthquake in Haiti. A real tragedy. ...

I hate it when people just call a meeting with some cryptic subject line and no agenda or anything that would allow me to prepare for the meeting or decide...

Whisper9999 (4/23/2010)

...I thought that if Sql Server ran out of memory, then it had to page? So if you're not getting paging, then you've got enough in memory,...

Memory paging has very little to do with how much memory SQL Server needs.

Even with a high buffer cache hit ratio, if your Page Life Expectancy is low, you may...

I won't, I have a new,...