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

Is mysql the same as sql server?

680

---

what are triggers? : Sql server database administration

656

---

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2261

---

Explain four layers of abstraction microsoft architectured?

138

---

Can we update data in a view?

773

---

---

What does asynchronous call backs means?

767

---

What is attribute relationships, why we need it? : sql server analysis services, ssas

669

---

what are candidate key, alternate key and composite key? : Sql server database administration

668

---

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

665

---

What are distributed partitioned views?

813

---

what is memory-optimized nonclustered indexes

730

---

Tell me about pre-defined functions of sql?

859

---

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2032

---

How do you migrate data from mssql server to azure?

159

---

What stored by the master? : sql server database administration

742

---