There are few ways to find out when the SQL Server was restarted, here I am going to use DMV (sys.dm_os_sys_info) to find the SQL Server restarted time.
SELECT sqlserver_start_time FROM sys.dm_os_sys_info
Subscribe to:
Posts (Atom)
-
“Don’t use * in SELECT query, instead use only required column”. This is one of the tips to optimize SELECT query. However, does this real... -
In SSIS, there is no direct method to get the error description when error occurred during data Load and transformation. We can only redir... -
When importing data from text file you may need to apply NULL to the field where no values present (blank). Not doing so the package may fai... -
Let’s start with an example to understand what is many to many relationship and how this can be represented in database. If you have sho... -
JOIN is one of the fundamental units of relational database system. Generally JOIN is used to combine related data from many tables to pr... -
Identity is a property that can be set on a column. When an identity is enabled the column will be populated automatically by system and it...
-
I have created a simple table to demonstrate how to concatenate the values from multiple rows in to one column. CREATE TABLE #tblProduct...
-
To know the given date is end date of the month, You can use the dateadd and day functions. that is, you should add 1 day to the given date...
-
The myth is to roll back the work done inside the transaction, in case of any error during the transaction. However this is not the case wit...
-
@@ERROR returns error number of the last statement executed. When the last executed statement completed successfully, this returns 0. In cas...
