What is the maximum number of primary keys that you can put on a table?
Explain the difference between a clustered index and a nonclustered index?
How many clustered indexes can you put on a table?
Describe the difference between a left join and an inner join?
Sql injection is a security exploit in which an attacker submits dangerous input that is then incorporated into a database query, in c# how can you effectively mitigate this risk in your code?
Performance scenario, production system is suffering from extreme slowness and the triage reveals that it is isolated to one page in that the time it takes to load that page is almost entirely triggerable to one stored procedure, how would you go about further investigating why that stored procedure is slow?
Describe the difference between a process and a thread?
Is there a separate callstack for each thread?
What are some thread synchronization tools to maintain thread concurrency?
Have you worked with locks, mutexes, and semaphores?
In c#, what are namespaces used for?
What is the purpose for the using statements?
Can you reference a single component multiple times can you have multiple namespaces per component?
In the .NET framework, what is the base class from which all other classes inherit? It is at the very top of the class hierarchy.
What are some methods that exist on all objects? There are four public methods that you can access for free.
Have you used the ToString() Method before?
What is the purpose of the IDisposable Interface?
Thinking about structured exception handling, if you have a try block do you have to have at least one catch block?
Have you used a finally block? Can you describe what it is used for?
What does a catch block do for us?
Have you consumed or built RESTful based services over http?
When do you use get vs post?
Is it acceptable when you're submitting a post for your request to call data changes on the server side?
When you're using an api as a consumer is it acceptable to use a get to cause data to change in terms of modifying data that would be exposed to a consumer other than backend logging type data?
When in a page life cycle does the document ready function execute? There's an event that causes the document ready function to execute. What is that event? What has to be true in the browser for that event to execute?
What do you do to stay current? If you fall asleep for 6 months to a year you're behind.
How does the common language runtime support multiple programming languages?
Thinking about asp.net core, can you describe what middleware does?
With asp.net core, are you familiar with startup.cs? There are a couple of methods in that file can you think of what they are?
Have you worked with a dependency injection?
What is Ajax? Can I open a connection to the SQL Server directly and query the database?
When you're in debug mode in visual studios what key do you use to step through the code?
Can you describe what a closure is?
Can you describe the difference between a callback and a promise?
What do you know about unit testing?
What kind of development process have you used agile, scrum, waterfall?
How do you troubleshoot a query that is running painfully slow? How do you determine what the best way to optimize that query is? What is your workflow?
You have a new feature to add, you have all the requirements, you have everything you need to get the job done, there are no questions left unanswered, you sit down at your desk fire up the editor, where do you start?
What kind of questions do you have for us?
What do you know about us?
Lets start with a short high level review of what you can bring to the table, what makes you feel like this company cannot continue doing business without hiring me?
Let's say you have a left outer join, you have table a on the left and table b on the right, what records do we get from a and what records do we get from b on a left outer join?
With an inner join, can you give me two different ways of doing the syntax? Maybe the newer way or an older way?
Lets say you're handed a slow running query that is rather large that has a lot of tables and inner dependencies, what do you do to speed up a slow running query? SSIS https://technet.microsoft.com/en-us/library/ms177500(v=sql.105).aspx
C# types, there's value types, reference types, classes, and structs, is a struct type a value type or reference type? classes a value type or reference type?
What's overloading, operator overloading and method overriding?
There are 9 different options for managing user persistent state, what are they? https://msdn.microsoft.com/en-us/library/z1hkazw7.aspx