Forum Replies Created

Viewing 15 posts - 3,136 through 3,150 (of 49,552 total)

  • RE: Probability of a corrupt SQL Server installation after installing a component or SP

    The IS in SSIS stands for Integration Services, not integrated services.

    And installing that is a separate service, so it won't mess with the database engine other than to create a...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 2, 2016 at 12:47 pm

    #1875987

  • RE: Probability of a corrupt SQL Server installation after installing a component or SP

    And what exactly do you mean by 'Integrated Services'?

    Service pack, only if it fails or breaks part way through.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 2, 2016 at 12:20 pm

    #1875981

  • RE: Question on index rebuilds

    Literally that. A round trip across the network, client to server and back.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 2, 2016 at 11:43 am

    #1875970

  • RE: Probability of a corrupt SQL Server installation after installing a component or SP

    After creating an SP. 0.

    What do you mean by 'component'?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 2, 2016 at 11:42 am

    #1875969

  • RE: Where was the output from a SELECT go in a trigger?

    jeff.mason (5/2/2016)

    Oh, you don't want to do that, especially in a system with MARS involved. That would cause multiple recordsets potentially. You probably want to make a log table...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 2, 2016 at 11:03 am

    #1875950

  • RE: Where was the output from a SELECT go in a trigger?

    It's returned to the caller, but since the Edit window doesn't have any way to show resultsets coming back, it would have been discarded by SSMS.

    Write an update statement, and...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 2, 2016 at 10:56 am

    #1875947

  • RE: Max Degree of Parallelism - 24 Core processor 2 NUMA nodes

    Parallelism isn't a problem.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 2, 2016 at 7:56 am

    #1875902

  • RE: Cannot specify a column width on data type ntext - SQL Server 2014 Enterprise (64 bit)

    Firstly you should be using nvarchar(max) since ntext has been deprecated for ~11 years, but the problem does sound like the width. ntext isn't defined with a width, it's just...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 2, 2016 at 7:52 am

    #1875899

  • RE: Question on index rebuilds

    vsamantha35 (5/2/2016)

    I wanted to know what is the difference between below 2 sets (Set1 & Set2).

    The first requires one network round trip, the second multiple. That's all.

    Second question, is...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 2, 2016 at 7:19 am

    #1875882

  • RE: Max Degree of Parallelism - 24 Core processor 2 NUMA nodes

    I suggest you get familiar with the SQL documentation (Books Online)

    https://msdn.microsoft.com/en-us/library/ms189631.aspx answers both that and earlier questions.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 2, 2016 at 7:17 am

    #1875881

  • RE: Are the posted questions getting worse?

    FYI

    https://blogs.technet.microsoft.com/dataplatforminsider/2016/05/02/get-ready-sql-server-2016-coming-on-june-1st/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 2, 2016 at 7:15 am

    #1875879

  • RE: Max Degree of Parallelism - 24 Core processor 2 NUMA nodes

    Fix that first. 5 is insanely low. Set it higher.

    As for the rest, the numa config is written into the error log on startup. The guidelines are either number of...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 2, 2016 at 6:18 am

    #1875862

  • RE: CMEMTHREAD Wait type - need explanation and solution for this

    info.sqldbamail (5/1/2016)

    Okay can you please suggest me how much sizes of tempdb data files(Max = 8) should be added for a 300 GB production database with 24 core processors

    Absolutely no...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 2, 2016 at 3:12 am

    #1875835

  • RE: CMEMTHREAD Wait type - need explanation and solution for this

    info.sqldbamail (5/1/2016)

    where we have 24 core processors and we have increase tempdb datafile.

    I hope not to 24.

    I have one doubt do we need to disable autogrowth for tempdb and set...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 1, 2016 at 2:03 pm

    #1875811

  • RE: SQL Server 2008 R2 to 2014 upgrade - performance degradation

    N_Muller (4/29/2016)

    Grant Fritchey (4/29/2016)

    N_Muller (4/28/2016)

    Or is it a hit and miss in terms of queries that perform poorly.

    I'll just pile on and agree.

    The main issues I've seen are with multi-statement,...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 29, 2016 at 8:54 am

    #1875608

Viewing 15 posts - 3,136 through 3,150 (of 49,552 total)