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.
This wizard uses a system stored procedure named “sp_makewebtask”.
I’ve been searching for the various logging or exception management components in DotNet. Until now, I’ve found three useful application blocks, or components. See following list. Microsoft Application Block -…