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

Really late payments and refusal to pay legitimate bills are one of the big warning signs of a company that is about to go bankrupt.

If they're out of money, a...

Ninja's_RGR'us (4/21/2010)

---

Michael Valentine Jones (4/21/2010)

---

Tell them to pay your boss everything they owe him first and you want a $10,000 retainer before starting any work.

That should cut off any further...

Tell them to pay your boss everything they owe him first and you want a $10,000 retainer before starting any work.

That should cut off any further discussion. If they...