Viewing 15 posts - 2,356 through 2,370 (of 2,497 total)
If you are running W2000 or W2003 enterprise edition, use the /3GB switch in boot.ini. This will restrict Windows to using 1GB, leaving 2GB for SQL and other applications on...
February 24, 2005 at 3:12 am
We have integrated security running under AD with no current issues.
You need to make sure SQL services are running under a domain account and that account has to have Windows...
February 11, 2005 at 4:17 am
It has been a while since I last did this, but my recollection is that after issueing the ALTER DATABASE tempdb REMOVE FILE you get a message saying that the...
February 9, 2005 at 5:09 am
You just need the following:
FROM
dbo.OccMain ocm
INNER JOIN dbo.OccMalignant omg ON ocm.AilmentID = omg.AilmentID
LEFT JOIN dbo.CodeLookUp c ON c.Code=omg.SentNode
February 7, 2005 at 3:13 am
The security model used in SQL2000 to manage SQL Agent jobs is very limited.
A user who is not a Syadmin can only manage jobs they own.
A user who is a Sysadmin...
February 7, 2005 at 3:11 am
I doubt if Microsoft would be interested in giving free consultancy for a 400GB database, as this is well within SQL Server's capabilities. However, if you are struggling with how to...
February 2, 2005 at 7:07 am
If you are using dynamic disks then you are likely to have problems in what you are doing.
Each server has its own Windows (i.e. Access-format) database of information about dynamic...
February 2, 2005 at 6:55 am
I echo what has been said about removing autoshrink. This is a performance killer. Also make sure autoshrink is off on Tempdb.
You also need to avoid autogrowing your databases if...
February 2, 2005 at 6:41 am
Make sure you have security mode set to Windows only. Mixed mode authentication is inherently less secure.
Using Windows only authentication means no-one can connect using the sa account, even if they...
February 2, 2005 at 6:31 am
Unless you use ORDER BY in your query, the last row presented in any display may not be the most recently crated row in the table.
Therefore if you care about the...
February 2, 2005 at 6:26 am
This is almost certainly a Windows network authentication problem.
You will need to talk to your Infrastructure people to find out if you have authority to connect to the server from your...
January 31, 2005 at 4:10 am
According to MS, if you have SQL2000 Enterprise installed, you can have as many additional instances as you want for no extra license fee.
January 25, 2005 at 6:00 am
You need the /PAE switch in your BOOT.INI. Without this, Windows will ignore everything above the 4GB line.
The MS KB articles are a bit ambiguous about the need for /PAE...
January 25, 2005 at 5:52 am
You should benchmark performance before and after making these changes.
If you have your data split into multiple filegroups and files, SQL will start an i-o stream for each file. In...
January 21, 2005 at 9:24 am
My understanding is that extended stored procedures will exist in SQL2005, but will be deprecated.
From SQL2005 onwards you will have .Net CLR support directly within SQL Server. This means you...
January 19, 2005 at 4:02 am
Viewing 15 posts - 2,356 through 2,370 (of 2,497 total)