Forum Replies Created

Viewing 15 posts - 61 through 75 (of 9,244 total)

  • Reply To: indexes cleanup

    If you need extra disk space extend the disks

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: logshipping is out of synch need to debug

    Will be disk issue most likely

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: Removing Filestream - How?

    amy26 wrote:

    I dunno why I can't wrap my head around this... but I'm so confused how creating a brand new table that ISN'T filestream... still keeps the files intact.Β  Where...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: Removing Filestream - How?

    ratbak wrote:

    though I'd recommend at least considering storing files w/ operating system and just storing paths in the database

    That’s what filestream does, stores the files directly on a dedicated Β ntfs...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: Removing Filestream - How?

    amy26 wrote:

    Thank you for confirming that sql developer will accomplish what I wanted to move to Oracle.

    never confirmed that, that’s a whole different ball game.

    to get access to the raw...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: Removing Filestream - How?

    amy26 wrote:

    Yes, I have been scouring documentation for the past 2 days and finding it very difficult to get information on this feature.

    I found multiple docs on first search

     

    amy26 wrote:

    I...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: Encryption & Decryption in SQL Server

    aside what Ken stated, what have you done so far to produce your own solution

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: Are the posted questions getting worse?

    anyone finding the posts in last couple months are real Facepalmers

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: Removing Filestream - How?

    Have you checked the documentation for Filestream.

    The files are not stored in filestream data file, the symbolic links to the OS level file are stored.

    I strongly recommend you read all...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: increase in database size

    you can't realistically expect the answer to this from a forum post, we have no way of knowing what's driving the size changes.

    Check index create dates and find out if...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: indexes cleanup

    whats changed recently, has someone created new indexes by any chance?

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: Canot connect to Prod1

    There are 2 permissions that need to be applied to service accounts when running under a low privilege domain account

    • writeserviceprincipalname
    • readserviceprincipalname

    some AD admins don’t like to grant these some...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: Canot connect to Prod1

    You can see if SPNs are generated automatically from the sql error log

    if not generated automatically would warrant further inspection to see if they have been manually created

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: logshipping is out of synch need to debug

    How often does the log backup agent job run?

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: Canot connect to Prod1

    What is the error detail from the sql error log

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

Viewing 15 posts - 61 through 75 (of 9,244 total)