Tutorial by Examples: x

Clustered column store index can be rebuilt if you have a lot of deleted rows: ALTER INDEX cci ON Products REBUILD PARTITION = ALL Rebuilding CLUSTERED COLUMNSTORE will "reload" data from the current table into new one and apply compression again, remove deleted rows, etc. You can re...

Extract all file contents of a zip file import zipfile with zipfile.ZipFile('zipfile.zip','r') as zfile: zfile.extractall('path') If you want extract single files use extract method, it takes name list and path as input parameter import zipfile f=open('zipfile.zip','rb') zfile=zipfile.Z...

The wxWidgets project has adopted the release model used by the Linux Kernel project where there are alternating sets of releases where one set are considered "stable" and the next set are considered "development." For wxWidgets "stable" and "development" do n...

public static Expression<Func<T, bool>> GetExpression<T>(IList<QueryFilter> filters) { Expression exp = null; // Represents a named parameter expression. {parm => parm.Name.Equals()}, it is the param part // To create a ParameterExpression need the ty...

For one filter: Here is where the query is created, it receives a expression parameter and a filter. private static Expression GetExpression<T>(ParameterExpression param, QueryFilter queryFilter) { // Represents accessing a field or property, so here we are accessing for example: ...

ConstantExpression must be the same type of the MemberExpression. The value in this example is a string, which is converted before creating the ConstantExpression instance. private static ConstantExpression GetConstant(Type type, string value) { // Discover the type, convert it, and create Co...

/** *@NApiVersion 2.x *@NScriptType Suitelet */ define([],function() { // NetSuite's AMD pattern function onRequest_entry(context) { // Suitelet entry function receives a context obj context.response.write('Hello World'); // Write a response using the context obj } retu...

If you want to append a series of values [1,2] to the column of dataframe df, you will get NaNs: import pandas as pd series=pd.Series([1,2]) df=pd.DataFrame(index=[3,4]) df['col']=series df col 3 NaN 4 NaN because setting a new column automatically aligns the data by the inde...

Promise.resolve([1, 2, 3]) .mapSeries(el => Promise.resolve(el * el)) // in real world, use Promise returning async function .then(console.log)

const Koa = require('koa') const app = new Koa() app.use(async ctx => { ctx.body = 'Hello World' }) app.listen(8080)

This ability was added to the Bind markup extension after v1607 (Redstone 1). You can specify a function path, as well as arg paths and constant args. Let's assume we have a function defined in our backcode: public string Translate(string text, string from, string to) Now we can use bind to eva...

This guide assumes you have already installed react, redux, react-router and react-redux and have configured react, redux and react-router., If you haven't, Please do so. Note: While react-router in not a dependency of react-redux, It's very likely that we will using it in our react application for...

You should have the basic express-generator template In app.js, add(you can add it anywhere after var app = express.app()): app.post(function(req, res, next){ next(); }); Now in your index.js file (or its respective match), add: router.get('/ajax', function(req, res){ res.render('aj...

Import Element Tree module and open xml file, get an xml element import xml.etree.ElementTree as ET tree = ET.parse('sample.xml') root=tree.getroot() element = root[0] #get first child of root element Element object can be manipulated by changing its fields, adding and modifying attributes, a...

Install openfire or any chat server in your system or on server. For more details click here. Create android project and add these libraries in gradle: compile 'org.igniterealtime.smack:smack-android:4.2.0' compile 'org.igniterealtime.smack:smack-tcp:4.2.0' compile 'org.igniterealtime.smack:smac...

Create a class name ErrorMatcher inside your test package with below code: public class ErrorMatcher { @NonNull public static Matcher<View> withError(final String expectedErrorText) { Checks.checkNotNull(expectedErrorText); return new BoundedMatcher<View, ...

Adding a Product to a Shopping Cart The following example demonstrates how to Add a product (or anything) to a Database Table asynchronously, using AJAX, and TypeScript. declare var document; declare var xhr: XMLHttpRequest; window.onLoad = () => { Start(); }; function Start() { ...

Google Chrome supports extensions that augment the way the browser works. They can add functionality to web pages or to the browser UI. Any developer can create an extension and list it in the Chrome Web Store. See more on the extensions page.

Let's assume we have an entity status field with 3 options Tentative Pending Approved Our goal is to show different color for each status as follow: Tentative will be Red Pending will be Orange Approved will be Green The switch condition: =Switch(Fields!ItemStatus.Value = "Tentativ...

Q. Why we need compilation? Ans. We need compilation for achieving higher level of efficiency of our Angular applications. Take a look at the following example, // ... compile: function (el, scope) { var dirs = this._getElDirectives(el); var dir; var scopeCreated; dirs.forEach(functi...