A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
SELECT * FROM TABLE1 A INNER JOIN ( SELECT Val1,Val2, Val3, Val4, Val5, SUM(Val6) FROM TABLE2 C INNER JOIN ServerlOtherTables D ON C.ID = D.ID WHERE Val6 IS NOT NULL AND Val7 = 3 GROUP BY Val1,Val2,Val3,Val4,Val5) B ON A.Val1 = B.Val1 AND A.Val2 = B.Val2 AND A.Val3 = B.Val3 AND A.Val4 = B.Val4 AND A.Val5 = B.Val5
|SharePoint 2013/ SQL 2014 - content database backup and restore from Prod to Dev||10||34|
|Where on a calculated field||1||20|
|qry in a qry worked by week ending date! how do I get it to work by weeks (y-t-d) instead of one week at a time?||25||54|
|use of sqlCmd command through exec master..xp_cmdshell||7||10|