Answer Posted / sandeep yadav

INSERTED and DELETED tables known as MAGIC
TABLES.

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

989

---

When I delete any data from a table, does the sql server reduce the size of that table?

1028

---

List the various tools available for performance tuning?

893

---

What is a trigger in sql server?

1185

---

what do you understand by change data capture?

1034

---

How to get the definition of a user defined function back?

1051

---

Define outer join in sql server joins?

941

---

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

976

---

When you should use a low fill factor?

1000

---

How to find table changes in sql server?

1131

---

What is nonclustered index on computed columns?

966

---

How to restore performance issues and how to check?

2011

---

What is user defined datatypes and when you should go for them?

1026

---

How to insert multiple rows with one insert statement in ms sql server?

1132

---

if no size is defined while creating the database, what size will the database have? : Sql server administration

1017

---