Viewing 15 posts - 61 through 75 (of 1,409 total)
The information form the "Job Activity" monitor can be queried from the tables in the [msdb] database. Join the [sysjobs] and [sysjobsteps] tables to get the details of the job...
March 8, 2018 at 4:34 am
The problem has re-occurred. I've uninstalled AntiVirus program, and disabled Windows Firewall, restarted SSMS but...
February 26, 2018 at 5:12 am
As from this URL: https://msdn.microsoft.com/en-us/library/azure/dn495240.aspx
Azure is the Windows PowerShell module that you can use to control and automate the deployment and management of your workloads in Azure....
February 22, 2018 at 4:36 am
Seggerman-675349 - Wednesday, February 21, 2018 2:14 PMI created a logical device on the database server
You need to create a logical device...
February 21, 2018 at 2:25 pm
It is possible if the device is (or can be made) available on the other server. From there you can do a normal restore action.
February 21, 2018 at 1:53 pm
February 21, 2018 at 1:11 pm
Hi HanShi,
The outputs of the first query are below. It does not hang it executes very...
February 21, 2018 at 11:54 am
Thank you. This is very interesting. Here are my results for the database...
February 20, 2018 at 8:26 am
Unfortunately the extended events approach was not really working for me. The Extended Events generated a lot of data, even though I extended the filter to only include the eXclusive...
February 20, 2018 at 8:10 am
Thanks, I will give it a try.
I was so focused on getting this information from a DMV I forgot to look at Extended Events :doze:
February 20, 2018 at 5:13 am
Create your WHERE something like:
WHERE [your_date_column] > DATEADD (year, -5 , GETDATE() )
Try to not wrap the function around your column so...
February 20, 2018 at 5:09 am
Have you followed the steps as shown here: https://www.tutorialgateway.org/line-chart-in-ssrs/ ?
February 16, 2018 at 7:46 am
February 16, 2018 at 6:42 am
I understood your question; I could have emphasized my answer better 😉
Putting all data files (per instance) on one drive and all log files (per instance) on another drive is...
February 15, 2018 at 8:18 am
Putting data files on one drive and log files on another drive is a common setup.
To see if you could have I/O performance issues you have to look for...
February 15, 2018 at 8:03 am
Viewing 15 posts - 61 through 75 (of 1,409 total)