985Questions
779Answers
Interview Preparation mode beta
Funny Facebook Status Funny Facebook Status
Enter your email address
Recent questions tagged sql-server-interview-question

Recent questions tagged sql-server-interview-question

Nice?Vote!
1 answer
How to do sql server performance turning?
asked 1 year ago in SQL Server Interview Questions and Answers by anonymous
Nice?Vote!
2 answers
Which SQL mechanisms allow user to browse tables sequentially?
asked 1 year ago in SQL Server Interview Questions and Answers by anonymous
Nice?Vote!
1 answer
Explain the Service Broker components
asked 1 year ago in SQL Server Interview Questions and Answers by Anand (1,440 points)
Nice?Vote!
2 answers
What exactly is SQL Server 2005 Service Broker?
asked 1 year ago in SQL Server Interview Questions and Answers by Anand (1,440 points)
Nice?Vote!
2 answers
What is the new error handling technique in SQL Server 2005?
asked 1 year ago in SQL Server Interview Questions and Answers by Anand (1,440 points)
Nice?Vote!
2 answers
Can you explain the difference between the INTERSECT and EXCEPT operators?
asked 1 year ago in SQL Server Interview Questions and Answers by Anand (1,440 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)
Nice?Vote!
1 answer
What are some of the hardware advances that can benefit SQL Server?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Nice?Vote!
1 answer
In general, how would you design the drive layout for a SQL Server?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Nice?Vote!
4 answers
As a Network Administrator, how can you help to prevent a SQL Injection attack?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Nice?Vote!
1 answer
As a Network Administrator, which components of SQL Server do you want to secure?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Nice?Vote!
5 answers
How do you troubleshoot a SQL Server performance problem?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Nice?Vote!
2 answers
What are some of the tools that you use to troubleshoot a SQL Server issue?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Page:
Powered by Question2Answer