As a DBA EF is a great job creator just because it can't be worst in terms of performance, it generates huge sql sentences that must be compiled and cached...

Yes the concept is a bit confusing, so I'll try to explain the whole concept.

Any GRANT like gives a specific permission to someone.

Any REVOKE like deletes to someone a previously...

No to use profiler is a good idea...

Try this queries to find where your resources are beeing consumed

LONG RUNNING PROCESS (Processess running "now")

Use master;

IF OBJECT_ID('tempdb..#paso') IS NOT NULL

...

First, an advice, when you use funcions you force SQLServer to run your query in only ONE thread.

CASE is cleaner to read than IIF and supported in more SQLServer versions

Alias...

BCP has the -C option, it converts the non characters datatypes to character datatypes

BCP has the -C option, it converts the non characters datatypes to character datatypes