Answer / swapna

USER_ID(). Also check out other system functions like
USER_NAME(), SYSTEM_USER, SESSION_USER, CURRENT_USER, USER,
SUSER_SID(), HOST_NAME().

Answer / hcl

select * from dbo.sysprocesses

Answer / naren

13.select * from sysprocesses
where loginame like '324%'----diply the all ohrid's in the
server

What is scd (slowly changing dimension)? : sql server analysis services, ssas

0 Answers  

---

Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?

1 Answers  

---

what are the joins,primary key,foriegn key, candidate key, super key and expain them?

6 Answers   Polaris,

---

Where are sql server usernames and passwords stored in the sql server?

0 Answers  

---

How do you optimize Sql queries ?

0 Answers   Cognizant,

---

---

What is a field name?

0 Answers  

---

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 Answers  

---

define and explain the differences between clustered and non-clustered indexes.

0 Answers   Microsoft,

---

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

0 Answers   ABC,

---

What is the use of builtinadministrators group in sql server? : sql server security

0 Answers  

---

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

0 Answers  

---

Explain how many normalization forms?

0 Answers  

---