Uh-huh... Sounds like a precursor to spam.

Looking at the Clustered Index for the oeordlin_sql table, I'm a wee bit concerned (especially for insert and update performance) over having the leading column be in the "ultra low...

I do the same as what Anthony posted.

There might be at least one caveat to be aware of.  My disclaimer is that I've not had to try it and I'm...

Our situation appears to be quite a bit different than yours (and no... neither is wrong, IMHO... they're just different because of different business requirements).  My best friend, who is...

I've probably just not had enough coffee yet, Johan, but the data you posted doesn't look like a performance comparison to me.  It looks like measurements from a single run.

I...

Our company uses EF and stored procedures with error handling.  Our standard is to require Try/Catch blocks in all stored procedures. While I agree with Jeff Moden's point in...

Correct.  We never do multiple named instances on a server.  Heh... they still haven't found the body of the last person that tried to do that on our servers. 😀

Instead...

If you are using REORGANIZE on any rowstore index that is fragmenting, STOP IT! PERIOD!.  REORGANIZE does not work like you probably think it works.  It can and...

Count me as one of the people that left because of the changes in the site. I keep coming to read the thread, but with the decline of questions...

I wonder if it was because of the flow change you made in the package or it's because you "re-saved" the package (and I might be using the wrong term...

Thanks for the "Welcome back" Jeff....appreciated.   I doubt that many potential new users of the site would stay around for very long...cos to be honest the site...

That's one...

For us, stored procedures aren't a by-gone era.  Instead, we embrace them.  We tried letting the ORM (whatever  flavor it was over time) do some of the complicated things and...

There is a great deal of misunderstanding about relational DBMSs and you will find a lot of this misunderstanding out there on the internet.

For example, people talk about a ...

Thanks for the "Welcome back" Jeff....appreciated.   I doubt that many potential new users of the site would stay around for very long...cos to be honest the site is beyond...