Author: 최 재훈

BugFoundInAmazonDotCom.jpg I made an order 4 days ago, January 6, 2005. When I viewed the “Track Packages” page today, it said that things I had bought would be delivered someday…

Use the locks option to set the maximum number of available locks, thereby limiting the amount of memory Microsoft® SQL Server™ uses for locks. The default setting is 0, which…

Under certain circumstances, you may need to start an instance of Microsoft® SQL Server™ in single-user mode using the startup option -m. For example, you may want to change server…

Following commands allow you to modify system tables. sp_configure ‘allow updates’,1 go reconfigure with override go It is highy recommanded that you restart the MSSQL instance in a single user…

Sometimes I’ve visited “kangmi.org”. ( KangMi(강미) is a hard-learner of Korean language. ) A few moments ago, I saw a word “hangulization” in her blog. It can be translated to…

네이버 블로그에 새 저작권법을 소개하는 글이 올라왔다. 애당초 이렇게 되리라 생각했지만, 짜증난다. 저작권법이 마음에 안 든다는 것은 아니다. 다만 한국에서 디지털 음원을 사기가 쉽지 않거니와 음원의 가격이 지나치게 비싸다는 사실이…

I found the excessively useful document, describing how to use a SQL Profiler. This is a well-made thing. Click this. You can also download a pdf-converted file.  Download How_To__Use_SQL_Profiler.pdf

Displays or changes the automatic UPDATE STATISTICS setting for a specific index and statistics, or for all indexes and statistics for a given table or indexed view in the current…

Creating UNIQUE and PRIMARY KEY Constraints on Computed Columns Posted: July 02, 2001   This tip is one of a series from SQL Server Magazine. For additional tips, visit the…

Computed columns can only use constants, functions, and other columns in the same table. A computed column can't use a column of another table.