yes all of them - originally i posted 6 servers, but it's actually 18.. the other 50 or so servers (all win 2008 datacentre with sql 2008 sp3) seem...

exactly!!!

what if you only needed to delete 1%... i was just wondering if there was any specific Windowing issue that you know of (like Jeff's stuff about recursive CTE)

Eugene Elutin (9/6/2012)

---

Are you serious? :w00t:

It is just an EXAMPLE 🙂

So, I've named the table in...

hmmm.... yes, but also alternate solutions might use other resources...

Luis Cazares (9/6/2012)

---

That might be because Eugene already had a #demo table and didn't want to drop ti and create a new one.

You can change the name to #demo.

If you...

a couple of options then

.. is the field in the database a date or datetime field?

.. is your report passing dates in the wrong format ... easy to test...

example 2 wont work -you'll end up with a table called demo1 not demo

eugene... just out of interest... why avoid the windowing???

+1 gail ---- READ THE ARTICLE

simple

2 options

shrink the log or get more disk space (possibly by moving the log or data files) - both of which need access to the server.

ok - you've switched back from sum to average now - so i've modified to do both

think about what you are grouping by ---- you've still got convert(varchar(20)....) in there...

sorry chap , that means the information you have posted is useless... if you don't have access to the server then how are you going to fix it anyway...

ok - so change your grouping and, order by and select to use

DATEPART(hh,mydatecolumn)

i'm sure you can then figure out how to display the date in the query

hold on you said the log file was 80GB????

here is an example

select CONVERT(varchar(20),dateprocessed),COUNT(*) from mydb.dbo.mytable

where convert(date, dateprocessed)=convert(date,getdate())

group by CONVERT(varchar(20),dateprocessed)

order by CONVERT(datetime,CONVERT(varchar(20),dateprocessed)) desc