At least we are getting somewhere, and now we know that...

  IF (
        (
           ...

So somewhat shy of 3GB?

😎

Something is not right here, my tablet regularly processes two...

In SSMS, run the query, then select all the results and use CTRL+SHIFT+C to copy the results with headers, then in your reply in this forum, click "Insert Code Sample",...

So somewhat shy of 3GB?

😎

Something is not right here, my tablet regularly processes two times that...

Trying to be gentle, not always easy: https://www.sqlservercentral.com/forums/topic/sql-server-specs-question

😎

Poor sod, an accidental DBA victim.

Sure, I'm just not sure what all you need. The text file size is 2995902. and it is around 30 columns. Both servers are running the exact same bulk...

Hi,

I have two different servers that I do a bulk insert on the exact same text file. One will take 3 hours to do a bulk insert on the...

Talking about efficiency, using variables and flow control in T-SQL says "defficiency" by itself.

More appropriate T-SQL statements should look like this:

SELECT @Val1 = case when @Var1=@VarA and @Var1=@VarA and...

Sometimes you have to wonder.

I put together an extract of data for one of our clients for monthly invoicing. It's one of those clients that need to have all...

Can you please post the full DDL for all the tables, including all keys and constraints?

😎

  IF (
        (
            (ABS(SIGN(@Var1-@VarA))) 
...

But that's not from removing a couple of IFs or ANDs (while introducing bugs!).  I still say that such hyper-tuning is actually silly since that time could be spent...

The dumb thing is not asking the question.

The second dumb thing (not applicable here!) is not listening to the answers given by seasoned pros, because you don't like what...

@YSLGuru,

on this forum, as far as I'm concerned, there is no such thing as a dumb question!

😎

The dumb thing is not asking the question.

For fun, here is a Haiku answer

You...

• This reply was modified 4 years, 10 months ago by Eirikur Eiriksson.