Forum Replies Created

Viewing 15 posts - 766 through 780 (of 9,244 total)

  • RE: add 2nd data file and limit the size of 1st datafile

    sqlguy80 - Saturday, May 20, 2017 9:58 PM

    Hi,
    We have two drives for data files and I've been asked to go to each...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Cannot Login - No Process on the other end of the pipe

    somdip - Friday, May 19, 2017 5:04 AM

    travens - Tuesday, August 16, 2016 3:05 PM

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: string to time conversion problem

    the literal values need to have a colon separator for hours and minutes. You dont seem to have this in all of the comparisons

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

    admin 31599 - Thursday, May 18, 2017 8:42 AM

    Perry Whittle - Thursday, May 18, 2017 8:33 AM

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Delete nologging

    NorthernSoul - Thursday, May 18, 2017 5:08 AM

    From what I recall (feel free to correct me anyone) but a truncate will reseed...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

    at the time your query runs it is running out of tempdb space, likely because other users have space allocated for their queries too.
    Restarting works because you sever all...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL Server 2016 Failover Cluster - Installing SP1 CU3 Error

    have you moved the databases post the sql server installation?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL Server 2016 Enterprise Edition

    AlwaysOn FCI or AG introdcues Windows Server Failover Clustering and that affects licensing too.
    Give more detail on your intended design and also consult your Microsoft licensing agent for accurate...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Transaction Log Growing

    contact 14920 - Wednesday, May 17, 2017 5:16 AM

    Perry Whittle - Wednesday, May 17, 2017 4:56 AM

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Transaction Log Growing

    you may have to increase the frequency of your log backups

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: To Delete / Truncate / Drop & Create

    Jeff Moden - Tuesday, May 16, 2017 9:49 AM

    Perry Whittle - Tuesday, May 16, 2017 3:16 AM

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Memory consumption- Windows or SQL Server

    coolchaitu - Monday, May 8, 2017 1:44 AM

    The server has 640 GB. SQL Server max server memory value is set to 605GB....

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: To Delete / Truncate / Drop & Create

    Jeff Moden - Tuesday, May 16, 2017 2:47 AM

    Perry Whittle - Tuesday, May 16, 2017 1:20 AM

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: To Delete / Truncate / Drop & Create

    I agree, you probably won't even use it but the statement that a truncate does not log is untrue and I corrected this.

    Personally I don't care two hoots whether you...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 766 through 780 (of 9,244 total)