Answer Posted / selvaraj.v

SQL Server 2000 BackUp Database,
Query:
------
backup database selvaa to disk = 'c:\selvaa.bak'

Answer:
-------
Processed 160 pages for database 'selvaa',
file 'selvaa_Data' on file 1.
Processed 1 pages for database 'selvaa', file 'selvaa_Log'
on file 1.
BACKUP DATABASE successfully processed 161 pages in 0.151
seconds (8.687 MB/sec).

Is it possible to have clustered index on separate drive from original table location?

921

---

What is dirty page?

931

---

What is the difference between having clause and where clause in sql server?

1043

---

What is the report model project?

134

---

Do you know what are pages and extents? : SQL Server Architecture

953

---

Explain indexed views?

934

---

How to delete multiple rows with one delete statement in ms sql server?

956

---

What are the limitations in ssrs on sql server express edition?

177

---

What are difference between Cluster index and Non-Cluster index?

1029

---

How real and float literal values are rounded?

1112

---

Tell me what do we need queues in sql service broker?

940

---

How many types of built in functions are there in sql server 2012?

883

---

Can group functions be used in the order by clause in ms sql server?

977

---

What is use of dbcc commands?

1030

---

How do you rename a table in sql server?

959

---