Interested to Buy Any Domain ? << Click Here >> for more details...
How to get last system shutdown time in Sql server when
restarted system?
- 1 Answers
- 8976 Views
- I also Faced
- E-Mail Answers
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.
| Is This Answer Correct ? | 8 Yes | 6 No |
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
What is view in sql?
How does stuff differ from the replace function?
How to store and query spatial data?
what is the different types of backups available in sql server? : Sql server database administration
how can you check the level of fragmentation on a table? : Sql server administration
Explain about local stored procedure?
How many columns can exist together per table?
What are different types of Keys? Please explain all the keys with a suitable example.
Explain in brief about Microsoft SQL server?
What is the use of floor function in sql server?
What are the different subsets of sql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
