what is optimizer in sql server
Sql Database Engineer Interview Questions
430 sql database engineer interview questions shared by candidates
About yourself, previous experience, NoSQL
mentioned in the above interview process
1. How the rebuild or reorganize queries work on always on ag database? 2. while reorganizing is it good to reorganize clustor index or non clulstor inxdex and Why? 3. assigning user acess to perticular DB/table/filegroup, How it can be done for individual account or AD Group? 4. SQL server installation process? 5. AZURE Migration process from on prem instance? 6. Always on AG Implementation and solutions for general errors that occur ? 7.why fragmentation occurs, safe fragmentation level and solution for high fragmentation level.
Assume you are mentoring a team and in a span of 6 months all of your team members have left the organization and currently you owe a fresh team. So what would you do to make mission business critical working without impact?
Tell your performance tuning process
SQL TDE architecture Cluster AG
Will you join the company if we match your offer or do you require a hike?
Asked about AOAG with the latest version
Give me three different approach for inner join.
Viewing 241 - 250 interview questions