-
adrian7
on
23 Feb 16 @ 02:47 PM #
may alam ba kayong training center for postgre sql?
- Post deleted #11693683
-
mykel07
on
22 Jul 16 @ 08:59 AM #
try mo dito sir kung meron sila
may alam ba kayong training center for postgre sql?
http://www.wizardsgroup.com/
<click here for link>
-
zhyke08
on
27 Jul 16 @ 01:11 PM #
maganda jan sa dbwizards. nagtraining na ako dati jan.
-
Morphius
on
18 Jan 17 @ 10:20 AM #
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
-
jayromega
on
29 Jan 17 @ 09:38 PM #
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
-
lucky_r
on
25 Mar 17 @ 09:11 AM #
please help me check my post about sql...please
-
jetr0019
on
16 May 17 @ 05:14 PM #
hi active pa po yung thread na to ? may itatanong sana kasi ako regarding sa database
-
fatal1ty18
on
23 May 17 @ 10:26 AM #
@jetr0019
ano ba ang iyong tanong?
-
SoulessZero
on
25 Jan 18 @ 06:37 PM #
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
-
se17enteen
on
08 Mar 18 @ 03:14 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
-
caecus18
on
09 Mar 18 @ 06:50 AM #
@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
-
Tech_Neck
on
09 Mar 18 @ 06:55 AM #
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>
-
whiteli0n
on
11 May 20 @ 06:10 PM #
UP!
May active pa ba sa thread na to?
-
jayromega
on
11 May 20 @ 07:41 PM #
yes sir!
-
whiteli0n
on
11 May 20 @ 07:56 PM #
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.
-
jayromega
on
11 May 20 @ 10:41 PM #
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?
-
whiteli0n
on
12 May 20 @ 06:29 PM #
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
-
jayromega
on
13 May 20 @ 01:32 AM #
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.
-
crazypinoy_61
on
07 Jun 21 @ 01:35 PM #
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!!