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 |
What is a data source file?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What are the different subsets of sql?
How does normalization work?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
What is partitioned view?
Explain what are the events recorded in a transaction log?
Can we use where and having clause together?
What is the difference between primary key and unique constraints?
Find top Nth employee from each department in terms of salary?
How you can change the database name in SQL SERVER?
Oracle (3259)
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)