EugeneChiang.com

SQL Server Named Pipes

After SQL Server install, need to enable Named Pipes in order to be accessible from SQL Server Management Studio. Go to SQL Server Configuration Manager to enable Named Pipes and TCP/IP. Also need to restart services.

SVN – Checkout Process

Check out a working copy from a repository. Select folder and checkout. Map repository folder to a local folder on your computer. All files folders will be copied over to your local folder. The folder will be marked with a green checkout icon. You can now edit files and commit changes back to repository.

XCOPY

The xcopy command is a Command Prompt command used to copy one or more files and/or folders from one location to another location. The xcopy command, with its many options and ability to copy entire directories, is similar to, but much more powerful than, the traditional copy command. The robocopy command is also similar to the xcopy command but has even more... » read more

Working with Spaces in Directory in Command Line

In Command Line, use quotes to deal with spaces in directory.

NOLOCK

The default behavior in SQL Server is for every query to acquire its own shared lock prior to reading data from a given table. This behavior ensures that you are only reading committed data. However, the NOLOCK table hint allows you to instruct the query optimizer to read a given table without obtaining an exclusive... » read more

SQL Data Type Check

Disable Job From Script

Check column does not exist before adding column

Check record does not exist before insert.

Create SQL Login Account Script

sp_change_users_login Maps an existing database user to a SQL Server login.  Syntax Arguments [ @Action= ] ‘action‘Describes the action to be performed by the procedure. action is varchar(10). action can have one of the following values. Value Description Auto_Fix Links a user entry in the sys.database_principals system catalog view in the current database to a SQL Server login of the... » read more