Database Designing
- Database Design: Please do not use DISTINCT
- SQL Server: Implement Table Partition in Non Enterprise Edition (Use Partitioned View)
- SQL Server: Performance Test – Problem of mismatched Column Data Type
- SQL Server: Avoid the use of Indexes on VARCHAR columns
- Database Design: Common Practices for Database Developers and Application Developers
- Database Design: Don’t use, comma separated Tables in SELECT Query, Use Explicit JOINs
- SQL Server: What happened, when Row Overflow and Data Exceeding 8KB?
- Database Design: The Ultimate Strategies to avoid Deadlock
- Database Design: Storing a comma separated list in a Database, Is a Bad Practice?
- Database Design: Should we allow NULL or We should apply NOT NULL ?
- Database Design: Use Stored Procedure, Do not use Inline or Ad Hoc SQL
- Database Design: The Truth about Archive Table and Soft Delete of Historical Data
- Best practice for Primary Key in Database Management System
- The truth about to store images into the Database System or into the File System
- SELECT all columns to be good or bad in database system
- Best way to store IP Address into Database System
- Effective storage of Email Address into Database System