Viewing 15 posts - 406 through 420 (of 921 total)
quote:
How can I use the mry between 3GB and 4GB for SQL*Server? Or isn't that possible?Edited by - Ludo Bernaerts on 11/25/2003...
November 25, 2003 at 6:53 am
I have seen when the backup file was on another server and there were sporadic network problems.
--Jonathan
Edited by - Jonathan on 11/25/2003 05:00:19 AM
November 25, 2003 at 5:00 am
That's as it should be. The /3GB parameter allows the application (SQL Server) to use up to 3GB of the 4GB that the OS can directly address. That's...
November 25, 2003 at 4:56 am
quote:
Thanks Jonathan, you put me on the right track, i ended up doing a distinct select into a temporary table and then...
November 24, 2003 at 3:07 pm
SELECT CONVERT(char(7),Date_Requested,120), COUNT(*)
FROM Accident_Reg
GROUP BY CONVERT(char(7),Date_Requested,120)
UNION ALL
SELECT 'Total', COUNT(*)
FROM Accident_Reg
If your Date_Requested column contains nulls, then use COUNT(Date_Requested) instead of COUNT(*).
--Jonathan
November 24, 2003 at 2:52 pm
quote:
If you lose a drive on the backup partition it's okay becuase it's just for backups anyway.
November 24, 2003 at 9:50 am
SELECT DISTINCT PARSENAME(ip_address,2)
FROM Workstations
--Jonathan
November 24, 2003 at 9:44 am
The best way is to test with your data and environment. There are too many variables to answer a question like this in an online forum.
November 24, 2003 at 8:52 am
I store IP addresses as four tinyint columns so things like this are easy and no check contraints are required.
Perhaps something like this:
SELECT MIN(IPAddress)
FROM YourTable
GROUP BY...
November 24, 2003 at 8:46 am
How about using NULL as your "wildcard"? That would allow the correct data types for the codes, as you wouldn't need to accomodate a char among numbers as in...
November 24, 2003 at 7:31 am
I agree with Stu; this design is poor. As you're apparently stuck with it, try something like this:
SELECT m.code, ISNULL(c.Code,n.Code), ISNULL(c.Des,n.Des)
FROM Match m LEFT JOIN...
November 24, 2003 at 6:55 am
The Delete Reply function no longer works for me.
--Jonathan
November 24, 2003 at 6:04 am
Three errors here:
November 24, 2003 at 5:53 am
quote:
Well, I do not know for sure how much time it would take to create all statistics, but we really have very...
November 21, 2003 at 3:30 pm
The SQL Server query optimizer does re-order the predicates for best performance; that's one use for statistics. It also expands "<>" operators to sargable operations when possible in SQL...
November 21, 2003 at 3:23 pm
Viewing 15 posts - 406 through 420 (of 921 total)