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.

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C

9 Answers   tdfc, vsworx,

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

0 Answers  

---

What happens to a trigger with multiple affected rows?

0 Answers  

---

What is a covering index?

0 Answers  

---

What is the difference between truncate and delete commands?

0 Answers  

---

How to query multiple tables jointly?

0 Answers  

---

What are functions in the sql server?

0 Answers  

---

What is a user-defined function in the sql server and what is its advantage?

0 Answers  

---

What is data source object?

0 Answers  

---

What is log in sql server?

0 Answers  

---

How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?

2 Answers  

---