To clear the cache on Oracle:
ALTER SYSTEM FLUSH BUFFER_CACHE;
ALTER SYSTEM FLUSH SHARED_POOL;
To clear the cache on SQL Server:
When you’re installing SQL Server (2008 R2 in my case) and you are prompted whether you want to create a default instance or a named instance, understand that creating a named instance means that you will be required to add that instance name to the server name when you connect via SQL Server Management Studio (SqlServerName\InstanceName). If you want to be able to connect to your instance without having to specify it explicitly, create a default instance. Then you just connect to SqlServerName and it finds the default instance.
In a post titled Life, Death, and Splitting Secrets, Jeff Moser presents a software solution for splitting up a password N ways so your loved ones can put the secrets together and get access to critical information from you after your death, using a computer program.
While this shared secret approach is interesting for certain uses, it is unwise for Moser’s stated use… Read the rest of this entry »
We have a table that can have tens or hundreds of millions of rows in it, and in this table there is a certain column. This column usually—typically—generally—has non-null hash values in it.
In unusual cases though, that column can be NULL. And the thing is, there are times when the interesting rows, the rows we want to gather together and do something with, are exactly the rows where that column is null.
Table scans to find the rows where the column is NULL are expensive, so naturally we want to index this column. But since non-null values in this column are a hash and we only ever care about the NULL values, we’d like to avoid the time and space overhead of indexing the non-null values. We’d like a partial index of only the rows where the column is NULL… Read the rest of this entry »
I’m running on Fedora 20, and the graphical boot (Plymouth-something-something) sometimes waits a long time and then times out, which when it happens makes the computer take several minutes to boot. This doesn’t happen if I boot to “runlevel 3″ (now called multi-user.target) and then run startx from there.
You can change the default target to “runlevel 3″ like this:
systemctl set-default multi-user.target
Our scanner at home is an old flatbed that scans to a .jpg file. When you have several pages that you need to scan and send to someone, a pile of JPGs isn’t very nice—you’d rather have one PDF.
If you’re running Linux (at home I’m currently running Fedora 20 – “Heisenbug”), this is easy peasy: with ImageMagick installed, just use the
convert 1.jpg 2.jpg 3.jpg 1-2-3.pdf
FT # A label (for jumping to) NEW X,MSG2 I $$RDVALS^MISC22()=SUCCESS DO QUIT # The second space between DO and QUIT is significant . S X="DO ACTN5^ACTNS" . X X # The two Xs mean different things (Cache' is not a context-free language) . S MSG2=MSG_" succeeded." # Expect MSG to float in from somewhere else E DO . S ERRMSG=INVALIDREADMSG . W 1/0