Tutorial by Examples: nd

Rebuilding indexes is done using the following statement ALTER INDEX All ON tableName REBUILD; This drops the index and recreates it, removing fragementation, reclaims disk space and reorders index pages. One can also reorganize an index using ALTER INDEX All ON tableName REORGANIZE; which ...

EXEC sp_MSForEachTable 'ALTER INDEX ALL ON ? REBUILD'

OVERVIEW cocos2d-x is an open source, cross-platform game engine. It allows developers to code in C++, Lua and Javascript deployment into iOS, Android, Windows Phone, Mac OS X, Windows Desktop and Linux. PREREQUISITES Build Requirements Mac OS X 10.7+, Xcode 4.6+ Windows 7+, VS 2012+ Ubunt...

Orders a collection by a specified value. When the value is an integer, double or float it starts with the maximal value, which means that you get first the positive values, than zero and afterwords the negative values (see Example 1). When you order by a char the method compares the ascii val...

How to use conditional execution of command lists Any builtin command, expression, or function, as well as any external command or script can be executed conditionally using the &&(and) and ||(or) operators. For example, this will only print the current directory if the cd command was succ...

def lst = [10, 20, 30, 40] lst.findAll { it > 25 } // [30, 40]

def lst = [10, 20, 30, 40] lst.find { it > 25 } // 30. Note: it returns a single value

This is an example on how to use React Native's BackAndroid along with the Navigator. componentWillMount registers an event listener to handle the taps on the back button. It checks if there is another view in the history stack, and if there is one, it goes back -otherwise it keeps the default beha...

You can start the remote debugging from Developer menu. After selecting the enable remote debugging it will open Google Chrome, So that you can log the output into your console. You can also write debugger syntax into your js code.

SELECT * INTO NewTable FROM OldTable Creates a new table with structure of old table and inserts all rows into the new table. Some Restrictions You cannot specify a table variable or table-valued parameter as the new table. You cannot use SELECT…INTO to create a partitioned table, even whe...

adb shell am start -n com.android.settings/.DevelopmentSettings Will navigate your device/emulator to the Developer Options section.

First define an ExitActivity in the AndroidManifest.xml <activity android:name="com.your_example_app.activities.ExitActivity" android:autoRemoveFromRecents="true" android:theme="@android:style/Theme.NoDisplay" /> Afterwards the ExitA...

When factors are created with defaults, levels are formed by as.character applied to the inputs and are ordered alphabetically. charvar <- rep(c("W", "n", "c"), times=c(17,20,14)) f <- factor(charvar) levels(f) # [1] "c" "n" "W" ...

To normalize the database in the second form, there must not be any partial dependency of any column on primary key. Let's consider the following example: idnamedobsubject1Mark1-1-1981Physics2Jack2-2-1982Math2Jack2-2-1982Biology3John3-3-1983Math This table is considered to have a composite primar...

Collections and Maps evaluates to true if not null and not empty and false if null or empty /* an empty map example*/ def userInfo = [:] if (!userInfo) userInfo << ['user': 'Groot', 'species' : 'unknown' ] will add user: 'Groot' , species : 'unknown' as default userInfo since the u...

The Kernel exposes methods for getting the list of global_variables and local_variables: cats = 42 $demo = "in progress" p global_variables.sort #=> [:$!, :$", :$$, :$&, :$', :$*, :$+, :$,, :$-0, :$-F, :$-I, :$-K, :$-W, :$-a, #=> :$-d, :$-i, :$-l, :$-p, :$-v, :$-w, :$...

Function Send-TCPMessage { Param ( [Parameter(Mandatory=$true, Position=0)] [ValidateNotNullOrEmpty()] [string] $EndPoint , [Parameter(Mandatory=$true, Position=1)] [int] $Port , ...

To get a difference between two Calendars, use getTimeInMillis() method: Calendar c1 = Calendar.getInstance(); Calendar c2 = Calendar.getInstance(); c2.set(Calendar.DATE, c2.get(Calendar.DATE) + 1); System.out.println(c2.getTimeInMillis() - c1.getTimeInMillis()); //outputs 86400000 (24 * 60 * ...

template <class InputIterator, class UnaryPredicate> InputIterator find_if (InputIterator first, InputIterator last, UnaryPredicate pred); Effects Finds the first element in a range for which the predicate function pred returns true. Parameters first => iterator pointing to the begin...

// Usage: var arc={ cx:150, cy:150, innerRadius:75, outerRadius:100, startAngle:-Math.PI/4, endAngle:Math.PI } drawArc(arc,'skyblue','gray',4); function drawArc(a,fill,stroke,strokewidth){ ctx.beginPath(); ctx.arc(a.cx,a.cy,a.innerRadius,a.startAngle,a.endAngle); ...