|
|
-
RAM Liked 10 Months ago through Blogs
SQL Server Wait Types are important factors to consider while analyzing performance problems of SQL Server databases. If you notice a particular wait type is occurring too often or for too long, it indicates a problem in most cases. There are several d...
|
-
RAM learned 10 Months ago through Blogs
I found this question in this SSC forum thread requesting help to shape the XML document. Here is the input XML document.
Jhon
Luka
1
2
The expected output is as follows.
Jhon
Luka
1
2
Th...
|
-
RAM Liked 10 Months ago through Blogs
I found this question in this SSC forum thread requesting help to shape the XML document. Here is the input XML document.
Jhon
Luka
1
2
The expected output is as follows.
Jhon
Luka
1
2
Th...
|
-
RAM liked 11 Months ago through Scripts
This script demonstrates how to backup a database to a network share (i.e. UNC path). This script is written to take a full database backup for demonstration purposes. However, you can customize this script to suit your backup strategy (differential/log...
|
-
RAM liked 11 Months ago through Scripts
This script helps restore a database from a backup file lying on a network share (i.e. UNC path). Please customize this script for your configuration. For demonstration purposes, this script has been written to perform a complete restore of the database...
|
-
RAM Learned 11 Months ago through Just Learned
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...
|
-
RAM Liked 11 Months ago through Just Learned
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...
|
-
RAM Learned 11 Months ago through Just Learned
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...
|
-
RAM Liked 11 Months ago through Just Learned
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...
|
-
RAM knew 1 Years ago through Just Learned
I tried uploading Adventure Works DW Image files which were > 100 in number on a SharePoint 2010 Shared Document and I got an error that says "Select less than 100 files to add to shared folder". I searched a little and figured this constraint is to ...
|