MS-SQL Server - Rani, Pluto & D-Naming Rules

Rani, Pluto & D-Naming Rules

Rani

The role of Rani (A Queen) is basically exists in most of the technologies and in a famous game of Chess also.

I admire msdb which is responsible to keep history of jobs and silently active as Queen handles so many things.

Pluto in regards to SQL Server performance is nothing but

P - Partitioning tables

L - Log space & setting up recovery models accordingly.

U - Update Statistics

T - Tempdb Best Practices

O - Optimizing Queries

Database Naming Policy

https://learn.microsoft.com/en-us/sql/relational-databases/policy-based-management/lesson-2-create-and-apply-a-naming-standards-policy?view=sql-server-ver16

Additionally,

It's recommended to restart SQL service to be able to Re-Create tempdb intermittently.

This process removes unwanted data/objects from Tempdb database.

Error S1000

https://support.microsoft.com/en-au/topic/error-s1000-microsoft-odbc-sql-server-driver-sql-server-could-not-find-the-index-d60df281-7b8e-9ec5-eefe-b1577abda4ad#:~:text=Symptoms,attempting%20to%20generate%20a%20report.

Any query will be considered.

T. Amit Vaid S.