Answer / madan

There is no way to to read log file in mssql server.

TO read log file there are some 3rd party tools.

What is query processing?

0 Answers  

---

What are the features of Embedded SQL

0 Answers   HCL,

---

How cand Optimize SQL Server Stored Procedures

1 Answers  

---

1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?

3 Answers  

---

select name of emplyoee whose total salary is 130 from following table. id name salary 1 a 100 2 b 20 3 c 50 1 a 30 2 b 70 Post the resulantant Query?

7 Answers  

---

How can you see what type of locks used?

1 Answers  

---

How can we rewrite sub-queries into simple select statements or with joins?

0 Answers  

---

How would we use distinct statement? What is its use?

0 Answers  

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---

What is the difference between clustered and a non-clustered index?

0 Answers   NA,

---

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 Answers  

---

Explain about merge replications?

0 Answers  

---