Forum Replies Created

Viewing 15 posts - 706 through 720 (of 9,244 total)

  • RE: Installing SQL native client 11.0 on SQL 2008 R2 clustered instance

    if i remember correctly, the installer will upgrade the native client

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

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

  • RE: Node down or Failover or Service Stop

    Rechana Rajan - Tuesday, June 13, 2017 4:40 AM

    Perry Whittle - Monday, June 12, 2017 4:53 AM

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

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

  • RE: Installing SQL native client 11.0 on SQL 2008 R2 clustered instance

    its installed on the node and not related to the cluster install.
    Drill into the installer folders and find the native client MSI file there

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

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

  • RE: Daily FULL backups?

    daily fulls can consume huge amounts of space if the database is large.
    Daily diffs are usually a lot smaller although there may be cases where the diffs are huge...

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

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

  • RE: AlwaysOn - adding secondary problem

    are the instances on the same physical node in the cluster

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

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

  • RE: AlwaysOn- Behaviour

    Ram:) - Monday, June 12, 2017 7:40 AM

    Hi,
    We have configured an alwayson in multisubnet environment(Primary in 10.1.10.X and secondary in 10.2.10.X). We...

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

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

  • RE: Node down or Failover or Service Stop

    anytime the sql server service goes offline the cache will be lost

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

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

  • RE: Stopping Service in Cluster

    Rechana Rajan - Sunday, June 11, 2017 3:29 AM

    Thanks Perry,

    I did as per your words and stopped service from SCM waited...

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

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

  • RE: Stopping Service in Cluster

    The resource stayed offline and didn't fail over?

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

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

  • RE: Unable to telnet to port TCP 443

    silly question but have you actually configured the SSRS instance for HTTPS, the default is HTTP on port 80

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

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

  • RE: Locking behaviour

    GilaMonster - Friday, June 9, 2017 5:52 AM

    Perry Whittle - Friday, June 9, 2017 4:41 AM

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

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

  • RE: Statistics.

    Grant Fritchey - Friday, June 9, 2017 6:47 AM

    We had a VERY badly designed database where we were updating the statistics...

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

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

  • RE: Locking behaviour

    vsamantha35 - Thursday, June 8, 2017 7:18 PM

    Hi All,

    We have a SELECT query which runs for almost 9 hours queing up CXPACKET...

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

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

  • RE: Statistics.

    ben.brugman - Friday, June 9, 2017 3:33 AM

    Hello all,

    From our developers I get the signal that regenerating the statistics does improve performance...

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

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

  • RE: Statistics.

    GilaMonster - Friday, June 9, 2017 3:55 AM

    Stats that are a few weeks old on a table that's constantly getting data modifications...

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

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

Viewing 15 posts - 706 through 720 (of 9,244 total)