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

What is a ddl statement?

889

---

How to attach adventureworkslt physical files to the server?

1085

---

Explain filtered indexes benefits?

989

---

How to change a login name in ms sql server?

1059

---

explain different types of backups avaialabe in sql server? : Sql server database administration

957

---

What is blocking?

1038

---

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2724

---

What action plan is preferred if sql server is not responding?

1084

---

How you can change the database name in SQL SERVER?

1171

---

Explain different backup plans?

916

---

What is user-defined functions? What are the types of user-defined functions that can be created?

1017

---

What is BCP? When does it used in sql server 2012?

1042

---

Explain temporary table vs table variable by using cursor alternative?

975

---

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1077

---

What are triggers in ms sql server?

1142

---