Useful tips for everyday
How to grant SELECT, INSERT, UPDATE, DELETE ON all table? You grant permissions on a securable to a principal. So, you could GRANT SELECT, INSERT,…
Can unique index be dropped? A primary key or unique key index cannot be explicitly dropped. You must use one of the following methods to…
Does SSAS use SQL Server memory? SQL Server Analysis Service is a memory intensive service. Even if SSAS is idle, it will consume around 40-50…
What Are Always On availability Groups? The Always On availability groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database…
What is the use of having multiple file groups? The big benefit of filegroups is to separate database objects. You can put one table or…
How to execute stored procedure after a time delay? You do not want to be putting anything in a trigger that will affect the execution…
How will you sync SQL Azure with on premise SQL Server? How to set up Data Sync between Azure SQL and On-Premises SQL Server Login…
Why is it important to identify contraindications? Checking for contra indications prior to the treatment can easily prevent the possibility of a claim being made…
Is the processing time of a SSAS Cube a problem? As your SSAS cube gets bigger, cube processing time will become a problem. This is…
How do you handle loaded questions? 3 Best Responses to Loaded Questions Aimed to Trap You Option 1: Never repeat a negative. State your positive.…