If you need a tool for benchmarking or measuring how well your db performs under stress, then SQLStress is a free tool that you can use.

http://www.sqlstress.com/

For actual creation...

Examples of Checksum vs. Hashbytes

Checksum:

DECLARE @guid1 UNIQUEIDENTIFIER ,@guid2 UNIQUEIDENTIFIER

SELECT @guid1 = '3DB7D309-A8F4-47C4-BA90-0CB458B44CB0' , @guid2 = 'EFE7F2C5-19F9-42B9-9C16-21BED41E882B'

SELECT chksum_guid1 = CHECKSUM(@guid1), chksum_guid2 = CHECKSUM(@guid2)

chksum_guid1 = chksum_guid2...

I was initially happy to use it but CHECKSUM; but it does not guarantee uniqueness. Since it is returns an interger value the chances of collisions are a lot higher...

See my blog http://sqlscape.blogspot.com (post: SSIS Execute task failure) for examples.

Use an IF EXISTS for your select statement and at the end assign the value to an output variable.

Thank you.

Nevermind, it does use cached plans.

Found an interesting article that helped answer my question.

http://awanderingmind.com/2011/01/03/entity-framework-from-a-dba-perspective-part-2/

I would also think it is due to the sql server service account not having permissions on the folder. Check the permissions on the folder and see if the SQL...

If you use @paramname then the variable must be declared by the name with the appropriate datatype using the same same @paramname, index pointers 0,1.. may not be used. On...

Could be due to the result set property not being set correctly or also due to the error caused by the statement in the execute SQL task. The task gives...

It could be due to incorrect path in the connection string. If using a relative url try to reproduce the error from local dir.

Working on it.

Although - shouldn't ssis be faster as bulk insert would be much faster than single row inserts?

Example: A full join between Member and Claims (on MemberId in both tables) would give you

1. Members that have claims (Inner)

2. Members with no claims (Left)

3. Claims with missing parent...

SSIS will be much faster in this case. Use lookup transform to find the referenced table columns you need.

Can u send your queries pls.