Answer / Shurveer Saxena

To view the error log for a specific SQL Server instance, you can use the SQL Server Management Studio (SSMS) or query the sys.syslog system catalog view directly from a query window. If using SSMS, go to Object Explorer, expand the instance name, then expand Management, and select Error Logs. To query the error log programmatically, run the following T-SQL command: SELECT * FROM sys.syslogs WHERE server_id = <instance_id> ORDER BY time_desc;

Can we create a clustered index on composite primary key.

3 Answers   IGT,

---

Why it is recommended to avoid referencing a floating point column in the where clause?

1 Answers  

---

Do you know what guidelines should be followed to help minimize deadlocks?

1 Answers  

---

How to get the count of distinct records. Please give me the query?

8 Answers   Value Labs,

---

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,

---

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1 Answers  

---

What is a coalesce function?

0 Answers  

---

What is the difference between SQL notification and SQL invalidation?

1 Answers   MindCracker,

---

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

1 Answers  

---

Why main is user defined function?

1 Answers  

---

What do you understand by mirroring and mention the advantages of the mirroring?

1 Answers  

---

Difference between Inner vs outer joins?

1 Answers  

---