How to store and query spatial data?

0 Answers  

---

What are the limitation of the Online Index Rebuild Operation?

1 Answers  

---

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

0 Answers  

---

How do I clean up sql server transaction log?

0 Answers  

---

What is an example of a primary key?

0 Answers  

---

What is the difference between ddl,dml and dcl commands?

0 Answers   BirlaSoft, Verifone,

---

What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.

3 Answers   247Customer,

---

Which system tables contain information on privileges granted and privileges obtained

1 Answers  

---

What are statistics, under what circumstances they go out of date, how do you update them?

2 Answers   HCL,

---

What is the difference between getdate and sysdatetime?

0 Answers  

---

Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,

---

what is denormalization and when would you go for it? : Sql server database administration

0 Answers  

---