Answer / gaurav.verma4210

SELECT * from
sys.databases
is used for find the id of database.
SELECT create_date
FROM sys.databases
WHERE database_id = 2
Tempdb db is recreated each time SQL Server is restarted so
the created date time of TEMPDB will also give you the date
and time of the last restart of the instance.

If we shrink the Databse and Files, how much size is decreased?

1 Answers   TCS,

---

What is the default value of an integer data type in sql server 2005?

0 Answers  

---

What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,

---

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

0 Answers   United Healthcare,

---

When should you use an instead of trigger?

0 Answers  

---

---

How to retrieve field values using mssql_result()?

0 Answers  

---

which one will take 1st priority in case of insert statement and select statement???

2 Answers   HCL,

---

How to concatenate two binary strings together?

0 Answers  

---

What is data compression? : sql server database administration

0 Answers  

---

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

---

Can you tell me about the concept of ER diagrams?

0 Answers  

---

How to download and install microsoft .net framework version 2.0?

0 Answers  

---