Forum Replies Created

Viewing 15 posts - 1 through 15 (of 50 total)

  • Reply To: File sizing

    Thanks for the replies.

    Yes, we are working on alerts now.

    In our case its a DW. Since we have multiple files that are currently set as limited in their growth, would...

  • Reply To: File sizing

    Thank you John.

  • RE: New Reporting Services Installation

    Thank you for your reply. This is very helpful.

  • RE: ColumnStore Index

    Thank you everyone for the input. It is very helpful.

  • RE: ColumnStore Index

    Thank you for your response

    We are not sure yet whether to create it as clustered or not. This is something we will need to test with.

    The deletes will happen...

  • RE: Sub-Grouping by consecutive rows

    Hello,

    This worked great. Last Friday I was able to get this working on our system.

    Thank you very much for your help.

  • RE: Sub-Grouping by consecutive rows

    Thank you Jeff and thank you all very much, I will try this out tomorrow once I am back in the office.

  • RE: Sub-Grouping by consecutive rows

    Hello,

    Thank you very much for your help. I appreciate it. Will this have the CTE recursion limit? For now The data sets are small, but we may get larger files.

    Thanks...

  • RE: Sub-Grouping by consecutive rows

    Hello,

    Here is the set. There will be a begin and end date where we get the min(begin) and max(end) for each set. The cols will be ordered by the date...

  • RE: Sub-Grouping by consecutive rows

    Hello, Thank you for the reply. It did work. This is the way I get the data in the file from a source system and need to properly insert it....

  • RE: Sub-Grouping by consecutive rows

    I tried to paste the result to make it looks nice, but could not.

    Here is the code for the dataset in question. Thanks for your help.

    CREATE TABLE #testa

    (

    A INTEGER,

    B VARCHAR(2),

    ToSum...

  • RE: Sub-Grouping by consecutive rows

    Hello, Thanks for your reply.

    This will group all the rows where A = 1 and B = Al to one row.

    I only want to sum those up where they...

  • RE: CLR Yes or no?

    It is not yet in place. Currently we have a service that does calculations to populate a table. The developer is asking if we could have a clr to...

  • RE: Pivot, unpivot

    Hello,

    Thanks for your reply. Its just something I hope to get done with a query that I can reuse.

    Thanks

  • RE: Pivot, unpivot

    I have this meta data just for research purpose that I received from an external system. It will not be used for any processing only research and it would be...

Viewing 15 posts - 1 through 15 (of 50 total)