It would be interesting to update the article to insert into a table while using minimal logging (i.e. with TABLOCK plus a few other conditions). That should compare more favourably...

That is the only possible solution I can think of, unfortunately we are under resourced and can't do that now. I was hoping for another solution avoiding linked servers.

I won't be copying any data. A .NET application will be calling stored procedures on the DEV database in one instance, and the sprocs are extracts data from the...

Further information - I just tried to add a standard report using emebedded SQL code as a data source, and I get the same error. There is something wrong...

Good one, Jeff - you got me there! While loop indeed. Tsk, Tsk :-).CROSS JOIN would have perhaps been much better, or perhaps you can recommend something better?

And...

You can't use DAC with Object Explorer in SSMS. You can only use a query window with DAC in Management Studio.

Try running SQLCMD locally.

Are you specifying servername...

If you can't connect remotly, or via DAC then try locally on the server itself. If you still can't connect the only thing I can think of is to...

Hi. I agree with the discussion posters to my article that NOLOCK should be used with caution. I attempted to explain this with the followng statement, but perhaps...

ah, from the log not memory...

the txn log is on a seperate drive, and is optimised for performance. only one row was affected, so I would expect the IO...

I ran a select * from the table the trigger belonged to, and the IO for select from the Inserted table in the trigger was the same as the clustered...

I'm having the same issue as Luis. OK, we shouldn't be using triggers but tell that to the VP who bought a third-party system without consulting the DBAs. Even...

Thanks for the comments, Hugo. I missed that link to new features. 🙁 Sorry.

Good point with the downtime. A reboot will take less time than shutting down the...

I don't really care about adverts - I usually just ignore them and focus on the content.

What I do care about is the articles people post, and whether this will...

I've seen companies in the UK and South Africa code nvarchar and ntext variables just for the sake of it, without thinking why, and without any need for them. ...

colin, would an io completion block the entire table? the blocking processes are attempting to take a intent shared lock at the table level.