It always depends on how much data you expect in that table. We can't answer that for you.

http://msdn.microsoft.com/en-us/library/ms187745.aspx

Great advice Jim. Our san creates 1 GB in no time flat > 1 GB / sec IIRC.

BUt I agree, it depends on that actual subsystems.

I'll post a script...

Bingo! Now you won't need us anymore!

Grow by whatever it takes to last for 6-24 months. I wouldn't put a max size unless this db could interfere with something mission critical.

Find the job that pages...

It is impossible that you didn't load that much data in the db that it would make a huge difference???

Congrats, now learn to do it right!

read up on inner join and remove that cursor (worst possible way to code this in sql server)

Yes it means free space... not assigned to anything.

Tempdb doesn,t just grow for the fun of it. Someone set it to that size or it grew there because it...

peter.draper (6/1/2011)

---

Thanks, I've just given this a try and got an error that row_number() is not supported.

I had a look and have found that I actually have server 2000, any...

Did you check the job activity monitor?

Edit, darn habit of opening 10 windows at the same time :w00t:!

Which one is not clear?

SELECT

T.name,

STUFF((

SELECT

...

You can't put the where Rid = 1 in the same scope as the ROW_NUMBER function.

So you have to wrap the select as a derived table (CTE would be fine...

SELECT * FROM (

SELECT *, ROW_NUMBER() OVER (PARTITION BY SKU ORDER BY Date DESC) AS Rid FROM table where part like 'A%') dta WHERE Rid = 1

What about the server collation, tempdb and connection settings?

Just FYI, we had a guy who had autoshrink and autoclose to on which also cause a similar issue (db went in and out recovery without any obvious reason and...