1. Tally/Numbers Table
2. Tally/Numbers Inline function.
3. Other "Pseudo-Cursors" based on "the...

I agree with Grant...I wouldn't bother with DTA at all.  It is actually possible to get such an error simply because of an overly complex query or a simple looking...

Right now, after you've uploaded (imported) a file to a named table, what do you want done with the file?

Once the files are uploaded, there are there...

Here's the next thing that could be a possibility... Run this code in the database where the table is at.

 SELECT is_read_committed_snapshot_on
   FROM...

Here's the next thing that could be a possibility... Run this code in the database where the table is at.

 SELECT is_read_committed_snapshot_on
   FROM sys.databases 
...

Crud, I went to hit "Reply" on one of the posts above and hit "Report", instead.  I've sent the WebMaster a request to undo that.

In the mean time, I have...

What a great set of "mini-courses" you're in the process of having published! Nicely done! My only question on this one would be... why would you ever teach anyone...

Because you didn't follow the instructions in the write-up for when to round down, your final value of 193MB is off by abou 10MB.  It should have been 183.398438 MB.

That,...

Thanks Jeff

I haven't heard of ACE driver. Is it a tool ? if so, can you share a link please. I am not sure how to use bulk insert...

Unfortunately I dont have the space to test (create a duplicate db/table ), the whole rationale for this exercise is diskspace is full 🙁  , nor can I take...

WHY do you need to do this?

Sorry.  Post removed.  I looked at the code and read it incorrectly.

Heh... I agree with what Kathi said in her good article and what the others have cited in this thread.

I'll also say that Einstein is quoted as having said that...

Hello there, Dillan25.  What's cookin'?  SPAM? 😉

Heh... Phil already knows what...