Answer Posted / suresh

float

What are ddl triggers and types of ddl trigger?

1038

---

What is difference between inner join and join?

1044

---

What are drillthrough reports?

155

---

What do you mean by an execution plan? How would you view it?

914

---

What do you mean by tablesample?

1079

---

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

978

---

What do you understand by mirroring?

997

---

Mention the differences between substr and charindex in sql server.

1050

---

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2236

---

What is the difference between index seek vs. Index scan?

1023

---

Define ACID properties in a Database?

1057

---

What are sql server functions?

979

---

What happens if an integer is too big for int date type?

975

---

How you can find out if an index is useful to the optimizer?

939

---

what is the system function to get the current user's user id? : Sql server database administration

1022

---