Answer Posted / amrish kumar

USE DataBaseName
GO
SELECT name,physical_name,size,max_size
FROM sys.master_files
WHERE database_id = DB_ID('DataBaseName');
go

How to insert stored procedure result into temporary table?

1011

---

What is the recovery model? List the types of recovery model available in sql server?

897

---

Define self join?

1021

---

how can you check the level of fragmentation on a table? : Sql server administration

965

---

What are the different types of collation sensitivity?

1111

---

What is transaction server implicit?

998

---

What are the different index configurations a table can have?

954

---

What is function of master database?

114

---

What is perspective, have you ever created perspective? : sql server analysis services, ssas

910

---

You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

121

---

What are the disadvantages of primary key and foreign key in SQL?

1101

---

Explain the phases a transaction has to undergo?

1051

---

Explain steps of normalization?

991

---

If the job running very slow what is the action you do

1884

---

Does a server store data?

918

---