Forum Replies Created

Viewing 15 posts - 16 through 30 (of 372 total)

  • RE: SSRS Running Extremely Slow

    Not seeing any error in the log files. What should I look for in the executionlog3?

    MCSE SQL Server 2012\2014\2016

    July 27, 2018 at 12:09 pm

    #1999291

  • RE: Query Help

    Jason A. Long - Sunday, October 15, 2017 1:41 PM

    I'm not sure why I didn't spot this yesterday, but the fact that,...

    MCSE SQL Server 2012\2014\2016

    October 16, 2017 at 3:11 pm

    #1963937

  • RE: Query Help

    Jason A. Long - Saturday, October 14, 2017 7:34 PM

    Apply some formatting and thing become easier to see...

    SELECT DISTINCT
      t.GLStoreNum,
     ...

    MCSE SQL Server 2012\2014\2016

    October 15, 2017 at 10:07 am

    #1963729

  • RE: Query Help

    ZZartin - Friday, October 13, 2017 1:31 PM

    What exactly is the problem?  Your query is returning rows that have not a 25...

    MCSE SQL Server 2012\2014\2016

    October 13, 2017 at 4:53 pm

    #1963657

  • RE: Query Help

    below86 - Friday, October 13, 2017 1:44 PM

    Your statement:
    Nested case stmt
    (case when gn.glacctid = 25 then t.amex end ) +
    (case when gn.acctid...

    MCSE SQL Server 2012\2014\2016

    October 13, 2017 at 4:52 pm

    #1963656

  • RE: Query Help

    updating original query and post

    MCSE SQL Server 2012\2014\2016

    October 13, 2017 at 2:30 pm

    #1963649

  • RE: creating new partition files on table

    GilaMonster - Thursday, April 27, 2017 8:14 AM

    lkennedy76 - Wednesday, April 26, 2017 9:25 AM

    MCSE SQL Server 2012\2014\2016

    April 27, 2017 at 8:38 am

    #1940223

  • RE: creating new partition files on table

    GilaMonster - Thursday, April 27, 2017 8:16 AM

    lkennedy76 - Tuesday, April 25, 2017 8:28 AM

    MCSE SQL Server 2012\2014\2016

    April 27, 2017 at 8:36 am

    #1940222

  • RE: creating new partition files on table

    They won't switch back into the partitioned table, I haven't moved anything yet, I was just testing and preparing to make sure I had everything correct. I thought I will...

    MCSE SQL Server 2012\2014\2016

    April 26, 2017 at 9:25 am

    #1940008

  • RE: creating new partition files on table

    Once you're sure everything's correct, drop the table that you switched out in step 1 (the one with 2.4 billion rows in it)  

    Step one is the inventory file...

    MCSE SQL Server 2012\2014\2016

    April 25, 2017 at 8:28 am

    #1939766

  • RE: creating new partition files on table

    Gail,

      I am starting this process today, I will post my step and results when I am done. I really hope this will help someone else in my...

    MCSE SQL Server 2012\2014\2016

    April 24, 2017 at 8:43 am

    #1939556

  • RE: creating new partition files on table

    yes April 2017.
    Here's what I have done so far;
    Create new ndf files and filegroups for 05 2016 to 12 2016.
    Created tables for 05 2016 to 12...

    MCSE SQL Server 2012\2014\2016

    April 19, 2017 at 12:43 pm

    #1938920

  • RE: creating new partition files on table

    GilaMonster - Wednesday, April 19, 2017 8:18 AM

    No.

    I mean, you can do that, but you're looking at a couple of days for...

    MCSE SQL Server 2012\2014\2016

    April 19, 2017 at 9:22 am

    #1938850

  • RE: creating new partition files on table

    GilaMonster - Tuesday, April 18, 2017 1:45 PM

    If the split takes time then there's data that needs to be moved to the...

    MCSE SQL Server 2012\2014\2016

    April 19, 2017 at 9:13 am

    #1938848

  • RE: creating new partition files on table

    ok, thanks.

    MCSE SQL Server 2012\2014\2016

    April 19, 2017 at 8:45 am

    #1938838

Viewing 15 posts - 16 through 30 (of 372 total)