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
- 9054 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 |
Why do we partition data?
About Indexed Views? with example? plz reply...
What are the types of subscriptions in SQL Server replication?
Can you pass expressions to stored procedure parameters?
What is scan table/view and seek table/view when its occurs? : sql server database administration
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
What options are available to audit login activity? : sql server security
How to link tables in sql server?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
What are different types of data sources?
What are the factors you will check for the performane optimization for a database query?
7 Answers CarrizalSoft Technologies, DELL, SoftSol,
-
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)
