Forum Replies Created

Viewing 15 posts - 361 through 375 (of 5,841 total)

  • RE: The Accidental DBA - Wait Stats

    GilaMonster - Monday, March 6, 2017 3:56 AM

    I think they are all cumulative.

    They are. Cumulative since SQL started (most...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 6, 2017 at 6:52 am

    #1931776

  • RE: checkdb "Multiple IAM pages for object"

    I figured you had already gotten this one Gail.

    sgt500: She is one of the best around at dealing with database corruptions. Pay attention and do as she says...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 6, 2017 at 6:46 am

    #1931775

  • RE: De-Concatenate multi-select picklist and transform into target multi-select picklist values

    aldous.chris - Monday, March 6, 2017 5:59 AM

    Hi, 

    I have a requirement where I have to tranform an existing multi-select picklist column.

    The source...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 6, 2017 at 6:42 am

    #1931774

  • RE: Cursor Insert into table with IDENTITY crisis

    TriggerMan - Saturday, March 4, 2017 9:35 PM

    Thank you for the response.  I do appreciate it!  Just to give my pointless replies....

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 5, 2017 at 9:20 am

    #1931697

  • RE: Cursor Insert into table with IDENTITY crisis

    1) WITH (NOLOCK) allows for dirty reads. So you could have other processes running that are creating conflicts. Concurrency is a tough thing to deal with.

    2) I don't...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 4, 2017 at 10:02 am

    #1931674

  • RE: Indexing Small Temp Tables used to JOIN based on a value being in a range...

    Well, if you can have tens of thousands, or perhaps just 1000 or even 100, different ranges to name the CASE construct could become unwieldy and/or result in a long...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 1, 2017 at 8:16 am

    #1930977

  • RE: Can you set up AlwaysOn between two different clusters?

    JP10 - Tuesday, February 28, 2017 3:56 PM

    I have Cluster1 with 2 nodes and a whole different Cluster2 with 2 nodes.  Can...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 28, 2017 at 4:20 pm

    #1930855

  • RE: Help me understand my wait stats.

    PretendDBA - Tuesday, February 28, 2017 3:50 PM

    Row WaitType Wait_Seconds Resource_Seconds Signal_Seconds WaitCount Percentage Avg Wait Seconds Avg Res Seconds Avg Sig Seconds
    1 CXPACKET 589948.94 570810.50 19138.43 345459657 47.68 0.0017 0.0017 0.0001 
    2 PAGELATCH_EX 208483.86 178007.43 30476.44 5792692289 16.85 0.0000 0.0000 0.0000 
    3 PAGELATCH_SH 148325.81 120946.88 27378.93 5338779307 11.99 0.0000 0.0000 0.0000 
    4 WRITELOG 97564.14 96075.60 1488.54 44147954 7.88 0.0022 0.0022 0.0000 
    5 ASYNC_NETWORK_IO 67784.65 67248.08 536.57 47742563 5.48 0.0014 0.0014 0.0000 
    6 ASYNC_IO_COMPLETION 31958.75 31958.51 0.24 20825 2.58 1.5346 1.5346 0.0000 
    7 BACKUPBUFFER 25527.95 25413.91 114.04 19409950 2.06 0.0013 0.0013 0.0000 
    8 LATCH_EX 21692.23 18961.47 2730.76 230726223 1.75 0.0001 0.0001 0.0000 

    Do these wait stats suggest Tempdb pressure? I have...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 28, 2017 at 4:18 pm

    #1930854

  • RE: Indexing Small Temp Tables used to JOIN based on a value being in a range...

    Oh, some more thoughts:

    A) What happens if you have NO indexes on those tables? I can't count the number of times I have removed indexes from client temp...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 28, 2017 at 3:28 pm

    #1930845

  • RE: Indexing Small Temp Tables used to JOIN based on a value being in a range...

    sgmunson - Tuesday, February 28, 2017 2:09 PM

    ScottPletcher - Tuesday, February 28, 2017 1:48 PM

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 28, 2017 at 3:21 pm

    #1930844

  • RE: Indexing Small Temp Tables used to JOIN based on a value being in a range...

    First quick reply:

    why this:
    IF EXISTS (SELECT 1 FROM #SELECTED_HITS AS H WHERE H.RangeName = 'ANY HIT RANGE')
      BEGIN
      DELETE S
      FROM #SELECTED_HITS...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 28, 2017 at 3:15 pm

    #1930841

  • RE: Partitioning approaches

    abhisheka.dalal - Tuesday, February 28, 2017 10:41 AM

    Henrico Bekker - Tuesday, February 28, 2017 10:20 AM

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 28, 2017 at 11:31 am

    #1930776

  • RE: Partitioning approaches

    abhisheka.dalal - Tuesday, February 28, 2017 10:11 AM

    Hello Friends,

    This is regarding Partitioning of a very large table(88 million rows and 25 columns)....

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 28, 2017 at 10:24 am

    #1930762

  • RE: Memory Problem: Low buffer cache,low PLE, but High free page

    graciez - Thursday, February 23, 2017 1:11 PM

    Thank you! We are actually planning move to a more power server. 
    I had stopped the...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 27, 2017 at 6:11 pm

    #1930594

  • RE: Performance improves after reboot

    RVO - Monday, February 27, 2017 2:57 PM

    Hi guys,

    Today we have big problems with Availability Group (AG) synchronization.
    Secondary cannot catch up with...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 27, 2017 at 6:07 pm

    #1930593

Viewing 15 posts - 361 through 375 (of 5,841 total)