Tag Archives: Standard

Best practices being DEVOPS in IT

Index: MSSQL Index naming recommendations:   PK_ for primary keys UK_ for unique keys IX_ for non clustered non unique indexes UX_ for unique indexes <index or key type>_<table name>_<column 1>_<column 2>_<column n>  

Posted in SQL Server, Uncategorized | Tagged , , | 1 Comment

Find In-Memory table in a given database

Note: In Azure if we use premium database functions we can not downgrade those databases into standard pricing tier. We need to remove premium database features before downgrading to Standard tier. I had to create multiple database copies to reproduce … Continue reading

Posted in SQL, SQL Query, SQL Server, Uncategorized | Tagged , , , , , , , , , | Leave a comment