Forum Topic

The SQL Thread

  • may alam ba kayong training center for postgre sql?
  • Post deleted #11693683
  • try mo dito sir kung meron sila

    may alam ba kayong training center for postgre sql?


    http://www.wizardsgroup.com/

    <click here for link>
  • maganda jan sa dbwizards. nagtraining na ako dati jan.
  • mga bossing paano po ma restore sa diffent machine yung sql back up ko or even yung mdf nasira kasi yung drive ng machine ko buti nalang separate drive yung sql back up and mdf ko tia
  • Restore mo lang ung backup database dun sa bagong machine na may SQL. Kung may MDF ka iattach mo na lang siya sa bago mong instance then ok na yan. Make sure to double check your users and permissions after the restore kung nakakaccess pa ung mga nakakaccess dati.
  • Post deleted #11899039
  • please help me check my post about sql...please
  • hi active pa po yung thread na to ? may itatanong sana kasi ako regarding sa database
  • @jetr0019
    ano ba ang iyong tanong?
  • Hi mga idol SQL developer. I am currently looking for a freelancer who can guide me on some basics of SQL Client/Server database, willing to pay. Who has vacant time and interested please contact me so we can discuss the scope, rate...etc.

    I live in Project 7, QC.

    Pls. Call or Text me @09171309283 (James)
  • Post deleted #12082196
  • Good pm. Question lang regarding sql query specifically on join/grouping

    Ex. Data:

    Company - Status
    A - approve
    A - review
    B - approve
    C - review

    Preferred output:

    Company - approve - review
    A - 1 - 1
    B - 1 - 0
    C - 0 - 1
  • @se17enteen

    try mo to:

    INSERT INTO TESTTABLE2(COMPANY,APPROVE,REVIEW)
    SELECT COMPANY,1 AS APPROVE, 0 AS REVIEW
    FROM TESTTABLE
    WHERE STAT='APPROVE'
    UNION ALL
    SELECT COMPANY, 0 AS APPROVE,1 AS REVIEW
    FROM TESTTABLE
    WHERE STAT='REVIEW';

    --This will do the trick
    SELECT COMPANY, MAX(APPROVE) AS APPROVE, MAX(REVIEW) AS REVIEW FROM TESTTABLE2
    GROUP BY COMPANY;

    hintay tayo baka may mas maayos na query sila master. :)

    -- edited by caecus18 on Mar 09 2018, 12:47 PM
  • Good pm. Question lang regarding sql query specifically on join/grouping

    Ex. Data:

    Company - Status
    A - approve
    A - review
    B - approve
    C - review

    Preferred output:

    Company - approve - review
    A - 1 - 1
    B - 1 - 0
    C - 0 - 1


    if you are using MS SQL you can use the PIVOT keyword to turn rows to columns

    <click here for link>
  • UP!

    May active pa ba sa thread na to?
  • yes sir!
  • yes sir!


    Sir need advise sa SQL 2016. Malaki na yung DB size 100+ GB na cya. Daily run ko ng FULL DB backup any other methods ng backups.

    Bukod sa DBCC and index rebuild.Anu pa pwede pang optimized? para ma maintain yung SQL.
  • Sir need advise sa SQL 2016. Malaki na yung DB size 100+ GB na cya. Daily run ko ng FULL DB backup any other methods ng backups.

    Bukod sa DBCC and index rebuild.Anu pa pwede pang optimized? para ma maintain yung SQL.


    Weekly kang mag database maintenance (index rebuild, update statistics, etc.). Then monthly pwede kang magrun ng script for missing indexes para mas optimized mga queries ng SQL database mo. Nakasimple ba ung Recovery model ng database mo?

  • Weekly kang mag database maintenance (index rebuild, update statistics, etc.). Then monthly pwede kang magrun ng script for missing indexes para mas optimized mga queries ng SQL database mo. Nakasimple ba ung Recovery model ng database mo?


    Na set ko na sir index rebuild weekly cya. Running na. Eto pa ibang options sir:
    Check Database Integrity
    Update Statistics
    Clean up history
    Maintenance Clean up task

    Advisable or best practice po ba i run to monthly basis or weekly?
    Simple recovery lang po db namin
  • Na set ko na sir index rebuild weekly cya. Running na. Eto pa ibang options sir:
    Check Database Integrity
    Update Statistics
    Clean up history
    Maintenance Clean up task

    Advisable or best practice po ba i run to monthly basis or weekly?
    Simple recovery lang po db namin


    Weekly - Index Rebuild/Reorganize, Update Stats (Online lahat ito).
    Monthly - DB integrity check, Missing indexes,

    The rest monthly na ung iba.
  • mga master pag hindi nag ta take effect ang shrink database command ,ano pa ibang workaround para ma reduce existing sql database? naka 10gb na kasi sya advisable is 6gb max lang sana.

    thanks TPC!!