Today's best practice techniques are
- NOLOCK helps in concurrency and performance but can be dangerous for data integrity
- Use XML datatype to pass table valued parameters to procedures.
- Use SQL Server Management Console with integrated Source Control to do the development
0 comments:
Post a Comment