Question:
I'm using Postgres 9.5 and in the docs, it says
A not-null constraint is functionally equivalent to creating a check constraint CHECK (column_name IS NOT NULL), but in PostgreSQL creating an explicit not-null constraint is more efficient.
I'm wondering what exactly it means by "m...
I decided to start the traditional secret hats post, but instead of just another "here is how you get the secret hats" post, to also add in all the hats. There are two answers: one for the secret hats, and one for the regular hats.
Some notes about secret hats:
A secret hat for correctly gue...
Another year is rapidly coming to an end, which means it's time for some fun. Fun with hats! That's right, it's time for our annual event that brings joy to all and creates hat-fanatics everywhere... Winter Bash!
SQL Server date/time types are stored in a binary format, not as strings.
Values of these types are only translated to (or from) a particular string representation when something (e.g. a SELECT query) asks for it, implicitly or explicitly.
Client software (e.g. SSMS) may also retrieve the raw d...
It’s been an amazing year for Stack Exchange, both as a network of experts and enthusiasts and as an organization. We launched twenty new sites, rolled out tons of user-requested features, and are helping 99% more visitors get answers than we were a year ago.
My plan is for everyone to get the blue feet hat. Then force a mass update so everyone has to wear it at the same time. Blue feet will take over the world
I just lost 101 reputation points on SO.
Neither the reputation tab nor the page helped me to understand the reason. I also checked the 'deleted recent posts' checkbox at the bottom of the reputation tab.
What am I missing?
In case it is of any help, I downvoted an answer, which later got remo...
This Oracle database has a DBMS_JOB that runs the following materialized view refresh script :
dbms_refresh.refresh(ABCD.V_POSTAL_CODES);
If I run it by hand, it's finebut if the job executes it a snapshot too old occurs. It will also around 1/5 of the time simply succeed for no apparent reaso...
@A_V I don't see anything really wrong with the question but I'm no Oracle guy, but didn't the comment by a1ex07 "solve" your question?
given:
I will, there's a whole bunch of indexes there. 1131474.1 describes exactly what I'm getting, I'm quite thankful for pointing that out ! — A_VDec 8 at 15:38
You may have given the impression there that your issue is exactly what is documented in the oracle documentation
@A_V It seems answered in comments. Add everything needed to answer to the question body, flag old comments as obsolete, remove fluff like EDIT from the question.
@TypoCubeᵀᴹ Oh cool! I was just looking at that one and wondering what it was about. A search turned up a Sesame Street reference, which didn't help me much.
EDIT and UPDATE are rarely needed, nor helpful.
For future readers, posts need to be standalone, without any history. These sites are not forums, but intend to be libraries of canonical, high-quality, questions and answers. Future readers are not helped by seeing all kind of history.
When peop...
@TypoCubeᵀᴹ I only had time for a quick answer, but I added it anyway. I'll probably improve it with graphics and stuff as time allows.
BTW it came to my attention not because of the bounty, but because of the comment flags :)
Hi Robin, this is a good question but I've marked it as a duplicate because Craig's answer addresses the large third part of your question. The first two parts of the question aren't a duplicate and if you still want an answer we could edit your question down to just those? — Jack Douglas ♦41 secs ago
Not sure if this is the right call, but maybe the question should be split up anyway if it is reopened?
Apart from that I deleted some old comments, flagged a bunch, edited a couple of old questions but nothing I don't do otherwise except more often so I wouldn't know
My plan is for everyone to get the blue feet hat. Then force a mass update so everyone has to wear it at the same time. Blue feet will take over the world
Here's the run-down: I'm doing a select query. Every column in the WHERE and ORDER BY clauses are in a single non-clustered index IX_MachineryId_DateRecorded, either as part of the key, or as INCLUDE columns. I'm selecting all the columns, so that will result in a bookmark lookup, but I'm only ta...
Operating system is Ubuntu 14. Firefox is 50.1.0
This is what I have tried:
I restarted firefox after that. There was no effect.
What is the way to block those hot questions on the sidebar?
Question:
I'm using Postgres 9.5 and in the docs, it says
A not-null constraint is functionally equivalent to creating a check constraint CHECK (column_name IS NOT NULL), but in PostgreSQL creating an explicit not-null constraint is more efficient.
I'm wondering what exactly it means by "m...
I decided to start the traditional secret hats post, but instead of just another "here is how you get the secret hats" post, to also add in all the hats. There are two answers: one for the secret hats, and one for the regular hats.
Some notes about secret hats:
A secret hat for correctly gue...
Suppose the following table t1:
=================
| tag | val |
=================
| a1 | v1 |
| a1 | v2 |
| a1 | v3 |
| a1 | v4 |
| a1 | v5 |
| a2 | v6 |
| a2 | v7 |
| a2 | v8 |
| a2 | v9 |
| ... | ... |
=================
If you ex...
SQL Server date/time types are stored in a binary format, not as strings.
Values of these types are only translated to (or from) a particular string representation when something (e.g. a SELECT query) asks for it, implicitly or explicitly.
Client software (e.g. SSMS) may also retrieve the raw d...
I just lost 101 reputation points on SO.
Neither the reputation tab nor the page helped me to understand the reason. I also checked the 'deleted recent posts' checkbox at the bottom of the reputation tab.
What am I missing?
In case it is of any help, I downvoted an answer, which later got remo...
EDIT and UPDATE are rarely needed, nor helpful.
For future readers, posts need to be standalone, without any history. These sites are not forums, but intend to be libraries of canonical, high-quality, questions and answers. Future readers are not helped by seeing all kind of history.
When peop...
I'm a New Zealander who is flying from India to Auckland with a change over in Australia.
Do I need a visa?
Operating system is Ubuntu 14. Firefox is 50.1.0
This is what I have tried:
I restarted firefox after that. There was no effect.
What is the way to block those hot questions on the sidebar?
