Make your vioce heard

Vote on Connect here

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=254388

It's still a guess, but my experience (been a teacher for many years) says it's something to do with months, due to the number 12.

OP has not that many questions...

Table variables are bad when comes to parallellism. It seems that parallellism is not used at all when modifying (insert, update or delete) the content of a table variable in...

Back to OP...

I believe he has a table with 12 columns denoting the months of a year.

If this is the case, you can use UNPIVOT to normalise your data on-the-fly.

Thank you for the update.

Thank you for the update.

One thing I think of is fragmentation. I am by no means an expert on SAN, but restores I have done before on local disks have taken much longer than...

This is a case where a cursor might be handy.

DECLAREcurYak CURSOR FOR

SELECTVarBinaryColumn

FROMVeryLargeTable

WHEREDocumentTypeID IN (4, 10, 11, 12, 13)

AND VarBinaryColumn IS NOT NULL

OPEN curYak

FETCHFIRST

FROMcurYak

WHILE @@FETCH_STATUS = 0

BEGIN

UPDATEVeryLargeTable

SETVarBinaryColumn = NULL

WHERECURRENT OF curYak

FETCHNEXT

FROMcurYak

END

CLOSEcurYak

DEALLOCATEcurYak

Or using Express Edition of your database is not that big (less than 4 gb).

Run SQL Profiler to see what SSMS is doing.

For the first part, isn't it just easier to use the "FileName" property of load-component?

I trust the Profiler more too, even if it's an external tool. Or, that's why I trust it.

I have come across situations where the Profiler reported about 100,000 reads and...

There is a Connect issue on this. Pleas vote.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=387322

You can help make a change for the SQL Server by voting for this connect issue here

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=295626

Isn't this simpler?

SELECT*

FROMtblBookings AS b1

INNER JOINtblBookings AS b2 ON b2.ResourceType = b1.ResourceType

AND b2.RoomID b1.RoomID

WHEREb1.StartTime = b1.StartTime