Our standard is to have a windows domain group holding the DBA accounts, and give this group Sysadmin authority in SQL.  Having done that we delete the BUILTIN/Administrators entry.  We...

In my opinion, SQL batch job security is a total mess. 

If you do not have the SQL Agent proxy account enabled, then only members of sysadmin can run xp_cmdshell. ...

I have moved system databases, but not where replication is involved.  However, I do not see how replication will care where the database files are physically located.  One of the...

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

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

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

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

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

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

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

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

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

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

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

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