Tutorial by Examples: a

DBCC commands enable user to maintain space in database, clean caches, shrink databases and tables. Examples are: DBCC DROPCLEANBUFFERS Removes all clean buffers from the buffer pool, and columnstore objects from the columnstore object pool. DBCC FREEPROCCACHE -- or DBCC FREEPROCCACHE (0x06...

DBCC commands enable user to validate state of database. ALTER TABLE Table1 WITH NOCHECK ADD CONSTRAINT chkTab1 CHECK (Col1 > 100); GO DBCC CHECKCONSTRAINTS(Table1); --OR DBCC CHECKCONSTRAINTS ('Table1.chkTable1'); Check constraint is added with nocheck options, so it will not be ...

DBCC commands can show information about database objects. DBCC PROCCACHE Displays information in a table format about the procedure cache. DBCC OUTPUTBUFFER ( session_id [ , request_id ]) Returns the current output buffer in hexadecimal and ASCII format for the specified session_id (and o...

Trace flags in SQL Server are used to modify behavior of SQL server, turn on/off some features. DBCC commands can control trace flags: The following example switches on trace flag 3205 globally and 3206 for the current session: DBCC TRACEON (3205, -1); DBCC TRACEON (3206); The following examp...

DBCC statements act as Database Console Commands for SQL Server. To get the syntax information for the specified DBCC command use DBCC HELP (...) statement. The following example returns all DBCC statements for which Help is available: DBCC HELP ('?'); The following example returns options f...

ghci> :set -XOverloadedStrings ghci> import Data.Text as T isInfixOf :: Text -> Text -> Bool checks whether a Text is contained anywhere within another Text. ghci> "rum" `T.isInfixOf` "crumble" True isPrefixOf :: Text -> Text -> Bool checks whether a...

If you find these steps unfamiliar, consider starting here instead. Note these steps come from Stack Overflow Documentation. django-admin startproject myproject cd myproject python manage.py startapp myapp myproject/settings.py Install the app INSTALLED_APPS = [ 'django.contrib.admin', ...

First we need to make a ViewModel. Make a new folder /Models/Account, and add the file MemberLoginViewModel.cs to the folder. using System; using System.Collections.Generic; using System.ComponentModel.DataAnnotations; using System.Linq; using System.Web; namespace MyCMS.Models.Account { ...

Then make a view in the folder /Views/MacroPartials/Account @model MyCMS.Models.Account.MemberLoginViewModel @using MyCMS.Controllers.Account @if (User.Identity.IsAuthenticated) { <p>Logged in as: @User.Identity.Name</p> using (Html.BeginUmbracoForm<MemberLogin...

Make a new controller in the folder /Controllers/Account. Name the file MemberLoginSurfaceController.cs using MyCMS.Models.Account; using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using System.Web.Security; namespace MyCMS.Controll...

Processing provides method ellipse in order to draw ellipse. This code draws a white circle which has radius of 25 pixels. void setup() { size(500, 500); background(0); fill(255); noStroke(); } void draw() { ellipse(225, 225, 50, 50); } The signature of method ellip...

Git config allows you to customize how git works. It is commonly used to set your name and email or favorite editor or how merges should be done. To see the current configuration. $ git config --list ... core.editor=vim credential.helper=osxkeychain ... To edit the config: $ git config &lt...

Diamond problem is a common problem occurred in Object Oriented Programming, while using multiple-inheritance. Consider the case where class C, is inherited from class A and class B. Suppose that both class A and class B have a method called foo(). Then when we are calling the method foo(), compil...

Inheritance is one of the main concepts in Object Oriented Programming (OOP). Using inheritance, we can model a problem properly and we can reduce the number of lines we have to write. Let's see inheritance using a popular example. Consider you have to model animal kingdom (Simplified animal kingdo...

Method overloading is the way of using polymorphism inside a class. We can have two or more methods inside the same class, with different input parameters. Difference of input parameters can be either: Number of parameters Type of parameters (Data type) Order of the parameters Let's take a ...

Abstraction is one of the main concepts in Object Oriented Programming (OOP). This is the process of hiding the implementation details for the outsiders while showing only essential details. In another words, Abstraction is a technique to arrange the complexity of a program. There are two basic typ...

follow below step to add FCM in your swift Project 1- If you don't have an Xcode project yet, create one now. Create a Podfile if you don't have one: $ cd your-project directory $ pod init 2- Add the pods that you want to install. You can include a Pod in your Podfile like this: pod 'Fir...

Download the files from our.umbraco.org/download and unzip them in a folder. Set up web server hosting the folder you chose. Although IIS is a requirement for production sites, it runs fine for development in IIS Express. Set up file permissions for the folder. For development server it is okey ...

Check for updates to the Nuget package manager. In Visual Studio: Tools > Extensions and Updates > Updates > Visual Studio Gallery. Install if availalbe Create a new web application with template "ASP.NET Web Application with an Empty template" on .NET Framework 4.5.1 Open the...

Either you just want to test out Umbraco CMS, or host your site in a cloud service, you could sign up for a free trial at umbraco.com/cloud. The site you develop in the cloud service could be downloaded for local development or your own hosting later.