I don't know much about SSIS, but I know that SQL 2014 is not SQL 2008 R2. 🙂

Maybe you should try any of these forums

http://www.sqlservercentral.com/Forums/Forum364-1.aspx

http://www.sqlservercentral.com/Forums/Forum19-1.aspx

I would probably use ALTER DATABASE SET SINGLE_USER WITH ROLLBACK IMMEDIATE followed by setting it back to MULTI_USER instead. Your KILL thing will not work if there are multiple users...

So why don't acquire those skills by rolling up your sleeves and start working. My examples in http://www.sommarskog.se/arrays-in-sql-2008.html should take you some part of the way.

I mean, your skills does...

For instance

SELECT TOP 5 object_name(object_id)

FROM sys.dm_db_index_physical_stats(db_id(), NULL, NULL, NULL, NULL)

WHERE page_count > 1000

AND index_id = 1

ORDER BY avg_fragmentation_in_percent DESC

5 was just a number I grabbed. I...

jerome.morris (8/21/2013)

---

In the end I opted for converting the flat file to csv then bulk inserting into a temp table all Varchar(100). Now this works great from my C# app...

Could you post the exact text of the job step? Please do not mask any names. And please wrap the text in the code tags you see left of the...

When you ran bcp, did you direct output to nul? I made some tests at home, and I see a distinct difference; something like a 40% reduction in time.

I also...

The plan files are indeed very similar. However, I disagree when you say that the query is something simple. I don't see the full query, but I see that there...

EXEC (@dsql) AT linked_server

ASYNC_NETWORK_IO means that SQL Server is waiting for the client to process the data, so the delay is somewhere on the line. For a baseline, I would the BCP operation...

dr.blowfin (8/19/2013)I also have a query about core licensing. If a server is only licensed for 4 cores, but has 8 vCPU's allocated does SQL apply licensing restraints and only...

I guess this is related to the fact that the datetime data type has a resolution of 3.33 ms. I have noticed that when measuring duration with getdate(), that I...

I don't believe you when you say that the query plans are identical.

This article on my web site covers this situation and should get you going: http://www.sommarskog.se/query-plan-mysteries.html.

I think you should first check your license agreement. If it says that upgrades require dbo access, you should give them dbo access. What if you call in a week...

I've...