@ypercube Thanks, yes, I was reading those earlier but couldn't find any updates. It seems like getting parallel scan is the first step, then hopefully parallel hash & loop join, parallel sorts, etc
You probably need accurate statistics and reliable statistics updates to get even distribution between threads (er, processes) in a parallel query. Does that tend to be much of a problem in Postgres?
from table1, table2, table3, table4
where table3.table2_fid = table2.pid and table2.table1_fid = table1.pid and table3.status = 1
and table1.table4_fid = table4.pid
this doesn't work out nicely...
the from clause changed to:
from table1, table2 LEFT OUTER JOIN table5 ON table2.table5_fid = table5.pid, table3, table 4
@ypercube Yes, but they kind of have to. They are grouping by a column taken from the child table while aggregating results taking from the parent table.
@KrisGruttemeyer in fairness, each of those injuries are pivotal to those positions' performances ... except the hockey puck to the face. everyone knows that hockey players don't use their heads.
Daryn Cresswell (born 22 May 1971) is a former Australian rules footballer who played for the Sydney Swans in the Australian Football League, and the former senior coach of the Tasmanian Devils Football Club that played in the Victorian Football League.
== Playing career ==
Cresswell started his football with Glenorchy in the Tasmanian Football League. He also briefly played for Geelong Reserves in the Victorian Football League, Daryn then returned to Tasmania to play with North Hobart in the TFL the following year. Daryn was then drafted to the Sydney Swans in the mid-season draft.
Cress...
yeah. other exchanges are fine. recalculating the major indices is going to be a big problem since NYSE is used for composite calcs and like i said earlier, we're going to get hammered when trading resumes
@swasheck oh wow, I thought that was a tweet reacting to the problem today and expecting bad performance of stocks tomorrow. That was actually from yesterday - seems to call NYSE's "internal technical issue" stance into question.
"Solution" and "WITH(NOLOCK)" should not be married in the same sentence unless it's a negative correlation. — ypercube55 mins ago
^^^ Or, put another way, "Solution" and "WITH(NOLOCK)" should not be married in the same sentence, unless you mean to say they should not be married in the same sentence.
I have 4 databases mirrored using High Protection mode without witness server between two servers(principal and mirror) that are in the same domain. Manual failover worked fine for several days. But later somehow the IP of the principal server was changed in the DNS, then onwards the mirror state...
does it make any difference if you restart the witness endpoint? ALTER ENDPOINT <Endpoint Name> STATE=STOPPED; ALTER ENDPOINT <Endpoint Name> STATE=STARTED
@swasheck I should probably look at it more soon. It doesn't support filtered stats and takes a while to run on a SAP instance that has 40k tables and around 100k duplicate stats objects. : (