Until the transaction from the first trigger is committed, there will be locks on the table. You can reduce the time of execution by the trigger, change parts of your...

An address in memory, or an address in the file? If it's the address from the file, you track it through the IAM chain, and then track the chain back...

MSPRESS's Inside SQL Server gives a very detailed look at the structure of the data files, and Book's Online goes into some detail on it as well. You can trace...

You simply break your @strSelect into multiple variables, and do the concatenation, like you are, in the exec clause.

Declare @strSelect1 varchar(8000),

@strSelect2 varchar(8000)

Set...

Having been there, done that, my suggestion would be to evaluate the data itself rather than attempting to translate. The mindset and thinking processes between the systems and systems design...

I use Flex Grid Control for similar things, but there are still huge limitations for this purpose. The reason I ended up using it was for the ability to turn...

By using the DatePart T-SQL function, you can return the week number of the year of any date, so there's you a way to work with weeks. As for the...

When the wait type is resource queue, it could be related to any resource the server is currently awaiting. DiskIO, NetworkIO, Processor Time, etc... In your case, I would hazard...

I use the method antares686 suggests as a standard. I haven't found anything more efficient as of yet.....

I agree strongly with antares686.

What is it your really trying to accomplish? Just speeding up your imports?

I wrote an article on these:

http://www.sqlservercentral.com/columnists/ckirkwood/wait_types.asp

You can get textual execution plans by using the showplan options.

SET SHOWPLAN_ALL { ON | OFF }

As far as my time, don't feel bad about it at all. I spend...

In my experience, any time you have a failure in an OBDC connection, every request following it, even if clearing the error, still return errors, until the thread using it...

Now that's great. Really. I have stored procs that rename archive files for me, and have never thought of doing that. (knocks on head) I write code in statement boxes...

That's the transaction overhead I was talking about. One of those "gotcha's" that you just hope your developer's know about up front, for sure. Filegroups are a more evolved way...