In which files does sql server actually store data?

0 Answers  

---

How you can add messages to the nt event log from within a stored procedure?

0 Answers  

---

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

0 Answers  

---

What will you do If the low Performance occurs?

2 Answers  

---

How to generate create procedure script on an existing stored procedure?

0 Answers  

---

sql server architecture ?

0 Answers  

---

What is blocking and how would you troubleshoot it?

3 Answers   HCL,

---

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

0 Answers  

---

How do you use DBCC statements to monitor various aspects of a SQL server installation?

1 Answers  

---

What is the distinction amongst delete and truncate?

0 Answers  

---

How to check table values in sql server?

0 Answers  

---

Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?

1 Answers  

---