Forum Replies Created

Viewing 15 posts - 1,156 through 1,170 (of 8,731 total)

  • RE: SQL: HOW to concatenate two fields using trigger,

    m.awadallah92 - Monday, July 3, 2017 4:34 AM

    Any suggestion is appreciated.

    Thank you
    Best,
    Majdoleen

    I suggest that you post your data in a consumable format....

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 3, 2017 at 7:05 am

    #1949123

  • RE: Split DATE formatted 'YYYY-MM-DD' into Concatenated YEAR and MO field

    quinn.jay - Friday, June 30, 2017 10:41 AM

    Bill Talada - Friday, June 30, 2017 10:33 AM

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 30, 2017 at 11:06 am

    #1948988

  • RE: How can we load more than 6 million records into excel sheet

    I assume that you won't use the 6 million rows individually. How about setting a stored procedure as the source of a pivot table in Excel?
    There's no way that...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 30, 2017 at 10:32 am

    #1948974

  • RE: What's the best way to get a sample set of a big table without primary key?

    What about using something like this?

    SELECT TOP (1) PERCENT *
    FROM MyTable;

    Note that if you add an ORDER BY clause the performance will decrease.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 29, 2017 at 8:07 am

    #1948739

  • RE: Replace Bad Characters in Table

  • RE: Replace Bad Characters in Table

    I agree with franz, this will be slow. I´m not sure about the performance of the TRANSLATE function (MS has done terrible things with FORMAT), but here's a much faster...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 28, 2017 at 7:00 am

    #1948543

  • RE: @@rowcount and the OUTPUT clause

    Needed some coffee before answering. I thought it was asking for the result of
    SELECT * FROM #tempout
    :Wow:

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 28, 2017 at 6:13 am

    #1948535

  • RE: Are the posted questions getting worse?

    Sergiy - Monday, June 26, 2017 11:22 PM

    Jeff Moden - Monday, June 26, 2017 6:41 PM

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 27, 2017 at 6:33 am

    #1948343

  • RE: Tempdb

    Sergiy - Tuesday, June 27, 2017 5:15 AM

    AND - you can look into those queries and eliminate the factors causing a lot...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 27, 2017 at 6:16 am

    #1948337

  • RE: Using Cursors And Fetch

    vincentshanecurtis - Monday, June 26, 2017 12:40 PM

    Thanks for the insight.  My app is not a web app it's a desktop app....

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 26, 2017 at 1:13 pm

    #1948235

  • RE: Tempdb

    You can find lots of resources on the internet about tempdb best practices.
    Here's one: https://www.brentozar.com/archive/2016/01/cheat-sheet-how-to-configure-tempdb-for-microsoft-sql-server/

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 26, 2017 at 11:18 am

    #1948214

  • RE: Very bad performance issue joining 3 tables

    autoexcrement - Monday, June 26, 2017 9:49 AM

    Luis-
    I understand what a Cross Join is, and I understand what your solution is doing,...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 26, 2017 at 10:34 am

    #1948192

  • RE: Very bad performance issue joining 3 tables

    You might have some unintended cross joins. Try to pre-aggregate your values.

    SELECT _MDT.codiceMandato as Customer,
      SUM(FM.Revenue) AS Revenue,
      SUM(PG.Paid) AS Paid
    FROM (SELECT _PG.idMandato,...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 26, 2017 at 6:09 am

    #1948142

  • RE: Using Cursors And Fetch

    I'm sure that this can be done with Oracle, but that's not how SQL Server cursors work.
    Why would you want to learn the wrong way of doing things instead...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 26, 2017 at 6:01 am

    #1948139

  • RE: Creating Hierarchy with parent-child

    What if you create a view and just use the view as your source?

    CREATE VIEW dbo.vDIM_PRODUCT_GROUP
    AS
      SELECT ID,
       PARENT_ID,
       ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 26, 2017 at 5:55 am

    #1948137

Viewing 15 posts - 1,156 through 1,170 (of 8,731 total)