What are the differences between substr and charindex in sql server.
What are four major operators that can be used to combine conditions on a where clause?
What do you mean by an execution plan? Why is it used?
how many instance use in sql server 2005
What is stored procedure in SQL..??
Explain error and transaction handling in sql server?
How can you list all the table constraints in a database?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
List the ways in which dynamic sql can be executed?
How do we know if any query is retrieving a large amount of data or very little data?
What are the various editions of sql server 2017 that are available in the market?
How do I find the port number for sql server?
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?