What are the different ways of moving data/databases
between servers and databases in SQL Server?
Answer / swapna
There are lots of options available, you have to choose
your option depending upon your requirements.
Some of the options you have are: BACKUP/RESTORE,
dettaching and attaching databases, replication, DTS, BCP,
logshipping, INSERT...SELECT, SELECT...INTO, creating
INSERT scripts to generate data.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is onf in normalization form?
What is collation sensitivity? Explain different types.
What are the general features of sql server management studio? : sql server management studio
WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.
between cast and convert which function would you prefer and why?
What are the steps you should follow to start sql server in single-user mode?
What is reference section?
Do comments need to go in a special place in sql server 2005?
Mention the differences between having and where clause.
What are functions
Can foreign key be deleted?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
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)