Forum Replies Created

Viewing 15 posts - 781 through 795 (of 9,244 total)

  • RE: To Delete / Truncate / Drop & Create

    I believe Stephen intends to retain the seed value hence my previous recommendation

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

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

    May 15, 2017 at 2:40 pm

    #1942626

  • RE: To Delete / Truncate / Drop & Create

    As I said try it for yourself

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

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

    May 15, 2017 at 2:06 pm

    #1942621

  • RE: To Delete / Truncate / Drop & Create

    If you run In a transaction without committing, yes

    Try it for yourself

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

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

    May 15, 2017 at 1:53 pm

    #1942618

  • RE: To Delete / Truncate / Drop & Create

    Truncate logs the page deallocations

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

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

    May 15, 2017 at 1:45 pm

    #1942616

  • RE: To Delete / Truncate / Drop & Create

    turn on identity insert for the table when loading

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

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

    May 15, 2017 at 8:36 am

    #1942572

  • RE: SQL Logical File names in GUI different than what's in the system databases

    run a tlog backup 😉

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

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

    May 15, 2017 at 6:56 am

    #1942529

  • RE: To Delete / Truncate / Drop & Create

    stephen.plant - Monday, May 15, 2017 3:58 AM

    Good Morning All,

    Can I Have some opinions please.

    Have 2 large tables I need to 'clean',...

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

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

    May 15, 2017 at 6:55 am

    #1942528

  • RE: Cluster Node Upgrade Failure

    run a cluster validation report and check the output

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

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

    May 15, 2017 at 4:37 am

    #1942499

  • RE: Cluster Node Upgrade Failure

    please post the output of this powershell script

    Get-ClusterResource | Get-ClusterOwnerNode

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

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

    May 12, 2017 at 9:18 am

    #1942359

  • RE: SQL Logical File names in GUI different than what's in the system databases

    MyDoggieJessie - Thursday, May 11, 2017 1:14 PM

    For some databases, I'm noticing discrepancies between the logical database file names that SQL Server...

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

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

    May 12, 2017 at 3:54 am

    #1942291

  • RE: What can cause a failure in SQL Server, when a prior admin's account is deleted?

    chuck.forbes - Wednesday, May 10, 2017 2:19 PM

    We had a prior DBA that had his AD account showing up as the owner...

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

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

    May 12, 2017 at 3:12 am

    #1942288

  • RE: Better dividing of mdf, log and tempdb on 3 disk server

    paolobianchi - Thursday, May 11, 2017 8:58 AM

    (i talk about 2 disk, but really they are 4 disk in Raid, so...

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

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

    May 11, 2017 at 9:24 am

    #1942181

  • RE: Single Node MSSQL 2012 cluster to Always on

    SQL Galaxy - Tuesday, May 9, 2017 1:31 AM

    Hello Perry,
    Combination of windows 2016 and SQL 2016 alwayson HA feature can support windows...

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

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

    May 11, 2017 at 7:51 am

    #1942167

  • RE: File server as a part of SQL cluster resource

    muzikfreakster - Monday, May 8, 2017 9:15 PM

    that doesn't answer my question . I want to know the use of file server...

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

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

    May 11, 2017 at 7:49 am

    #1942166

  • RE: Setup of High avilability DB Mirroring + Log shipping

    SQL Galaxy - Monday, May 8, 2017 10:41 PM

    1. Should be backup share folder should be access on SQL service account?

    The sql...

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

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

    May 11, 2017 at 7:21 am

    #1942161

Viewing 15 posts - 781 through 795 (of 9,244 total)