|
|
-
Pothiraj knew 2 Years ago through Just Learned | 1 Point
'EXCEPT' will show any distinct value from first query result that is not found in second query result.
Select item_id from itemmaster
except
Select item_id from stock
'INTERSECT' will show any distinct values, which are common in both first & ...
|
-
Pothiraj Liked 2 Years ago through Just Learned | 1 Point
'EXCEPT' will show any distinct value from first query result that is not found in second query result.
Select item_id from itemmaster
except
Select item_id from stock
'INTERSECT' will show any distinct values, which are common in both first & ...
|
-
Pothiraj knew 2 Years ago through Just Learned | 1 Point
'EXCEPT' will show any distinct value from first query result that is not found in second query result.
Select item_id from itemmaster
except
Select item_id from stock
'INTERSECT' will show any distinct values, which are common in both first & ...
|
-
Pothiraj Liked 2 Years ago through Just Learned | 1 Point
SQL Server job history contains only last 100 records.
To change or to grow history log
Go to SQL server Agent's Property
Click on -> History
change 1) Maximum job history log
2) Maximum job history rows per job......
|
-
Pothiraj Learned 2 Years ago through Just Learned | 1 Point
SQL Server job history contains only last 100 records.
To change or to grow history log
Go to SQL server Agent's Property
Click on -> History
change 1) Maximum job history log
2) Maximum job history rows per job......
|
-
Pothiraj Liked 2 Years ago through Just Learned | 1 Point
SQL Server job history contains only last 100 records.
To change or to grow history log
Go to SQL server Agent's Property
Click on -> History
change 1) Maximum job history log
2) Maximum job history rows per job......
|
-
Pothiraj Learned 2 Years ago through Just Learned | 1 Point
SQL Server job history contains only last 100 records.
To change or to grow history log
Go to SQL server Agent's Property
Click on -> History
change 1) Maximum job history log
2) Maximum job history rows per job......
|
-
Pothiraj Liked 2 Years ago through Just Learned | 1 Point
I just learned one new thing today,you cannot create snapshot of the system databases MASTER,MODEL and TEMPDB.you can create snapshot of MSDB database with following query.
[code]
CREATE DATABASE msdb_Snapshot
ON
(Name = MSDBData,--Database logical...
|
-
Pothiraj knew 2 Years ago through Just Learned | 1 Point
I just learned one new thing today,you cannot create snapshot of the system databases MASTER,MODEL and TEMPDB.you can create snapshot of MSDB database with following query.
[code]
CREATE DATABASE msdb_Snapshot
ON
(Name = MSDBData,--Database logical...
|
-
Pothiraj Liked 2 Years ago through Just Learned | 1 Point
I just learned one new thing today,you cannot create snapshot of the system databases MASTER,MODEL and TEMPDB.you can create snapshot of MSDB database with following query.
[code]
CREATE DATABASE msdb_Snapshot
ON
(Name = MSDBData,--Database logical...
|