As a bit of a sidebar, you can easily test all of this.  Set it up and test it.  You'll remember it for a whole lot longer that way.  And,...

I totally agree with the others.  One of the things I value the most in working with people is "absolute honesty".   One of the keys to is identify how you...

Thanks for the feedback on 2K12, Chris.  And, Eirikur reminded us that you were on a walkabout on Friday.  Sill missed ya, though.

Apologies, Scott.  You're correct.  You were talking only about the non-clustered indexes... but so what?  Same differences.  You're using twice as much disk space for those and for why?  It's...

Ok... I just went and checked on our lovely Jira database.  First, it's only been in operation since the end of April.  There are only 6 people on the QA...

In other words, please read and heed the article at the first link in my signature line below. 😀  It'll really help us help you.

Brian... You've been around for quite...

Yes - with a computed column...

Hey there, Alan... long time no see (like, um.... Friday night, right? :D)

You and I (and Brian above) and a whole lot of others know what these two things are...

"Surprisingly controversial stand"???  What was controversial in the article?

That's a good question and I don't have an...

I'd say it's still better to use 50% just to be safe.  For a non-clus index that is used only to get the clus key to do a lookup,...

While a Calendar table will certainly work, a little (and I do mean very little) math can be used to solve this problem.  Case in point...

            
July 5, 2021 at 3:24 pm
            
#3903593

            
            
                                                
        

Awesome... can you...

If you do a search in the article for the first reference, you'll...

yes invoice id is invoice no

and i use this field to store Purchase ID AND  sales or consume ID

but my issue How to handle transfer from inventory to another...