Answer Posted / brahma

select * from table_name t1 where (n-1)=
(select count(distinct(column_name)) from table_name t2
where t2.column_name>t1.column_name)

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

953

---

What is the difference between DATETIME2 and DATETIME?

1131

---

What is efficiency data?

1004

---

What is the purpose of forms?

1004

---

What is bit data type?

1083

---

What is the difference between a local and a global temporary table?

1178

---

How network traffic be reduced by using the stored procedure?

1174

---

How to create new tables with "create table" statements in ms sql server?

1108

---

What are the difficulties faced in cube development? : sql server analysis services, ssas

1099

---

What does sql server mean?

1164

---

How to delete exactly duplicate records from a table?

1110

---

What is raid and what are different types of raid levels?

1195

---

Explain trigger classes i.e. Instead of and after trigger?

920

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1942

---

Can binary strings be used in arithmetical operations?

986

---