\documentclass[10pt,a4paper]{article}

% Packages
\usepackage{fancyhdr}           % For header and footer
\usepackage{multicol}           % Allows multicols in tables
\usepackage{tabularx}           % Intelligent column widths
\usepackage{tabulary}           % Used in header and footer
\usepackage{hhline}             % Border under tables
\usepackage{graphicx}           % For images
\usepackage{xcolor}             % For hex colours
%\usepackage[utf8x]{inputenc}    % For unicode character support
\usepackage[T1]{fontenc}        % Without this we get weird character replacements
\usepackage{colortbl}           % For coloured tables
\usepackage{setspace}           % For line height
\usepackage{lastpage}           % Needed for total page number
\usepackage{seqsplit}           % Splits long words.
%\usepackage{opensans}          % Can't make this work so far. Shame. Would be lovely.
\usepackage[normalem]{ulem}     % For underlining links
% Most of the following are not required for the majority
% of cheat sheets but are needed for some symbol support.
\usepackage{amsmath}            % Symbols
\usepackage{MnSymbol}           % Symbols
\usepackage{wasysym}            % Symbols
%\usepackage[english,german,french,spanish,italian]{babel}              % Languages

% Document Info
\author{danar124}
\pdfinfo{
  /Title (sql-server-rahadiyan-danar-a-5212100124.pdf)
  /Creator (Cheatography)
  /Author (danar124)
  /Subject (SQL Server / Rahadiyan Danar A - 5212100124 Cheat Sheet)
}

% Lengths and widths
\addtolength{\textwidth}{6cm}
\addtolength{\textheight}{-1cm}
\addtolength{\hoffset}{-3cm}
\addtolength{\voffset}{-2cm}
\setlength{\tabcolsep}{0.2cm} % Space between columns
\setlength{\headsep}{-12pt} % Reduce space between header and content
\setlength{\headheight}{85pt} % If less, LaTeX automatically increases it
\renewcommand{\footrulewidth}{0pt} % Remove footer line
\renewcommand{\headrulewidth}{0pt} % Remove header line
\renewcommand{\seqinsert}{\ifmmode\allowbreak\else\-\fi} % Hyphens in seqsplit
% This two commands together give roughly
% the right line height in the tables
\renewcommand{\arraystretch}{1.3}
\onehalfspacing

% Commands
\newcommand{\SetRowColor}[1]{\noalign{\gdef\RowColorName{#1}}\rowcolor{\RowColorName}} % Shortcut for row colour
\newcommand{\mymulticolumn}[3]{\multicolumn{#1}{>{\columncolor{\RowColorName}}#2}{#3}} % For coloured multi-cols
\newcolumntype{x}[1]{>{\raggedright}p{#1}} % New column types for ragged-right paragraph columns
\newcommand{\tn}{\tabularnewline} % Required as custom column type in use

% Font and Colours
\definecolor{HeadBackground}{HTML}{333333}
\definecolor{FootBackground}{HTML}{666666}
\definecolor{TextColor}{HTML}{333333}
\definecolor{DarkBackground}{HTML}{41A396}
\definecolor{LightBackground}{HTML}{F3F9F8}
\renewcommand{\familydefault}{\sfdefault}
\color{TextColor}

% Header and Footer
\pagestyle{fancy}
\fancyhead{} % Set header to blank
\fancyfoot{} % Set footer to blank
\fancyhead[L]{
\noindent
\begin{multicols}{3}
\begin{tabulary}{5.8cm}{C}
    \SetRowColor{DarkBackground}
    \vspace{-7pt}
    {\parbox{\dimexpr\textwidth-2\fboxsep\relax}{\noindent
        \hspace*{-6pt}\includegraphics[width=5.8cm]{/web/www.cheatography.com/public/images/cheatography_logo.pdf}}
    }
\end{tabulary}
\columnbreak
\begin{tabulary}{11cm}{L}
    \vspace{-2pt}\large{\bf{\textcolor{DarkBackground}{\textrm{SQL Server / Rahadiyan Danar A - 5212100124 Cheat Sheet}}}} \\
    \normalsize{by \textcolor{DarkBackground}{danar124} via \textcolor{DarkBackground}{\uline{cheatography.com/20652/cs/3385/}}}
\end{tabulary}
\end{multicols}}

\fancyfoot[L]{ \footnotesize
\noindent
\begin{multicols}{3}
\begin{tabulary}{5.8cm}{LL}
  \SetRowColor{FootBackground}
  \mymulticolumn{2}{p{5.377cm}}{\bf\textcolor{white}{Cheatographer}}  \\
  \vspace{-2pt}danar124 \\
  \uline{cheatography.com/danar124} \\
  \end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
  \SetRowColor{FootBackground}
  \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Cheat Sheet}}  \\
   \vspace{-2pt}Published 24th February, 2015.\\
   Updated 11th May, 2016.\\
   Page {\thepage} of \pageref{LastPage}.
\end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
  \SetRowColor{FootBackground}
  \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Sponsor}}  \\
  \SetRowColor{white}
  \vspace{-5pt}
  %\includegraphics[width=48px,height=48px]{dave.jpeg}
  Measure your website readability!\\
  www.readability-score.com
\end{tabulary}
\end{multicols}}




\begin{document}
\raggedright
\raggedcolumns

% Set font size to small. Switch to any value
% from this page to resize cheat sheet text:
% www.emerson.emory.edu/services/latex/latex_169.html
\footnotesize % Small font.

\begin{multicols*}{2}

\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Server-level Options}}  \tn
\SetRowColor{white}
\mymulticolumn{1}{x{8.4cm}}{{\bf{{\emph{opt/min/max/def}}}}% Row Count 1 (+ 1)
} \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Configuration}}  \tn
\SetRowColor{white}
\mymulticolumn{1}{x{8.4cm}}{-{\bf{access check cache bucket count}} /0/16384/0 \newline % Row Count 1 (+ 1)
-{\bf{access check cache quota}} /0/2147483647/0 \newline % Row Count 3 (+ 2)
-{\bf{ad hoc distributed queries}} /0/1/0 \newline % Row Count 4 (+ 1)
-{\bf{affinity I/O mask}} /-2147483648/214748647/0 \newline % Row Count 6 (+ 2)
-{\bf{affinity64 I/O mask}} /-2147483648/214748647/0 \newline % Row Count 8 (+ 2)
-{\bf{Agent XPs}} /0/1/0 \newline % Row Count 9 (+ 1)
-{\bf{allow updates}} /0/1/0 \newline % Row Count 10 (+ 1)
-{\bf{backup compression default}} /0/1/0 \newline % Row Count 11 (+ 1)
-{\bf{blocked process threshold}} /0/86400/0 \newline % Row Count 12 (+ 1)
-{\bf{audit mode}} /0/1/0 \newline % Row Count 13 (+ 1)
-{\bf{clr enabled}} /0/1/0 \newline % Row Count 14 (+ 1)
-{\bf{common criteria compliance enabled}} /0/1/0 \newline % Row Count 15 (+ 1)
-{\bf{contained database authentication}} 0/-/0 \newline % Row Count 17 (+ 2)
-{\bf{cost threshold for parallelism}} /0/32767/5 \newline % Row Count 19 (+ 2)
-{\bf{cross db ownership chaining}} /0/1/0 \newline % Row Count 20 (+ 1)
-{\bf{cursor threshold}} /-1/2147483647/-1 \newline % Row Count 22 (+ 2)
-{\bf{Database Mail XPs}} /0/1/0 \newline % Row Count 23 (+ 1)
-{\bf{default full-text language}} /0/2147483647/1033 \newline % Row Count 25 (+ 2)
-{\bf{default language}} /0/9999/0 \newline % Row Count 26 (+ 1)
-{\bf{default trace enabled}} /0/1/1 \newline % Row Count 27 (+ 1)
-{\bf{disallow results from triggers}} /0/1/0 \newline % Row Count 28 (+ 1)
-{\bf{EKM provider enabled}} /0/1/0 \newline % Row Count 29 (+ 1)
-{\bf{filestream\_access\_level}} /0/2/0 \newline % Row Count 31 (+ 2)
} \tn 
\end{tabularx}
\par\addvspace{1.3em}

\vfill
\columnbreak
\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Configuration (cont)}}  \tn
\SetRowColor{white}
\mymulticolumn{1}{x{8.4cm}}{-{\bf{fill factor}} /0/100/0 \newline % Row Count 1 (+ 1)
-{\bf{ft crawl bandwidth (max)}} /0/32767/100 \newline % Row Count 2 (+ 1)
-{\bf{ft crawl bandwidth (min)}} /0/32767/0 \newline % Row Count 3 (+ 1)
-{\bf{ft notify bandwidth (max)}} /0/32767/100 \newline % Row Count 4 (+ 1)
-{\bf{ft notify bandwidth (min)}} /0/32767/0 \newline % Row Count 5 (+ 1)
-{\bf{index create memory}} /704/2147483647/0 \newline % Row Count 7 (+ 2)
-{\bf{in-doubt xact resolution}} /0/2/0 \newline % Row Count 8 (+ 1)
-{\bf{lightweight pooling}} /0/1/0 \newline % Row Count 9 (+ 1)
-{\bf{locks}} /5000/214783647/0 \newline % Row Count 10 (+ 1)
-{\bf{max degree of parallelism}} /0/32767/0 \newline % Row Count 12 (+ 2)
-{\bf{max full-text crawl range}} /0/256/4 \newline % Row Count 13 (+ 1)
-{\bf{max server memory}} /16/2147483647 \newline % Row Count 14 (+ 1)
-{\bf{max text repl size}} /0/2147483647/65536 \newline % Row Count 16 (+ 2)
-{\bf{max worker threads}} /128/32767/0 \newline % Row Count 17 (+ 1)
-{\bf{media retention}} /0/365/0 \newline % Row Count 18 (+ 1)
-{\bf{min memory per query}} /512/2147483647/1024 \newline % Row Count 20 (+ 2)
-{\bf{min server memory}} /0/2147483647/0 \newline % Row Count 21 (+ 1)
-{\bf{nested triggers}} /0/1/1 \newline % Row Count 22 (+ 1)
-{\bf{network packet size}} /512/32767/4096 \newline % Row Count 23 (+ 1)
-{\bf{Ole Automation Procedures}} /0/1/0 \newline % Row Count 24 (+ 1)
-{\bf{open objects}} /0/2147483647/0 \newline % Row Count 25 (+ 1)
-{\bf{optimize for ad hoc workloads}} /0/1/0 \newline % Row Count 26 (+ 1)
-{\bf{PH\_timeout}} /0/3600/60 \newline % Row Count 27 (+ 1)
-{\bf{precompute rank}} /0/1/0 \newline % Row Count 28 (+ 1)
-{\bf{priority boost}} /0/1/0 \newline % Row Count 29 (+ 1)
-{\bf{query governor cost limit}} /0/2147483647/0 \newline % Row Count 31 (+ 2)
} \tn 
\end{tabularx}
\par\addvspace{1.3em}

\vfill
\columnbreak
\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Configuration (cont)}}  \tn
\SetRowColor{white}
\mymulticolumn{1}{x{8.4cm}}{-{\bf{query wait}} /-1/2147483647/-1 \newline % Row Count 1 (+ 1)
-{\bf{recovery interval}} /0/32767/0 \newline % Row Count 2 (+ 1)
-{\bf{remote access}} /0/1/1 \newline % Row Count 3 (+ 1)
-{\bf{remote admin connections}} /0/1/0 \newline % Row Count 4 (+ 1)
-{\bf{remote login timeout}} /0/2147483647/10 \newline % Row Count 6 (+ 2)
-{\bf{remote proc trans}} /0/1/0 \newline % Row Count 7 (+ 1)
-{\bf{remote query timeout}} /0/2147483647/600 \newline % Row Count 9 (+ 2)
-{\bf{Replication XPs Option}} /0/1/0 \newline % Row Count 10 (+ 1)
-{\bf{scan for startup procs}} /0/1/0 \newline % Row Count 11 (+ 1)
-{\bf{server trigger recursion}} /0/1/1 \newline % Row Count 12 (+ 1)
-{\bf{set working set size}} /0/1/0 \newline % Row Count 13 (+ 1)
-{\bf{show advanced options}} /0/1/0 \newline % Row Count 14 (+ 1)
-{\bf{SMO and DMO XPs}} /0/1/1 \newline % Row Count 15 (+ 1)
-{\bf{transform noise words}} /0/1/0 \newline % Row Count 16 (+ 1)
-{\bf{two digit year cutoff}} /1753/9999/2049 \newline % Row Count 17 (+ 1)
-{\bf{user connections}} /0/32767/0 \newline % Row Count 18 (+ 1)
-{\bf{user options}} /0/32767/0 \newline % Row Count 19 (+ 1)
-{\bf{xp\_cmdshell}} /0/1/0% Row Count 20 (+ 1)
} \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Database-Level Configuration}}  \tn
\SetRowColor{white}
\mymulticolumn{1}{x{8.4cm}}{{\bf{{\emph{opt/statement}}}}% Row Count 1 (+ 1)
} \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{AUTO OPTIONS}}  \tn
\SetRowColor{white}
\mymulticolumn{1}{x{8.4cm}}{AUTO\_CLOSE/True \newline % Row Count 1 (+ 1)
\seqsplit{AUTO\_CREATE\_STATISTICS/True} \newline % Row Count 2 (+ 1)
\seqsplit{AUTO\_UPDATE\_STATISTICS/True} \newline % Row Count 3 (+ 1)
AUTO\_SHRINK /False \newline % Row Count 4 (+ 1)
\seqsplit{Auto\_Update\_Statistics\_Asynchronously/False}% Row Count 6 (+ 2)
} \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Database Mirroring Options}}  \tn
\SetRowColor{white}
\mymulticolumn{1}{x{8.4cm}}{PARTNER / FAILOVER \newline % Row Count 1 (+ 1)
PARTNER / \seqsplit{FORCE\_SERVICE\_ALLOW\_DATA\_LOSS} \newline % Row Count 2 (+ 1)
PARTNER / OFF \newline % Row Count 3 (+ 1)
PARTNER / RESUME \newline % Row Count 4 (+ 1)
PARTNER / SAFETY OFF \newline % Row Count 5 (+ 1)
PARTNER / SUSPEND \newline % Row Count 6 (+ 1)
PARTNER / TIMEOUT 20 \newline % Row Count 7 (+ 1)
WITNESS / OFF% Row Count 8 (+ 1)
} \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Date Correlation Optimization Option}}  \tn
\SetRowColor{white}
\mymulticolumn{1}{x{8.4cm}}{\seqsplit{DATE\_CORRELATION\_OPTIMIZATION} / ON% Row Count 1 (+ 1)
} \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Emergency Mode Option}}  \tn
\SetRowColor{white}
\mymulticolumn{1}{x{8.4cm}}{PAGE\_VERIFY / TORN\_PAGE\_DETECTION \newline % Row Count 1 (+ 1)
PAGE\_VERIFY / CHECKSUM% Row Count 2 (+ 1)
} \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{PAGE VERIFY Option}}  \tn
\SetRowColor{white}
\mymulticolumn{1}{x{8.4cm}}{PAGE\_VERIFY / TORN\_PAGE\_DETECTION \newline % Row Count 1 (+ 1)
PAGE\_VERIFY / CHECKSUM% Row Count 2 (+ 1)
} \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{PARAMETERIZATION}}  \tn
\SetRowColor{white}
\mymulticolumn{1}{x{8.4cm}}{PARAMETERIZATION / FORCED \newline % Row Count 1 (+ 1)
PARAMETERIZATION / SIMPLE% Row Count 2 (+ 1)
} \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Service Broker Options}}  \tn
\SetRowColor{white}
\mymulticolumn{1}{x{8.4cm}}{SET NEW\_BROKER \newline % Row Count 1 (+ 1)
SET ENABLE\_BROKER \newline % Row Count 2 (+ 1)
SET \seqsplit{ERROR\_BROKER\_CONVERSATIONS} \newline % Row Count 3 (+ 1)
SET TRUSTWORTHY ON \newline % Row Count 4 (+ 1)
SET DISABLE\_BROKER% Row Count 5 (+ 1)
} \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{SQL Options}}  \tn
\SetRowColor{white}
\mymulticolumn{1}{x{8.4cm}}{\seqsplit{READ\_COMMITTED\_SNAPSHOT/OFF} \newline % Row Count 1 (+ 1)
ANSI\_NULLS /OFF \newline % Row Count 2 (+ 1)
ANSI\_PADDING/OFF \newline % Row Count 3 (+ 1)
ANSI\_WARNINGS/OFF \newline % Row Count 4 (+ 1)
ARITHABORT/OFF \newline % Row Count 5 (+ 1)
\seqsplit{CONCAT\_NULL\_YIELDS\_NULL/OFF} \newline % Row Count 6 (+ 1)
QUOTED\_IDENTIFIER/OFF \newline % Row Count 7 (+ 1)
NUMERIC\_ROUNDABORT /OFF \newline % Row Count 8 (+ 1)
RECURSIVE\_TRIGGERS /OFF% Row Count 9 (+ 1)
} \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{CURSOR OPTIONS}}  \tn
\SetRowColor{white}
\mymulticolumn{1}{x{8.4cm}}{\seqsplit{CURSOR\_CLOSE\_ON\_COMMIT/OFF} \newline % Row Count 1 (+ 1)
CURSOR\_DEFAULT/GLOBAL% Row Count 2 (+ 1)
} \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Change Server-Level Options}}  \tn
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{8.4cm}}{- {\bf{New query Using Transact-SQL (sp-configure)}} \newline  \newline Use AdventureWorks2012; \newline GO \newline sp\_configure 'show advanced options', 1; \newline GO \newline RECONFIGURE; \newline GO \newline sp\_configure 'fill factor', 100; \newline GO \newline RECONFIGURE; \newline GO} \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Change Database-Level Options}}  \tn
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{8.4cm}}{ALTER DATABASE \textless{}database\_name\textgreater{} SET \textless{}options\textgreater{} \textless{}statement\textgreater{}} \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}


% That's all folks
\end{multicols*}

\end{document}