Forum Replies Created

Viewing 15 posts - 3,556 through 3,570 (of 4,477 total)

  • RE: SQL Server Agent is not visible in services.msc

    vigneshbeece - Saturday, May 20, 2017 3:10 AM

    I installed SQL Server 2008R2 standard edition (spanish) in node A on cluster server....

    May 23, 2017 at 11:20 am

    #1943855

  • RE: Reserved space

    krishnabudampati - Tuesday, May 23, 2017 7:51 AM

    Does it reconmmended to release reserved space of a table?

    I have a table with  reserved...

    May 23, 2017 at 9:05 am

    #1943819

  • RE: Reports seem to be caching and how do I turn it off

    WebTechie - Monday, May 22, 2017 8:24 AM

    hello,

    I found an article that tells how to create a report, display a status and then...

    May 23, 2017 at 8:49 am

    #1943811

  • RE: Get the result based on some threshold values

    Not sure how someone can view 2 million rows or even 1 million at once. It doesn't sound like a sound requirement so maybe it should be revisited....

    May 23, 2017 at 7:59 am

    #1943791

  • RE: Malicious Mischief - How to identify the perpetrator?

    One of the first things I would do is to not assume it's someone who is a current sysadmin with the company. It could be someone who...

    May 19, 2017 at 4:08 pm

    #1943400

  • RE: SQL SERVER 2008 R2 Fail over occurred in clustering environment

    Sandeep DBA - Thursday, May 18, 2017 2:43 PM

    My question why these clustering errors are occurred this relevant to SQL server or...

    May 18, 2017 at 5:45 pm

    #1943215

  • RE: SQL Services not auto restarting after windows patches

    Yes - haven't had any problems with that. Read the comments in the post since neither of the respondents agreed. He had problems with Windows starting up,...

    May 18, 2017 at 1:23 pm

    #1943195

  • RE: Image column is truncated when moving data between two servers

    SQL Agent connections will set the textsize to 1024. In the job, you would want to execute SET TEXTSIZE 2147483647
    before calling your stored...

    May 18, 2017 at 12:05 pm

    #1943171

  • RE: tempdb: filegroup is full while space is available both in filegroup & transaction log

    And it's telling you the primary filegroup is full so you would want to look at the data files not the log file. The size, space needed,...

    May 18, 2017 at 8:40 am

    #1943120

  • RE: ServerSizes

    Ed Wagner - Wednesday, May 17, 2017 9:54 PM

    Sue, it's nice to see someone who remembers this technique.  I still have...

    May 18, 2017 at 8:26 am

    #1943108

  • RE: ServerSizes

    sqlnewbie17 - Thursday, May 18, 2017 12:07 AM

    I need server size difference for any 2 dates which are 30 days apart.
    The query...

    May 18, 2017 at 8:21 am

    #1943106

  • RE: ServerSizes

    sqlnewbie17 - Wednesday, May 17, 2017 12:00 AM

    My table data.
    date column values sample : 2017-05-16 03:14:59.647
    Server1    100        1/1/2016
    Server2    100        1/1/2016
    Server3    100        1/1/2016
    Server4    100        1/1/2016
    Server5    100        1/1/2016
    Server6    100        1/1/2016
    Server1    200        2/1/2016
    Server2    200        2/1/2016
    Server3    200        2/1/2016
    Server4    200        2/1/2016
    Server5    200        2/1/2016
    Server6    200        2/1/2016
    Server1    300        3/1/2016
    Server2    300        3/1/2016
    Server3    300        3/1/2016
    Server4    300        3/1/2016
    Server5    300        3/1/2016
    Server6    300        3/1/2016
    Server1    400        4/1/2016
    Server2    400        4/1/2016
    Server3    400        4/1/2016
    Server4    400        4/1/2016
    Server5    400        4/1/2016
    Server6    400        4/1/2016

    These are my Servers and their sizes...

    May 17, 2017 at 8:37 pm

    #1943036

  • RE: LCK_M_IX ON Truncate table

    If the truncate is waiting with a wait type LCK_M_IX lock it means it's waiting for an Intent Exclusive lock and some other incompatible lock has it waiting. And...

    May 17, 2017 at 1:10 pm

    #1942998

  • RE: Oh double hop, you're so fun ... Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

    Adam Bean - Wednesday, May 17, 2017 11:20 AM

    Well, after waiting it out and coming back ... it's all working. So moral...

    May 17, 2017 at 11:25 am

    #1942987

  • RE: Best practice for alerting via 3rd party tool

    JaybeeSQL - Wednesday, May 17, 2017 8:22 AM

    It was a good try, but no cigar ;(

    I ran :

    Select

    May 17, 2017 at 8:59 am

    #1942942

Viewing 15 posts - 3,556 through 3,570 (of 4,477 total)