Answer / swapna

Preferring NT authentication, using server, databse and
application roles to control access to the data, securing
the physical database files using NTFS permissions, using
an unguessable SA password, restricting physical access to
the SQL Server, renaming the Administrator account on the
SQL Server computer, disabling the Guest account, enabling
auditing, using multiprotocol encryption, setting up SSL,
setting up firewalls, isolating SQL Server from the web
server etc.

what's the difference between delete table and truncate table commands? : Sql server database administration

0 Answers  

---

When would you use sql joins?

0 Answers  

---

explain different types of joins? : Sql server database administration

0 Answers  

---

What is the difference between cartesian product and cross join?

0 Answers  

---

What is Right Outer Join?

2 Answers  

---

Explain about protocol layer present in SQL server?

0 Answers  

---

one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 Answers   Cognizant,

---

optimization techinques

0 Answers   Wipro,

---

how to copy only distinct data into another table which is not already exist in database?

2 Answers   Spectra,

---

After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

3 Answers   CarrizalSoft Technologies, iGate,

---

What is the difference between Drop and Truncate

20 Answers   GT Nexus, IBM,

---

What is table value parameters (tvp)?

0 Answers  

---