My understanding of the theory is:

1) You need to read what BOL says about this

2) You need to be running W2K or above & SQL2K

3) You need to talk to...

If user fred is a member of SYSADMIN, then any object they create will have a default owner of DBO. Also, fred can explicitly create an object with the...

The main problem about increasing transaction log backup frequency to cope with peak loads is that you are imposing a high frequency of log backups when load is low.

We backup...

You can also give your user DDLADMIN authority in TempDB. This will allow a user with only Bulkadmin authority to BCP (etc) into a temporary table.

You then have the...

Looks like Measure Up points are best.

Working on the principle in the documentation that SQL7 can receive replicated data from SQL2K, but SQL2K cannot receive replicated data from SQL7, then...

You almost certainly need the DB2 ODBC driver. These are free in the DB2 install media. You will get better performance if you use a product called 'DB2...

A slightly OT comment on NTFS compression, at least on NT4...

If you copy a file over 2GB over the network to a NTFS compressed folder it is VERY...

I agree that while defrag is running, performance may be bad. This could be a reason to not use auto-defrag products. However, if you run the defrag in...

I may be missing something... why do you think that Windows defrag will be a problem with RAID arrays

All information provided is a personal opinion that may not match reality.

Hopefully some answers to your questions...

a) Any type of disk storage can be fragmented. Fragmentation is a mainly a function of the file system, not the disk. Bad...

The card is really designed to allow Windows-based applications access AS400 resources, especially the DB2 database.

I would echo the opinion that if you want to ignore AS400 resources and just...

The key may be the "Operating system error 33(The process cannot access the file because

another process has locked a portion of the file.)." message.

It would be worthwhile to check...

There are significant reasons for the difference in performance of the following code:

a) WHERE (CodArticolo = @CodArticolo OR @CodArticolo IS NULL)

b) WHERE CodArticolo = CASE WHEN @CodArticolo IS NULL THEN...

I would go for something similar to that given by brokenrulz:

SELECT

o.customerID

,SUM(CASE WHEN o.orderdate < '1997-01-01' THEN 1 ELSE 0 END) AS data_1996

,SUM(CASE WHEN o.orderdate >= '1997-01-01'...

You will need W2K Advanced Server to access over 2GB of memory.

In W2K normal server, it will not object if you use /3GB, etc, but will not give you any...