-
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…
-
Archiving old mail and mail attachment in SQL Server 2005
In this blog post, I gave out script to set up database mail for Sql Server 2005, if you already have smtp server up and running. One thing you need to pay attention to is that Sql Server 2005 logs all those mail messages into msdb database, including mail attachments, if any. You probably can…
-
PC Help Needed
I am taking my time to fix our home PC, but I think I am stuck. So I wonder if my readers could help me out here. This machine is around 6 years old. It is a HP Pavilion 513x: It died around a month ago. On startup, it would go into the “cannot boot”…
-
Hot fix for SP4 is cluster-aware
Service Pack 4 for Sql Server 2000 introduced a bug. After it is installed, if Address Windowing Extentions (AWE) support is enabled, a single instance of SQL Server 2000 can only use a maximum of 50 percent of the physical memory that is on the server. Microsoft has a hot fix for that problem here.…