I think this is the normal scenario of blocking and once either process id completes the update it release the lock. Might be the lock/block is temporary here.

As profiler...

Are you using FILESTREAM?

What datatype are you using for 'File Name'?

In addition to Koen; you can also drop all constrains on the destination table if no. of rows are more which will expedite the process. Once SSIS is done you...

Following are the extract from the BOL:

To determine whether a package exists in the local file system, use the following syntax:

dtutil /FILE c:\srcPackage.dtsx /EXISTS

To determine whether a package exists in...

Very interesting question, Thanks!

Also one can try restarting sql server (test only) and execute the query it will give you 0 record and later 5 rows.

Can you provide detail or technical link for 3D joins in 2014?

Does your maintenance run at this time?

Refer following link:

http://technet.microsoft.com/en-us/library/ms175527(v=sql.105).aspx

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/dceea24c-7a53-4450-94cd-8327b5daa759/what-is-the-best-practice-for-configuring-tempdb?forum=sqldatabaseengine

HTH

As far as I know if you do have different set of LUNS assigned to different drives than it will be useful; else even though you do have different drives...

Is it possible to run DBCC CHECKTABLE on which you feel that table having index related error. Also it would be good if you can run DBCC CHECKDB to make...

I have executed in SQL 2012 and got the...

+1

Day by day QotD becomes difficult.

While executing update we didn't receive any result set; we got message only!!!

I guess there is difference it result set and message.

Usually I do not change default setting of system databases.

About user database based on the db size and data growth you can set auto growth option but I suggest...