IGNORE_DUP_KEY

IGNORE_DUP_KEY = { ON | OFF }Specifies the response type when an insert operation attempts to insert duplicate key values into a unique index. The IGNORE_DUP_KEY option applies only to insert operations after the index is created or rebuilt. The option has no effect when executing CREATE INDEX, ALTER INDEX, or UPDATE. The default is OFF. ONA warning message occurs when duplicate... » read more

STATISTICS_NORECOMPUTE

STATISTICS_NORECOMPUTE = { ON | OFF }Specifies whether statistics are recomputed. The default is OFF. ONOut-of-date statistics are not automatically recomputed. OFFAutomatic statistics updating are enabled. The general recommendation to leave auto-update stats turned on (STATISTICS_NORECOMPUTE = OFF, which is the default) is for safety reasons, because if this is turned off and nothing is manually updating the stats,... » read more

PAD_INDEX

From MSDN: PAD_INDEX = { ON | OFF } Specifies index padding. The default is OFF. ON: The percentage of free space that is specified by fillfactor is applied to the intermediate-level pages of the index. OFF or fillfactor is not specified: The intermediate-level pages are filled to near capacity, leaving sufficient space for at least... » read more

Add Additional Partition to an Existing Partition Table

-- Add additional file group. ALTER DATABASE Test02 ADD FILEGROUP [fg202001_tbTable] GO -- Assoicate file to file group. ALTER DATABASE Test02 ADD FILE (NAME = N'fg202001_tbTable', FILENAME = N'D:\MSSQL\DATA\Test02\fg202001_tbTable.ndf' , SIZE = 1000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP [fg202001_tbTable] GO -- Add additional file group to partition scheme. ALTER PARTITION SCHEME... » read more

Creating Partitions on a Table

Object Creation File Group Partition Function Partition Schema Partition Table Create File Group and Associate File to File Group ALTER DATABASE Test02 ADD FILEGROUP [fg201701_tbImageFpMatchARCH] GO ALTER DATABASE Test02 ADD FILE (NAME = N'fg201701_tbTable', FILENAME = N'D:\MSSQL\DATA\Test02\fg201701_tbTable.ndf' , SIZE = 1000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP [fg201701_tbTable] GO ALTER DATABASE Test02... » read more

Partitioning by Datetime vs Date vs Int Performance

Use the Date datatype. Int (formatted in YYYYMMDD) used to be the recommended format for partitioning, as it was cheaper (@ 4 bytes/row) than datetime (@ 8 bytes/row). Date is 3 bytes/row and is in a natural date format. Also, INT is a pain in the butt to query on as you have to add... » read more

VirtualBox

https://www.virtualbox.org/wiki VirtualBox is a powerful x86 and AMD64/Intel64 virtualization product for enterprise as well as home use. Not only is VirtualBox an extremely feature rich, high performance product for enterprise customers, it is also the only professional solution that is freely available as Open Source Software under the terms of the GNU General Public License (GPL)... » read more

KeePass Password Safe

What is KeePass?Today you need to remember many passwords. You need a password for the Windows network logon, your e-mail account, your website’s FTP password, online passwords (like website member account), etc. etc. etc. The list is endless. Also, you should use different passwords for each account. Because if you use only one password everywhere... » read more

Notepad++

Notepad++ is a free (as in “free speech” and also as in “free beer”) source code editor and Notepad replacement that supports several languages. Running in the MS Windows environment, its use is governed by GPL License. Based on the powerful editing component Scintilla, Notepad++ is written in C++ and uses pure Win32 API and STL which ensures a higher... » read more

TortoiseSVN

TortoiseSVN is an Apache™ Subversion (SVN)® client, implemented as a Windows shell extension. It’s intuitive and easy to use, since it doesn’t require the Subversion command line client to run. And it is free to use, even in a commercial environment. Simply the coolest Interface to (Sub)Version Control! https://tortoisesvn.net/downloads.html https://www.visualsvn.com/server/