Performance Tuning How to check foreign key constraints columns on a table using a query. How to get identity, computed properties of a column in a table How to implement SOUNDEX Sent Status and mail log of the database mail. Sending an email from Database engine using database mail profile. Configuring Database Mail. Create an email operator to send notification recipient for alerts, jobs on SQL Server Agent. configure max degree of parallelism SQL Server Option. How to get all server set configurations from SQL Server management studio. How to Format a system message or a localized message. THROW vs RAISERROR What is a column store Index, why should a column store index needs to be created, when should a column store index be created? Creating a column store index How to view properties of a SQL Server Column Store Clustered/ Non- Clustered Index? What are plan guides and how to use a custom plan guide? How to enable, disable or drop all or specific plan guides? What is an execution and how to get execution plan of a query? Reading and understanding an execution plan graphical presentation
0 comments:
Post a Comment