What are indexes in sql?

1 Answers  

---

List some case manipulation functions in sql?

0 Answers  

---

Explain the concept of view and Types of views in SQL server?

0 Answers   HCL,

---

What is the contrast between sql and pl/sql?

0 Answers  

---

how can do you the system monitoring?

1 Answers  

---

1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 Answers   Techno Solutions,

---

What are the Advantages of using CTE in sql server?

0 Answers   Winsol Solutions,

---

Explain use of expression builder.

0 Answers  

---

What is the difference between createstatement and preparedstatement?

0 Answers  

---

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

0 Answers  

---

my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  

---

How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.

1 Answers  

---