Viewing 9 posts - 2,416 through 2,424 (of 2,424 total)
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...
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
We run with SQL Logging all logons, and NT auditing set on for most things. There have been a few situations where people have claimed the DBAs 'must have'...
July 3, 2003 at 6:36 am
I just leave MSDB in simple mode, but do a full backup of MSDB shortly after my other backups are finished.
I do transaction log backups of the 'real'...
July 26, 2002 at 8:15 am
A few things to remember...
a) Space may be needed to process the transaction log, as well as database.
SQL Server will always scan the transaction log and to back...
May 27, 2002 at 5:30 am
Viewing 9 posts - 2,416 through 2,424 (of 2,424 total)