SQL Server data structure

Question

What are the best practices or recommendations before creating either a new table in an existing database or an entirely new database depending on the existing data structure?

I am new in the DBA world.. so any and every answer helps.

Thanks in advance

Answer 1

Hi @SQLLover21 ,

Creating a table is not only related to naming, columns and column data types, but also related to relationships, keys, constraints, index, etc. In addition, the design of the table is also related to requirements. It may be difficult to give recommendation without specific examples.

Here are some articles about basic knowledge which might help:
Tables (You can click on the directory on the left to view more content.)
Table Relationships
Primary and Foreign Key Constraints
SQL Server Index Architecture and Design Guide

Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November

Answer 2

What are the best practices or recommendations before creating either a new table in an existing database or an entirely new database depending on the existing data structure?

I am not aware about best practice for table but yes we have some recommendation for new database

1. The data and log file should be on different physical drive
2. The autogrowth should be in MB not percentage
3. Make sure when you create database it has some predefined size so that autogrowth does not happens during starting
4. The database owner should be low privileged account. Some people say putting SA as owner, I do not do that.