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 |
in how many ways we can use count()
What are subquery and its properties?
Simple example for difference between select and cursor in sql
Do you know what is similarity and difference between truncate and delete in sql?
How do we return a record set from a Stored Procedure in SQl server 2000?
explain different types of cursors? : Sql server database administration
Explain the various types of concurrency problem?
What is an example of a foreign key?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
When I run the sql server 2000 setup, it just hangs. What do I do?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
How many types of attribute relationships are there? : sql server analysis services, ssas
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)