Answer / 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 mean by constraints in sql?

5 Answers   Granada, IBM,

---

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers   HCL, Wipro,

---

What is the dbcc command and why is it used?

0 Answers  

---

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

0 Answers  

---

What is default port number for sql server 2000?

0 Answers  

---

What is the difference between nvl and nvl2?

0 Answers  

---

default databases available in sql server and there uses ?

4 Answers   TCS,

---

What is the most common type of join?

0 Answers  

---

Mention the different types of replication in sql server.

0 Answers  

---

Why use stored procedures in sql server?

0 Answers  

---

What is the user of Primary key?

0 Answers  

---

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

1 Answers   Logitech, Mphasis,

---