That would all depend upon what your IO subsystem is capable of...

Paul White NZ (4/7/2010)Heh...so, I hadn't noticed that - I just saw the 2005 reference. Nevertheless, this is the 2005 forum, so maybe other people that read this thread...

Why do you think you need to add another file? Are you having performance issues with the current file? How large is the file now?

Paul White NZ (4/7/2010)

---

USE tempdb;

GO

CREATE TABLE dbo.A (a INT NOT NULL);

CREATE TABLE dbo.B (b INT NOT NULL, c INT NOT NULL);

GO

INSERT dbo.A (a) VALUES (1);

INSERT dbo.B (b, c)...

Phil,

If you use the following, the users will not be able to see anything at all except the objects they have access to:

Deny View Server State To {your user};

Deny View...

CirquedeSQLeil (4/7/2010)

---

Jeffrey Williams-493691 (4/7/2010)

---

If you don't stop right now - I'm going to turn this car around...

If you don't stop right now - I'm going to turn this car around and we will...

GSquared (4/7/2010)

---

It should be based on the expected growth of the database, and on minimizing file fragmentation.

Leaving it at the default 10% is a good way to end up with...

CirquedeSQLeil (4/6/2010)

---

Jeffrey Williams-493691 (4/6/2010)

---

CirquedeSQLeil (4/6/2010)

---

Paul White NZ (4/6/2010)

---

Probably will - though the definition of 'today' varies...;-)

Eight hours of 7^th April 2010...

CirquedeSQLeil (4/6/2010)

---

Down...

If object explorer is showing you that version - and you have disconnected and reconnected, then you did not upgrade the server. You only upgraded the client components.

The server...

Tom.Thomson (4/6/2010)

---

john.arnott (4/6/2010)

---

You know, the first time I played with a computer was in 1966 (it was the Ferranti-Packard Orion II...

Jeff Moden (4/5/2010)Nope... you don't really need to do that if it's a single query that does the inserts into the truncated table.

For the maximum speed, though, I'd maintain "two"...

Use the normal install process - when you have the option to select the Advanced button (bottom right of the form), select that button. Don't change where the program...

Litespeed comes with it's own litespeed maintenance utility for deleting old backup files. Look in the documentation for litespeed on the command line utilities.