Monthly Archives: June 2017

Avamar: Query postgresql db

bschelst/ June 13, 2017/ Avamar/ 0 comments

[email protected]:~/>: psql -p 5555 -U viewuser mcdb mcdb=>   Example query:     SELECT * FROM “public”.”v_clients”;     SELECT v_clients.cid, v_clients.client_name, v_clients.client_addr,v_clients.os_type FROM “public”.”v_clients”;        select client_name,status_code,domain FROM v_activities_2 WHERE (status_code=30901 or status_code=30915) and recorded_date_time > current_timestamp – interval ’24 hours’

SQL-Server: The query processor ran out of internal resources and could not produce a query plan

bschelst/ June 7, 2017/ SQL-Server/ 0 comments

from : http://jasonbrimhall.info/2014/01/02/day-9-queries-going-boom/ The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more

Read More