Well, my career progressed from card decks (80 column, then 96 column) and MICR sort machines, then flat files that we had to write sort utilities to reorder, through...

Thanks for the feedback, David.  Really appreciate it.

So it looks to me as if things have changed rather a lot since Jeff wrote the paper, and it would probably be useful if someone could do measurements...

Lordy!  Emergency Surgery?  What on Earth did you swallow this time?  I told you not to put things in your mouth! 😀

Get well soon, Ken... you're definitely one of the...

I don't know when they'll hit the streets but they starting to experiment with graphene-based processors (and other things) that are supposed to use only 1% of the energy as...

p.s.  As Jeffrey Williams pointed out, if you don't have 2017 or better, the FIELDQUOTE  option isn't going to work.  Post back if that's a part of your problem... we...

According to the documentation, several of the "fields" in the data represent up to 10 digits of numeric information.  While the max number of digits for an INT is, indeed,...

Trying to document a process in an event of disaster and different reasons. In case if the database repair attempt is unsuccessful.Do you think listing the steps of recovery...

To be blunt, there is no way in hell I'd give a "normal" user the privs to do anything with roles indirectly never mind directly.  If such functionality is required,...

@cbrammer1219 ,

Asking the question again, WHAT are you using to do the imports and from where?

Hi

Thanks a lot.

I've run your edited query. but its cost was 51% against last improved query that I sent in my last post. And Logical Read grows...

You also have to be aware of transaction log usage - if you import a large file in a single batch you will need at least that much space...

Are you running into any problems right now?

I am not privy to why the "simple act of redefining the column as NOT NULL adds 10 bytes" are "perfectly explainable". Please do. 🙂 I mean the column...

I'd also recommend scripting out the login and all related users in all databases so that when you actually do (and you will sometime) crush a user in such a...