you're welcome. good luck.

It sounds like a many to many relationship.

A "resource" can be assigned to many projects.

A "project" can have many resources assigned to it.

You need to create an intersection table with...

PaulB-TheOneAndOnly (7/8/2010)

---

In my experience different database names minimize the chances of expensive - some times catastrofic errors and mistakes happening because somebody got confused.

We do have a naming convention that...

Active - Active

Is when you create a 2nd instance of sql server and the other node as its primary server.

Node1 is running one sql server instance and Node2 is running...

Yes, see the Books Online

Members of the db_ddladmin fixed database role can run any Data Definition Language (DDL) command in a database.

...and the 3rd instance has it's own resources?

Are you installing from the node that the new cluster group is currently running on?

Are you logged in to the server, or is...

--soap box

I think the principle issue with misconceptions is that people are using the Table Designer in Management Studio. They "click" they "key" icon which will create the PK...

Do you have a baseline of when the systems was performing well?

The following is from "Professional SQL Server 2005 Performance Tuning", WROX, Page 50.

Trap these counters to confirm disk bottlenecks:

Avg...

There really aren't any issues with regards to size of the ASPState database, nor the performance. The size stays relatively small. There are "cleanup" jobs that run on...

Yes, it's sloppy.

You should "virtually" delete the child records, as well. You don't want "virtual" orphaned records because it will confuse developers later as well as other users who...

1. Evict the crashed node by logging on to the working cluster node and running "cluster administrator".

2. Rebuild the server and configure clustering on the newly rebuilt node

3....

imani_technology (6/20/2010)

---

I am considering deployment my SSIS package to SQL Server instead of the file system.

Is msdb the only database that you can deploy the package to? ...

I've created fixed-width flat files and what seems to work the best for my purposes is adding a {CR/LF} at the end of the query statement.

+ CHAR(13) + CHAR(10)

Our mainframes...

... and the security settings of the link itself.

How about:

Insert into tblModels (Column1,Column2,Column3,Column4,...)

SELECT

n.COL1, n.COL2, n.COL3, n.COL4, ...

FROM tblReceivedData n

where

NOT EXISTS

(SELECT o.col1, o.col2 from tblModels o

where n.col1 = o.col1

and n.col2 = o.col2)