How to get a list of columns using the "sp_help" stored procedure in ms sql server?

0 Answers  

---

Normalization and denormalization

3 Answers   Wipro,

---

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,

---

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

0 Answers  

---

How raid can influence database performance?

0 Answers  

---

---

How to change server name in sql server?

0 Answers  

---

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 Answers  

---

Explain log shipping?

0 Answers  

---

What are the new features in sql server 2016?

0 Answers  

---

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

0 Answers  

---

How real and float literal values are rounded?

0 Answers  

---

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

0 Answers  

---