Forum Replies Created

Viewing 15 posts - 61 through 75 (of 1,409 total)

  • RE: SQL query against Job Activity Monitor

    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...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    March 8, 2018 at 4:34 am

    #1982364

  • RE: SQL Server (MSSQLSERVER) keeps Stopping

    VegasL - Sunday, February 25, 2018 3:16 PM

    Hello,

    The problem has re-occurred. I've uninstalled AntiVirus program, and disabled Windows Firewall, restarted SSMS but...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    February 26, 2018 at 5:12 am

    #1981068

  • RE: Need help with file not found error message.

    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....

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    February 22, 2018 at 4:36 am

    #1980745

  • RE: Can I Restore with Device to Database on another Server?

    Seggerman-675349 - Wednesday, February 21, 2018 2:14 PM

    I created a logical device on the database server

    You need to create a logical device...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    February 21, 2018 at 2:25 pm

    #1980689

  • RE: Can I Restore with Device to Database on another Server?

    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.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    February 21, 2018 at 1:53 pm

    #1980682

  • RE: SQLCMD: Getting Access Denied

    wak_no1 - Wednesday, February 21, 2018 11:14 AM

    I'm getting: Sqlcmd: Error: Error occurred while opening or operating on file \\servername\C$\directory\test.sql (Reason: Access...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    February 21, 2018 at 1:11 pm

    #1980676

  • RE: UPDATE works in SSMS but hangs in command line

    sjyoklic - Wednesday, February 21, 2018 9:22 AM

    Hi HanShi,

    The outputs of the first query are below.  It does not hang it executes very...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    February 21, 2018 at 11:54 am

    #1980665

  • RE: Transaction Log Growth

    Mike Scalise - Tuesday, February 20, 2018 7:31 AM

    Chris,

    Thank you. This is very interesting. Here are my results for the database...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    February 20, 2018 at 8:26 am

    #1980470

  • RE: how to get an overview of locks that aren't released for a period of time

    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...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    February 20, 2018 at 8:10 am

    #1980461

  • RE: how to get an overview of locks that aren't released for a period of time

    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:

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    February 20, 2018 at 5:13 am

    #1980418

  • RE: 5 years or older

    Create your WHERE something like:

    WHERE  [your_date_column] > DATEADD (year, -5 , GETDATE() ) 

    Try to not wrap the function around your column so...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    February 20, 2018 at 5:09 am

    #1980414

  • RE: Line chart from table containing static values

    Have you followed the steps as shown here: https://www.tutorialgateway.org/line-chart-in-ssrs/ ?

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    February 16, 2018 at 7:46 am

    #1980064

  • RE: Stored procedure not executing in Linked Server

    adilahmed1989 - Friday, February 16, 2018 5:39 AM

    Have a problem in which stored procedure is not getting executing it through a SQL...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    February 16, 2018 at 6:42 am

    #1980059

  • RE: Sql server 2012 Log and file data

    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...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    February 15, 2018 at 8:18 am

    #1979919

  • RE: Sql server 2012 Log and file data

    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...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    February 15, 2018 at 8:03 am

    #1979908

Viewing 15 posts - 61 through 75 (of 1,409 total)