|
|
-
Alpesh Patel Learned 10 Months ago through Just Learned | 1 Point
There are four schedule types.
1. One Time : It executes once as per the schedule
2. Recurring : It is recurring type and execute on specified interval on specified time till schedule end.
3. Start when CPU Idle : It executes when CPU is sufficien...
|
-
Alpesh Patel Liked 10 Months ago through Just Learned | 1 Point
There are four schedule types.
1. One Time : It executes once as per the schedule
2. Recurring : It is recurring type and execute on specified interval on specified time till schedule end.
3. Start when CPU Idle : It executes when CPU is sufficien...
|
-
Alpesh Patel Learned 10 Months ago through Just Learned | 1 Point
There are four schedule types.
1. One Time : It executes once as per the schedule
2. Recurring : It is recurring type and execute on specified interval on specified time till schedule end.
3. Start when CPU Idle : It executes when CPU is sufficien...
|
-
Alpesh Patel Posted 10 Months ago through Just Learned | 5 Points
There are four schedule types.
1. One Time : It executes once as per the schedule
2. Recurring : It is recurring type and execute on specified interval on specified time till schedule end.
3. Start when CPU Idle : It executes when CPU is sufficient f...
|
-
Alpesh Patel Posted 10 Months ago through Just Learned | 5 Points
There are four schedule types.
1. One Time : It executes once as per the schedule
2. Recurring : It is recurring type and execute on specified interval on specified time till schedule end.
3. Start when CPU Idle : It executes when CPU is sufficient f...
|
-
Alpesh Patel Liked 10 Months ago through Just Learned | 1 Point
There is lot of things, we are unaware about those.
We talk on some of that.
1. sp_msforeachdb: Runs a command with '?' replaced with each database name (v7 and up)
2. sp_stored_procedures: return a list of all stored procedures
3. HashBytes() and ...
|
-
Alpesh Patel Learned 10 Months ago through Just Learned | 1 Point
There is lot of things, we are unaware about those.
We talk on some of that.
1. sp_msforeachdb: Runs a command with '?' replaced with each database name (v7 and up)
2. sp_stored_procedures: return a list of all stored procedures
3. HashBytes() and ...
|
-
Alpesh Patel Liked 10 Months ago through Just Learned | 1 Point
There is lot of things, we are unaware about those.
We talk on some of that.
1. sp_msforeachdb: Runs a command with '?' replaced with each database name (v7 and up)
2. sp_stored_procedures: return a list of all stored procedures
3. HashBytes() and ...
|
-
Alpesh Patel Learned 10 Months ago through Just Learned | 1 Point
There is lot of things, we are unaware about those.
We talk on some of that.
1. sp_msforeachdb: Runs a command with '?' replaced with each database name (v7 and up)
2. sp_stored_procedures: return a list of all stored procedures
3. HashBytes() and ...
|
-
Alpesh Patel Liked 10 Months ago through Just Learned | 1 Point
A Tool **TableDiff** is very useful to compare the schema of tables and data of different SQL instances.
A Tool can do the things as below:
1. A row by row comparison between a source table in an instance of Microsoft SQL Server acting as a replica...
|