If you want to send some data from access database to sql server database. What are different component of ssis will you use?

0 Answers  

---

What is cursors? And what are the different types of cursor?

0 Answers  

---

Characterize join and name diverse sorts of joins?

0 Answers  

---

how many joins we can write if at all we have n no of tables

5 Answers   Tanla Solutions, TS,

---

IN Vs OR operator which is best to use sql server.

4 Answers  

---

Explain system functions or built-in functions? What are different types of system functions?

0 Answers  

---

Which data type columns are the best candidates for full-text indexing?

0 Answers  

---

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

---

What is ms sql server index?

0 Answers  

---

How to create a view with data from multiple tables?

0 Answers  

---

Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?

2 Answers  

---

What area unit the various kinds of info compression introduced in sql server 2008?

0 Answers  

---