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

and add some function to limit the records - such as

where convert(date,mydatecolumn)=convert(date,@red)

what is the date column on the levels table called then ? you didn't post the table structure so we can't really help

but you need to change @reading date to...

remove the single quotes - you have turned your variables in to strings

'@StartDate' should be @StartDate

use a windowing function

try this

Create table demo(x nvarchar(20))

insert into demo values('abc')

insert into demo values('abc')

insert into demo values('abc')

insert into demo values('def')

insert into demo values('jkl')

insert into demo values('jkl')

delete y

from

(select x,ROW_NUMBER()...

i think somebody is giving you missinformation - shrinking the data file will give you fragmentation..... shrinking...

ok - can you run the command

sp_helpdb

against your server and find out what the recovery mode is on that database (its either simple, full or bulk logged)

then run the...

you don't need the group by clause... @readingdate is a variable, not a cloumn

thanks for that - but on other servers we can see the memory being released.... thats what looks unusual

in that case look at the official site

http://www.microsoft.com/learning/en/us/exam.aspx?id=70-432

it lists all of the details you asked - pre-requisites, how to prepare, time limits, number and type of questions

sounds like checkpointing may have stopped - you get that a lot on slow IO when you have large amounts of memory

try the following

USE TEMPDB

GO

CHECKPOINT

if the script takes more than...

as per the link you posted - each socket is one licence.. therefore 1 8-core socket will count as 1 cpu licence

it supports 4 physical sockets , but each socket is allowed to be multi-core

so you can have 4 8-core processors (32 cores) if you want

i just did the same thing for a UDT (as per the original post) rather than a table type and you seem to be able to do it.... possibly because...