Recent questions tagged junior-sql-server-developer-interview-questions

Recent questions tagged junior-sql-server-developer-interview-questions

Nice?Vote!

1 answer

What are some of the Reporting Services best practices that you follow?

asked 1 year ago in SSRS Interview Questions and Answers by R (19,530 points)

Nice?Vote!

1 answer

Name the three main tabs in the Visual Studio interface for SSIS Packages and the associated purpose.

asked 1 year ago in SSIS Interview Questions and Answers by R (19,530 points)

Nice?Vote!

1 answer

Can tables be over indexed? What are the performance implications?

asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)

Nice?Vote!

1 answer

What are the different indexing options available and what columns do you typically index?

asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)

Nice?Vote!

1 answer

What are some options to randomly capture a value from a column in a table?

asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)

Nice?Vote!

1 answer

Name 3 or more aggregate functions and the value they provide in your coding.

asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)

Nice?Vote!

2 answers

How do you code error handling logic in your stored procedures?

asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)

Nice?Vote!

5 answers

What is the difference between DDL and DML commands? Can you name some examples of each?

asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)

Nice?Vote!

3 answers

What is an identity? What is the value? How can you capture the last identity value per column?

asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)

Nice?Vote!

2 answers

What is the importance of primary keys and foreign keys in a SQL Server OLTP database design?

asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)

To see more, click for the full list of questions or popular tags.