InvoluntaryDBA (2/24/2010)

---

I guess I missed some detail in my post. This table is a history table we created to track changes to data. So data never gets updated, only inserted...

I find that this is one of the most mis-understood concepts in SQL Server. The belief is that because you have an auto-incrementing key, you will never have fragmentation...

In order for you to be able to use the WITH MOVE option, you are going to have to know the logical names of all of the files for that...

I would recommend using Powershell and SQLCMD - with powershell you can parse a directory for the latest file(s) by date, and build a string to execute the restore that...

When you make that change in the GUI - it performs an index rebuild with the fillfactor defined as 75%. The only way to change the fillfactor on an...

sunil.aggi (2/24/2010)

---

Thank you for your reply Jeffrey.

However my question is with regards to SQL 2005.

My .ldf file size is growing and is crossing its threadshold limits. Now I need to...

All that command does is sets the default fill factor that will be used when indexes are created and the fillfactor is not specified.

When indexes are rebuilt - the fillfactor...

Are you sure your transaction log backups are running? If so, then most likely you have a nightly/weekly operation to rebuild indexes that is expanding the log file. ...

I am not sure where you got your information - but it is not correct.

First, that backup command is deprecated and no longer works in SQL Server 2008....

Is this x64 system?

If so, have you set max memory?

How much memory is available to the system?

If you have 24GB of memory available - you should be setting the max...

I quoted your statement, and I questioned your statement about shrinking databases on a routine basis. If you do not shrink your databases on a routine basis - then...

jpSQLDude (2/22/2010)

---

Also, as I see it, I have three options for backups:

1. Come up with TWO systems, one for versions 7 and 2000, and a different one for 2005 and...

Welsh Corgi (2/21/2010)

---

Jeff,

I should have been more clear and I agree with you. 🙂

I never setup a maintenance task to shrink a Data or Log File. I would...

I don't see any other way - you have to create the user(s) in the database before you can assign any permissions to the user.

jaroho (2/21/2010)

---

I am not using a single account to authenticate users.

All i want is, no one should modify or run queries from the backend.

All modifications should be done from the...