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.

What are the difference between clustered and a non-clustered index?

0 Answers  

---

What is the main purpose of having conversation group?

0 Answers  

---

What are the joins in sql server? : sql server database administration

0 Answers  

---

How do you identify a foreign key?

0 Answers  

---

Can we rollback records deleted by a truncate statement?

3 Answers   CarrizalSoft Technologies, United Healthcare,

---

---

explain different types of joins? : Sql server database administration

0 Answers  

---

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

0 Answers  

---

How to create user messages with print statements in ms sql server?

0 Answers  

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

0 Answers  

---

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers   HCL,

---

What is the fastest way to permanently delete a 1 million row table named customers?

0 Answers  

---

If there is failure during updation of certain rows, what will be the state?

2 Answers  

---