Architect a redundant SQL Server environment
Sql Support Interview Questions
2,209 sql support interview questions shared by candidates
what is materialized view and why it is required?what is pivot? when to use the non-clustered index and when to use clustered one.what will you do if your database is growing out of size?how to optimize the query or stored proc? how to read execution plan and what steps to take on it? write query which can add row number column for a table? what is partition? diff between temp table and temp table variable? scope of global variable? there are two tables both have only one column which accepts null, both table have 5 rows as 1,1,1,1,null. how many rows will come for inner join, left, right, union and union all on these two tables.(try this on SSMS)? High level design for employee, tasks and timesheet scenario etc
Difference between where and having Diff b/w group by and windows function Error Handling In SP Trigger Function Diff between SP and Function Windows function Odd rows in 50 empid Inner join two tables with nulls
Explain Normalizations process and types
Asked for basics like backups recovery model and HA DR feature and System DB
Just basic theoritical questions powerbi sql
What is RDBMS and DBMS?
Preguntas diversas sobre mi experiencia y sobre desarrollo de queries en SQL, además de algunas preguntas de acertijos.
Conceptos básicos de sql y unix/linux.
Technical - to check the skillset . Tell about what you achieved Your positive and negative
Viewing 1521 - 1530 interview questions