Viewing 15 posts - 2,341 through 2,355 (of 2,491 total)
There were some MDAC issues, as W2003 MDAC is at a higher level than we were migrating from. There were also some problems with a few apps moving from VB6...
March 7, 2005 at 8:00 am
In the statement below from Aaron you should use UNION ALL, not UNION. A UNION on its own ALWAYS forces a sort to remove duplicates regardless of if duplicates actually exist. A...
March 4, 2005 at 7:50 am
If you upgrade your production environment to W2003 before you upgrade Dev, you are asking for downtime.
We had some application coding issues when we upgraded, but these got found and...
March 4, 2005 at 7:37 am
"And honestly, I think an online community can't help you much with this question. That depends on too many factors in your company. And almost always it is a rather...
March 3, 2005 at 3:39 am
My preference is to keep everything under transactional control. This normally means everything in a database, but also allows for MQ (etc) messaging.
If you have mixed flat file and database...
March 3, 2005 at 3:24 am
What DBMSs do you already have in-house? If you only have SQL Server, go with that. The support costs of bringing in anything else will outweigh any other advantages, unless...
March 3, 2005 at 3:08 am
The following partial example only has one pass through your CRM_CFM table, which should perform faster...
SELECT
CASE
WHEN CM_SHURA = 5 THEN RIGHT(CM_SADE,5)
else 0 end as amount1,
CASE
WHEN CM_SHURA = 1 THEN...
February 28, 2005 at 5:34 am
I think this can be done in 1 SQL statement. I suggest you build the statement bit by bit, until you have what you need.
The first stage is probably to...
February 25, 2005 at 4:58 am
It is difficult to tell exactly what you want. I think you should be able to get what you want in one SQL statement.
My suggestion is to build your...
February 25, 2005 at 3:37 am
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
Viewing 15 posts - 2,341 through 2,355 (of 2,491 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy