|
|
-
Jacob Sebastian knew 8 Months ago through Just Learned | 1 Point
A simple method to find out who altered/modified an object in SQL server using trace.
SELECT I.*
FROM
sys.traces T
CROSS Apply ::fn_trace_gettable(T.path, T.max_files) I
Join sys.trace_events E On I.eventclass = E.trace_event_i...
|
-
Jacob Sebastian Liked 8 Months ago through Just Learned | 1 Point
In context of Master Data Management (MDM), I just learned the difference between reference data vs. master data (a.k.a master reference data). Reference data is business data used in a "single" app/system/process. Whereas Master Data is business dat...
|
-
Jacob Sebastian knew 8 Months ago through Just Learned | 1 Point
In context of Master Data Management (MDM), I just learned the difference between reference data vs. master data (a.k.a master reference data). Reference data is business data used in a "single" app/system/process. Whereas Master Data is business dat...
|
-
Jacob Sebastian Liked 8 Months ago through Just Learned | 1 Point
Do you know ANSI-92 versions of T-SQL therefore early 6.5 version was so programmatically influenced. This was tha old-style LEFT OUTER JOIN syntax.
SELECT TableX.ID, TableY.ID
FROM TableX, TableY
WHERE TableX.ID *= TableY.ID
T...
|
-
Jacob Sebastian knew 8 Months ago through Just Learned | 1 Point
Do you know ANSI-92 versions of T-SQL therefore early 6.5 version was so programmatically influenced. This was tha old-style LEFT OUTER JOIN syntax.
SELECT TableX.ID, TableY.ID
FROM TableX, TableY
WHERE TableX.ID *= TableY.ID
T...
|
-
Jacob Sebastian Liked 8 Months ago through Just Learned | 1 Point
Do you know ANSI-92 versions of T-SQL therefore early 6.5 version was so programmatically influenced. This was tha old-style LEFT OUTER JOIN syntax.
SELECT TableX.ID, TableY.ID
FROM TableX, TableY
WHERE TableX.ID *= TableY.ID
T...
|
-
Jacob Sebastian knew 8 Months ago through Just Learned | 1 Point
Do you know ANSI-92 versions of T-SQL therefore early 6.5 version was so programmatically influenced. This was tha old-style LEFT OUTER JOIN syntax.
SELECT TableX.ID, TableY.ID
FROM TableX, TableY
WHERE TableX.ID *= TableY.ID
T...
|
-
Jacob Sebastian Commented 9 Months ago through Just Learned | 1 Point
Abishek,
This is more ideal to be in the [scripts module][1]. I would recommend you post it there.
[1]: http://beyondrelational.com/modules/30/scripts.aspx?s=stream&tab=scripts...
|
-
Jacob Sebastian Commented 9 Months ago through Just Learned | 1 Point
Abishek,
This is more ideal to be in the [scripts module][1]. I would recommend you post it there.
[1]: http://beyondrelational.com/modules/30/scripts.aspx?s=stream&tab=scripts...
|
-
Jacob Sebastian Liked 9 Months ago through Just Learned | 1 Point
One can view & print excel files on computers that do not have excel installed. search for "excel viewer" .
Business scenario: when it does not make sense to buy a license when all you need is view & print excel files. ...
|