Viewing 15 posts - 2,431 through 2,445 (of 2,451 total)
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...
October 24, 2003 at 4:11 am
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...
October 16, 2003 at 3:41 am
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...
October 10, 2003 at 2:50 am
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...
October 1, 2003 at 6:09 am
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...
September 19, 2003 at 3:08 am
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...
September 18, 2003 at 2:20 am
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...
September 17, 2003 at 7:54 am
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.
September 17, 2003 at 6:55 am
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...
September 17, 2003 at 5:14 am
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...
September 17, 2003 at 4:12 am
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...
September 17, 2003 at 4:08 am
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...
August 19, 2003 at 5:35 am
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'...
August 19, 2003 at 5:22 am
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...
August 14, 2003 at 5:13 am
Viewing 15 posts - 2,431 through 2,445 (of 2,451 total)