Viewing 15 posts - 2,476 through 2,490 (of 2,494 total)
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
You should treat MSDE the same as SQL Server as far as fix levels, security setup, etc is concerned. There are many hacks out there that allow you to...
August 4, 2003 at 3:55 am
The following link may be interesting: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B328551
It looks like you can get some blocking within TempDB if TempDB has a lot of pressure from heavy workfile and/or temporary table create...
July 22, 2003 at 3:25 am
Quote: "The maximum (theoretical) size of a database is 1,048,516 TB, and not a single terrabyte as earlier suggested."
Don't forget you can have up to 32768 databases per server. ...
July 9, 2003 at 4:11 am
Viewing 15 posts - 2,476 through 2,490 (of 2,494 total)