|
|
-
Krishnrajsinh Rana Liked 11 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...
|
-
Krishnrajsinh Rana Liked 12 Months ago through Just Learned | 1 Point
RELOG command can be used to convert the performance counters collected in binary format to CSV format. There are many more options available.
relog C:\PerfLogs\Baseline.blg -o C:\PerfLogs\Baseline.csv -f csv...
|
-
Krishnrajsinh Rana Liked 12 Months ago through Just Learned | 1 Point
RELOG command can be used to convert the performance counters collected in binary format to CSV format. There are many more options available.
relog C:\PerfLogs\Baseline.blg -o C:\PerfLogs\Baseline.csv -f csv...
|
-
Krishnrajsinh Rana Learned 12 Months ago through Just Learned | 1 Point
RELOG command can be used to convert the performance counters collected in binary format to CSV format. There are many more options available.
relog C:\PerfLogs\Baseline.blg -o C:\PerfLogs\Baseline.csv -f csv...
|
-
Krishnrajsinh Rana Learned 12 Months ago through Just Learned | 1 Point
RELOG command can be used to convert the performance counters collected in binary format to CSV format. There are many more options available.
relog C:\PerfLogs\Baseline.blg -o C:\PerfLogs\Baseline.csv -f csv...
|
-
Krishnrajsinh Rana Learned 12 Months ago through Just Learned | 1 Point
With help of below query we can quickly find the node on which sql is currently running. This is useful in clustered environments.
Select serverproperty('ComputerNamePhysicalNetBIOS')...
|
-
Krishnrajsinh Rana Learned 12 Months ago through Just Learned | 1 Point
With help of below query we can quickly find the node on which sql is currently running. This is useful in clustered environments.
Select serverproperty('ComputerNamePhysicalNetBIOS')...
|
-
Krishnrajsinh Rana Liked 12 Months ago through Just Learned | 1 Point
With help of below query we can quickly find the node on which sql is currently running. This is useful in clustered environments.
Select serverproperty('ComputerNamePhysicalNetBIOS')...
|
-
Krishnrajsinh Rana Liked 12 Months ago through Just Learned | 1 Point
With help of below query we can quickly find the node on which sql is currently running. This is useful in clustered environments.
Select serverproperty('ComputerNamePhysicalNetBIOS')...
|
-
Krishnrajsinh Rana Liked 12 Months ago through Just Learned | 1 Point
I learned about this from Pinal Dave's blog(You can see the original article in references.)
In SQL Server, while creating a table, we can give maximum length of 128 characters. However, while creating temp tables, maximum length can be of 116 chara...
|