What are some considerations when creating new columns on tables? (give five or more reasons) What are the advantages and disadvantages of using the smallest data type possible? What is the danger of using “between” for date fields? What happens when you cast Datetime to Smalldatetime data type? How would you improve table insert performance? (give five or more ideas) How would you improve table update performance? (give five or more ideas) How would you improve table delete performance? (give five or more ideas)
