Can you explain the role of each service?
Answer / guest
SQL SERVER - is for running the databases SQL AGENT - is for
automation such as Jobs, DB Maintanance, Backups DTC - Is
for linking and connecting to other SQL Servers
Is This Answer Correct ? | 0 Yes | 0 No |
Explain stored procedure?
What is normalization? What number of normalization shapes are there?
What are the components of sql server service broker?
What is a covering index?
What is the difference between seek predicate and predicate?
What is the difference between cross join and Full outer join?
What is sqlcmd?
what is isolation level at dead lock?
Can sql servers link to other servers?
What is the difference between local and global temporary tables?
How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)
What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue