Forum Replies Created

Viewing 15 posts - 61 through 75 (of 622 total)

  • RE: Data Privacy and Security: The Implications of GDPR

    "These people will need to be data experts with experience in security and a lot of knowledge about the protection of data"
    This is a nice idea, and one which...

  • RE: index frag

    Hi,
        as Jason's suggesting it's probably because it's a small table/index.  Initially SQL Server allocates storage in what are called mixed extents - i.e. the extent is shared with...

  • RE: tempdb curiosity

    GilaMonster - Wednesday, April 19, 2017 4:51 AM

    I dug into this a while back while testing how to recover from a crashed...

  • RE: tempdb curiosity

    GilaMonster - Wednesday, April 19, 2017 3:16 AM

    andrew gothard - Wednesday, April 19, 2017 2:32 AM

    April 19, 2017 at 4:43 am

    #1938758

  • RE: tempdb curiosity

    Also, with a tempdb anywhere near that size, I would make sure that Instant File Initialisation is set on.  If not, you're going to be twiddling your thumbs for some...

  • RE: By Design

    While there are, as stated, obvious risks to updating certain types of data via reports, I think it's highly unlikely that this ability would be removed.  That would then mean...

  • RE: Installing SQL Server: How much space to allocate for each drive?

    lindsayscott23 - Wednesday, April 5, 2017 9:58 AM

    Thanks both for the suggestions; really helpful.
    The server will be a development environment, so I...

  • RE: Is work just work?

    Whenever it gets to the stage where it is, I'm off.  Life's too short to spend a third or more of it stewing doing makework jobs IMO.  80%+ of the...

  • RE: SQL Server core usage

    GilaMonster - Wednesday, March 29, 2017 5:09 AM

    andrew gothard - Wednesday, March 29, 2017 5:06 AM

    March 29, 2017 at 5:20 am

    #1935462

  • RE: SQL Server core usage

    The following query will give you a few hours worth of CPU utilization from the DM views

  • RE: SQL Server core usage

    Another thing I'd add is that's potentially a lot of cores for a VM.  In a SQL Server VM environment you really, really want to avoid drastic over provisioning like...

  • RE: Change Approvals

    mike.mcquillan - Friday, March 24, 2017 2:52 AM

    I 100% agree with Jeff...nobody should deploy their own code.

    ...

    I've seen that end *very* badly.
    At...

  • RE: What can dbowner not do?

    Oh, one other thing to bear in mind.  Check their support contract.
    In spite of their demand for God Mode, I bet you what you like if they hose your*...

  • RE: What can dbowner not do?

    ZZartin - Tuesday, March 21, 2017 9:58 AM

    It really depends on why exactly they think SA is required.

    One option if they absolutely...

  • RE: Data is getting deleted automatically from Database

    Thom's suggestion makes sense to me too, you could also log the pc being used
    SELECT ... SUSER_NAME(), HOST_NAME()

Viewing 15 posts - 61 through 75 (of 622 total)