Forum Replies Created

Viewing 15 posts - 6,451 through 6,465 (of 13,874 total)

  • RE: Selecting from two groups

    dramaqueen (10/25/2016)


    Hi,

    I am having issues with the following script. I have 3 tables that link together.

    What I need to do is find owners that have items with statuses as...

  • RE: database features

    sqlserverDBA2016 (10/25/2016)


    And can u please tell me how to disable them

    Right-click the service you want to disable, select Properties and then, on the General tab, set Startup Type to 'Disabled'....

  • RE: database features

    sqlserverDBA2016 (10/25/2016)


    Thanks mate

    Just can I confirm, the ssas and ssrs and ssis can they be disabled from services after being installed

    Confirmed. Though I tend to use SQL Server Configuration...

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

    wtren (10/25/2016)


    You should use bcp

    Please justify this comment.

  • RE: database features

    sqlserverDBA2016 (10/24/2016)


    So u agree that it's better to install it when installing SQL server

    If it's a development machine, I wouldn't worry about it one way or the other, but for...

  • RE: Views from other database (Same server)

    40mil in one table

    That's manageable. But your original post mentioned 40 miliion million = 40 000 000 000 000 = 40 trillion.

  • RE: database features

    sqlserverDBA2016 (10/24/2016)


    Is adding the features later same as when installing SQL server

    And it's not more xomplicated

    I think that Jeff's point of view is that it's safer to reconfigure a (working)...

  • RE: Compare two columns before insert

    komal145 (10/24/2016)


    hi,

    I have a source column value "abcd" , i will be updating the destination column with the source column value only if there is a change.

    Example: destination is...

  • RE: Views from other database (Same server)

    .Patrick (10/24/2016)


    Hi all,

    Currently we are developing a new application for our company and I got a question related to the database architecture. We one database (DatabaseA) that is our main...

  • RE: query get 0 when month not exist in MSSQL

    A LEFT JOIN from a calendar table is probably what you need.

    Take a read of this link and see whether it helps you.

  • RE: database features

    BrainDonor (10/24/2016)


    sqlserverDBA2016 (10/24/2016)


    is it always better to add database features like analysis services and integration tools and reporting services

    when installing sql server instance, and it wont complicate and cause issues...

  • RE: Aggregate Different Values

    The implied rule seems to be the MIN of Col3

    Bravo. Gave me too much of a headache before my first coffee trying to work that out.

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

    Super_Grover (10/24/2016)


    Okay we're trying to solve this but I'll mark Phil's post as solution.

    Thanks again!

    If you find that you cannot run this as a distributed transaction, it should be possible...

  • RE: Aggregate Different Values

    ramos.ferdinand (10/24/2016)


    Hi Gurus,

    Just wanted to seek out for your help. This is a bit opposite of what aggregation should be. :hehe:

    I wanted to aggregate records with different values and...

  • RE: SENDING DAILY EMAIL ATTACHMENT WITH SQL QUERY TO GIVEN USERS.

    philand3 (10/23/2016)


    Dear All,

    i would like to send out following query to all email users daily basis,can anyone guide me the direction,

    it can be from SQL or external tool,ETC.

    SELECT ...

Viewing 15 posts - 6,451 through 6,465 (of 13,874 total)