Agreed, but this is a test server and if I set the Tempdb to 2GB it will re-size to 2GB. But if I restart the SQL Service it will go...

Hope this helps. I only want row one if row two doesn't exist. The second column is the version number. So if there is a version_number >1 then I don't...

What version of SQL do you have? The query above is correct for SQL 2005 if your running SQL 2000 try this

s.plan_name AS [Name],

s.date_created AS [CreateDate],

s.owner AS [Owner]

FROM

msdb.dbo.sysdbmaintplans AS s

ORDER...

nothing much in the error logs and the tempdb is not set to Auto Shrink. It looks like I just need to run a shrink against it. Should I set...

how would I remove the seconds from the date so it just displays the mm/dd/yyyy?

Yes!!! Thank you

yeah I tried that but I can't figure out how to do it without it summing the db size field

hmmm how would I handle a NULL values?

thanks Ken that worked for me!

Sweet!! that worked. Thanks guys!

I ran the code that Jerry posted

DELETE PW -- COUNT(1)

FROM performance_esx3_workload PW

INNER JOIN performance_sample PS

WHERE PW.sample_id = PS.id

AND PS.sample_time < '2008-07-01'

I get a syntax error

Incorrect syntax near the keyword 'WHERE'

any ideas?

I should'nt have said Truncate, I don't want to remove all the data just older records. I will be deleteing around a 700,000 rows. I'm not sure how the index...

sp_spaceused

name = performance_sample

rows = 11479644

reserved = 1543736 KB

data = 499120 KB

index_size = 1044464 KB

unused = 152 KB

USE [UpTime]

GO

/****** Object: Table [dbo].[performance_sample] Script Date: 10/13/2008 14:23:35 ******/

SET...

I have checked that and the index is just big

Page Fullness = 99.35%

Total fragmentation = 0.01%

Leaf-level rows = 131652200

Maximum row size = 187

Minimum row size = 125

Pages = 2399128