Answer / narasimha

Select redo_start_lsn from sys.master_files where
database_id = db_id('SecondaryDatabaseName') and type = 0

Answer / sunil

Narasimha, Thank you So much

I will very appreciate if you will send some daily usage
SQL DBA Queries like this. My mail ID is sqldba29 @
gmail.com

I have to display ten columns values from diffrent ten tables. how many joins are require?

10 Answers   CarrizalSoft Technologies, HCL,

---

What is a join and their types?

2 Answers   Challenger Financial,

---

Advantages and Disadvantages of Cursor?

15 Answers   Polytechnic, TCS, Zenith,

---

What are the recovery models in sql server 2000?

0 Answers  

---

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

0 Answers  

---

How to call stored procedure using http soap?

0 Answers  

---

What is a deadlock and what is a live lock?

0 Answers  

---

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

1 Answers   Cognizant, HCL, Value Labs,

---

What is failover clustering overview?

0 Answers  

---

What is user-defined multi-statement table-valued function?

0 Answers  

---

What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue

2 Answers   IBM,

---

Tell me what is the significance of null value and why should we avoid permitting null values?

0 Answers  

---