let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

0 Answers  

---

What are the steps you must follow to hide sql server instances?

0 Answers  

---

What is the bookmark lookup and rid lookup?

0 Answers  

---

Which table keeps information about stored procedures?

0 Answers  

---

What are the basic functions for master, msdb, model, tempdb databases?

0 Answers  

---

What are temporal tables in sql server 2016?

0 Answers  

---

Which autogrowth database setting is good?

0 Answers  

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

0 Answers   Aptroid,

---

What is the purpose of optimization?

0 Answers  

---

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

0 Answers  

---

How do I get to sql server configuration manager?

0 Answers  

---

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

0 Answers  

---