You can’t use ROW_NUMBER() in an update statement in SQL Server, so:
UPDATE TheTable SET TheColumn = ROW_NUMBER();
won’t work. But sometimes that’s just what you want. This will do the trick:
UPDATE Target
SET TheColumn = RowNum
FROM
(
SELECT t.TheColumn, ROW_NUMBER() OVER(ORDER BY t.ID) AS RowNum
FROM TheTable t
WHERE ...
) AS Target;
I extended my PC with two old monitors I got from my sister/brother-in-law. An HP1955 and an HP2035, with resolutions up to 1280×1024 and 1600×1200 respectively. Since my main screen is FullHD (1920 x 1080), Eyefinity on the RadeOn 7970 will set the height of all to 1024 when you put them in a group. Giving me a total resolution of 3840×1024. Not the best the card can do, but the best in this setup.
To save me the trouble of constantly setting up the group and gaming, and then switching back to a normal extended desktop (with max resolutions on each monitor), I created two presets in the Catalyst Control center. Easy. Just do your setup, go to Presets (second item in the accordion) and click on Add Preset. Name the preset so you can recognize it. Do another setup and add it too. Now you can switch between the presets by right-clicking on the system tray icon of the Catalyst Control Center and selecting “Invoke preset”. Choose the appropriate preset, and you’re done.
In my last post I said Grid did not support FullHD mode, but with a little tweaking it does. Grid is an older game, and it probably can’t read all the hardware info from the newer graphics cards. Mine has 3GB of RAM, but the restrictions in Grid won’t allow you to go beyond a width of 1280 when your system has less then 270MB. So Grid must not understand 3000MB.
Here’s how to change the config files. Make a backup of each file first, in case you screw things up.
1) c:\steam\steamapps\common\Grid\system\hardware_settings_restrictions.xml
Find the line containing:
<res mem="270" maxWidth="1280" />
and change the value of maxWidth to 1920.
2) {userdocuments}\Codemasters\GRID\hardware_settings_info.xml
Add the 1920×1080 resolution by adding the following lines:
<resolution width="1920" height="1080" aspect="normal">
<refreshRate rate="50" />
<refreshRate rate="60" />
</resolution>
3) {userdocuments}\Codemasters\GRID\hardware_settings_config.xml
In the graphics_card section, change the resolution settings to something like this:
<resolution width="1920" height="1080" aspect="16:9" fullscreen="true"
vsync="1" oldWidth="1920" oldHeight="1080">
<refreshRate rate="60" />
</resolution>
Start GRID. It should work. It will ask you if you want to keep the new resolution of 1920×1080 and after that you’re good to go. Have fun.
With Grid2 around the corner (May, 28th) I decided to buy Grid (the first one). It’s cheap on GreenmanGaming.com at the moment, so I bought it and installed it by entering the key on Steam.
The controller defaults on Grid are of course the (cursor-)keys, so to use the Fanatec wheel, I had to make a custom setup. Not very difficult, but strange to see a game that is all about realism does not have a default “wheel” setup.
The game is difficult. I did my fair share of Forza3, Forza4, Shift, Shift2 and Forza Horizon, but this game is unforgiving. Like it is in real life of course. Bump into a wall, and basically your race is over, since your front wheels are damaged or maybe worse: you totalled your car. I cranked down the difficulty a bit, but even then the game is very hard.
Probably because it’s an older game, it does not support FullHD resolution. The closest is 1280×800 or 1280×900. Still the game looks great when you modify the graphics details to HIGH.
For the price on Greenman, don’t think twice and buy this game if you’re into racing games. But don’t say I didn’t warn you…
Annoyed by Firefox’s pop-up saying “Download Complete”? Well, I was. It’s not a small window just in Firefox, but it’s an OS (in my case Linux) window, so it blocks everything underneath. Just for 4 seconds (the standard alert time in Firefox), but annoying nonetheless.
So, type ABOUT:CONFIG in the address-bar, and type alert in the search-box. You will see several keys that you can change, but the one that you want is:
browser.download.manager.showAlertOnComplete
Set it to false (by double-clicking) and you’re done.
When installing the Android development toolkit on Windows, you might find yourself stuck on the second screen on the wizard, because the installer can’t find the JDK you installed. The following is not a joke. Press BACK to go to the title screen, press NEXT to return to the second screen, and….voila. The installer found the JDK. Remember, this is NOT a joke.
I’m on FaceBook a lot, since I play online games. I know, it’s a stupid waste of time, but I like it. When you play a lot, BetterFaceBook is an add-on you can’t miss. But for some reason, I could not install the latest version in Chrome. I had 4.5 installed, but 5 would not install because of an “invalid crx header” error. Even when downloading the file and opening it in Chrome, it would give the same error.
So I unpacked the CRX (it’s basically just a ZIP-file) and installed it via “Load unpacked extension”. That worked. Not sure why Chrome did not like the crx, but I thought this might be of some help to you.
To reset the sys password of a database, do the following:
1) rename/delete ${ORACLE_HOME}/database/PWD{ORACLE_SID}.ora
2) enter the command: orapwd file=${ORACLE_HOME}/database/PWD{ORACLE_SID}.ora password=newpassword
3) start “sqlplus /nolog”
4) login with sys and the newpassword (SQL> connect sys/newpassword as sysdba)
5) now reset other passwords or just be done