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