I would tend to index the table on principle but if it is virtually static I would make sure that the index has a very high fill factor.

As you will...

Is this the return of the VIC 20?

quote:

---

SQL Server can run perfectly fine if it's not an administrator on the system.

---

I think...

I think you need to be careful here. Although 15hours to back-up a 30Gb database does sound too long it sounds like the back-up of your SQL Server is...

I used to work on an HP3000 mini computer where the console was the ultimate controller of the mini, then there were administrators and finally users.

There used to be a...

Thanks for your comments.

My concern with "properly" locking down a server, be it SQL, IIS or whatever is where do you learn to do it "properly"?

I've read a...

I don't think the question has a single correct answer. I think this one is a case of "an" answer rather than "the" answer.

Having had to do this for...

From a financial perspective Active/Passive is cheaper as the licensing is for the Active instance.

I would say "Comment the code". If you don't comment your code then you are asking to be nailed to your old projects for life or until you resign....

If you mark a table as pinned then it has little or no affect the first time you carry out an operation after it was pinned. It is the...

On this site ages ago there was someone who was running two low grade servers in a profitable dot com and was getting very good performance out of them because...

quote:

---

what did you do?

---

We had a staging database and a live database. In effect...

The main pitfall that springs to mind is making sure that unique id's on each machine do not overlap and that you have a strategy to cope with replication conflicts...

Although I do use replication a great deal we do have a situation where we use DTS to copy data from one server to another.

You can also use log shipping...

We have looked at sending a newsletter type HTML mail and are looking at the sp_makewebtask and sp_runwebtask stored procedures.

In testing we have used these procedures to generate e-mails as...