Forum Replies Created

Viewing 15 posts - 2,341 through 2,355 (of 2,491 total)

  • RE: sql server 2k on win2000 in development and sql 2K on win 2003 in production?

    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...

  • RE: Need help with tsql syntax

    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...

  • RE: sql server 2k on win2000 in development and sql 2K on win 2003 in production?

    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...

  • RE: Best Database to use with SAP

    "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...

  • RE: BLOBs in Database or File System

    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...

  • RE: Best Database to use with SAP

    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...

  • RE: Subquery Result

    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...

  • RE: PLEASE HELP NEEDED? - with a select avg

    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...

  • RE: Cross tab or CASE ?

    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...

  • RE: About to add some more RAM - things to consider?

    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...

  • RE: Integrated Security failing in AD?

    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...

  • RE: Removing tempdb file

    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...

  • RE: view syntax

    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

  • RE: JOBS - access privilges

    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...

  • RE: DB Limitations in sql server

    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...

Viewing 15 posts - 2,341 through 2,355 (of 2,491 total)