Forum Replies Created

Viewing 15 posts - 3,016 through 3,030 (of 8,761 total)

  • RE: backward compatibility

    Eirikur Eiriksson (10/24/2016)


    sqlserverDBA2016 (10/24/2016)


    I need to know whether I need to install backward compatibility for 2014 or not

    Can you please elaborate further on this, what makes you think you might...

  • RE: backward compatibility

    sqlserverDBA2016 (10/24/2016)


    I need to know whether I need to install backward compatibility for 2014 or not

    Can you please elaborate further on this, what makes you think you might need any...

  • RE: backward compatibility

    sqlserverDBA2016 (10/24/2016)


    do I have to install backward compatibility after installing SQL server 2014.

    I guess that it depends, without further information it is impossible to tell.

    And what is backward compatibility used...

  • RE: SharePoint SSRS ORA-00904: "LISTAGG_CLOB" invalid intentifier

    office 74070 (10/24/2016)


    Hy Guys,

    thank you for your replies.

    Yes of course, it was a permission trouble. We have two reporting plattforms and different user in the connection settings.

    My problem was...

  • RE: SQL Query

    Quick suggestion for the SQL part of your problem

    😎

    USE TEEST;

    GO

    SET NOCOUNT ON;

    DECLARE @SEEK_PRICE INT = 12

    ;WITH SAMPLE_DATA (ProdName,MinPrc,MaxPrc) AS

    (

    SELECT 'Apple' , 10, 15...

  • RE: Conflict in Functional Teams

    Jeff Moden (10/23/2016)


    Eirikur Eiriksson (10/23/2016)


    xsevensinzx (10/23/2016)


    David.Poole (10/22/2016)


    5. Not putting the team first.

    Actually, I slightly disagree with this. I feel conflict happens a lot because people are putting the team first...

  • RE: Conflict in Functional Teams

    xsevensinzx (10/23/2016)


    David.Poole (10/22/2016)


    5. Not putting the team first.

    Actually, I slightly disagree with this. I feel conflict happens a lot because people are putting the team first over the business. We...

  • RE: Stop query if it is taking too long

    Jeff Moden (10/23/2016)


    As a bit of a sidebar, I'm concerned for you good folks. One of the indexes you posted appears to have "CardNumber" as a clear text value....

  • RE: insert a new row(s) into sql table A from table B

    alex_martinez (10/23/2016)


    Thanks Eirikur Eiriksson I will give it a try. I appreciate your help.

    You are most welcome, and please ping back if you have any problems

    😎

  • RE: Big data: transfer x-number of rows per batch?

    Super_Grover (10/23/2016)


    Hi all,

    I must transfer a big table (231k rows not that big, but 735GB big because of blob) to another location by INSERT INTO SELECT FROM...

    It appears that first...

  • RE: Archiving Table Data

    Ed Wagner (10/23/2016)


    Eirikur Eiriksson (10/23/2016)


    Rechana Rajan (10/23/2016)


    We are creating a data archive plan for one oof our big table which have more than 8 million records in jusst 8 months...

  • RE: Stop query if it is taking too long

    mah_j (10/23/2016)


    I created the filtered covering index on InvoiceUID as you said,(run dbcc freeproccache and dbcc dropcleanbuffers) but it was not usable.Again it uses the IX_invoice index and the...

  • RE: Archiving Table Data

    Rechana Rajan (10/23/2016)


    Eirikur Eiriksson (10/23/2016)


    Rechana Rajan (10/23/2016)


    We are creating a data archive plan for one oof our big table which have more than 8 million records in jusst 8 months...

  • RE: Stop query if it is taking too long

    mah_j (10/23/2016)


    But the Invoiceuid is PK and has a clustered index in dbo.Invoice table.

    ALTER TABLE [dbo].[Invoice]

    ADD CONSTRAINT [PK_Invoice] PRIMARY KEY CLUSTERED([InvoiceUID] ASC)

    The problem is still that the query is...

  • RE: SharePoint SSRS ORA-00904: "LISTAGG_CLOB" invalid intentifier

    office 74070 (10/11/2016)


    Hey guys,

    i become following error during report rendering on a sharepoint intergrated ssrs mode:

    Fehler bei der Berichtsverarbeitung. (rsProcessingAborted)

    Fehler beim Ausführen der Abfrage für das DataSet1-Dataset. (rsErrorExecutingCommand)

    ORA-00904: "LISTAGG_CLOB": ungültiger...

Viewing 15 posts - 3,016 through 3,030 (of 8,761 total)