-
Sledding 20070210
Last Sunday was pretty cold in Chicago, around -20 Celsius. It’s a good day for sledding. All prepared: Sliding forward: Drinking hot chocolate afterwards (O’boy chocolate from Sweden): I think I will pull the sled to school again tomorrow.
-
Enable File and Printer Sharing for Microsoft Networks for cluster install
I talked about one issue when setting up Sql cluster here. Recently I came across another problem while setting up a Sql Server 2000 cluster on a 2-node Windows 2003 cluster. The error occurred at the step where you were asked to provide a login that can get into the remote node(s), server(s) where install…
-
Assign SELECT results into variables
I mentioned here that SELECT INTO in Sql Server is functionally similar to CREATE TABLE AS in Oracle. Oracle also has SELECT INTO, but it is used for assigning query results to a variable. Here is a PL/SQL code snippet: declare MyVariable varchar2(20); Begin select ColumnName into MyVariable from MyTable where MyID = SomeInteger; dbms_output.put_line(‘Hello…
-
Best way to represent date value in Sql Server
I am going through Kalen Delaney and Itzik Ben-Gan’s Inside Sql Server 2005 books. I am surprised and happy to learn that you can always represents date/time value in the format of [YY]YYMMDD[ HH:MI[:SS][.MMM]] in Sql Server, with things inside the square bracket being optional. In fact, that is a recommended practice because you will…
-
Computer fixed
Reader Bulent’s comment gave me some ideas. I unplugged the existing power cable from the hard disk, and plugged in another available power cable, to see if that would make any difference. It didn’t. Frustrated, I left the computer on and busied myself with other matters, probably doing dishes. When I came back, lo and…