Answer Posted / potula

login defines access privillege to sql server. A user
defines the accessible objects and rights the login has

What are trace files?

1003

---

What is attribute? : sql server analysis services, ssas

1069

---

How to add more data to the testing table in ms sql server?

1160

---

How do you clear a log file?

1108

---

Can we use where clause with group by?

945

---

What are the advantages of mirroring?

1041

---

What is the difference between deallocate cursor and close cursor?

1328

---

How to restore performance issues and how to check?

2050

---

Explain the difference between cross join and full outer join?

1024

---

between cast and convert which function would you prefer and why?

1010

---

What is the meaning of resultset type_scroll_insensitive?

988

---

what is nonclustered index

998

---

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1064

---

What is the purpose of floor function?

1090

---

How to use copy and concatenate commands in SQL?

1192

---