Tutorial by Examples: st

Query store can be enabled on database by using the following command: ALTER DATABASE tpch SET QUERY_STORE = ON SQL Server/Azure SQL Database will collect information about executed queries and provide information in sys.query_store views: sys.query_store_query sys.query_store_query_text sy...

The following query will return informationa about qeries, their plans and average statistics regarding their duration, CPU time, physical and logical io reads. SELECT Txt.query_text_id, Txt.query_sql_text, Pl.plan_id, avg_duration, avg_cpu_time, avg_physical_io_reads, avg_logica...

If you want to remove some query or query plan from query store, you can use the following commands: EXEC sp_query_store_remove_query 4; EXEC sp_query_store_remove_plan 3; Parameters for these stored procedures are query/plan id retrieved from system views. You can also just remove execution ...

The $http requests require time which varies depending on the server, some may take a few milliseconds, and some may take up to a few seconds. Often the time required to retrieve the data from a request is critical. Assuming the response value is an array of names, consider the following example: ...

$url1 = [uri]::EscapeDataString("http://test.com?test=my value") # url1: http%3A%2F%2Ftest.com%3Ftest%3Dmy%20value $url2 = [uri]::EscapeUriString("http://test.com?test=my value") # url2: http://test.com?test=my%20value # HttpUtility requires at least .NET 1.1 to be instal...

Note: these examples use the variables created in the Quick Start: Encoding section above. # url1: http%3A%2F%2Ftest.com%3Ftest%3Dmy%20value [uri]::UnescapeDataString($url1) # Returns: http://test.com?test=my value # url2: http://test.com?test=my%20value [uri]::UnescapeDataString($url2) # Re...

$scheme = 'https' $url_format = '{0}://example.vertigion.com/foos?{1}' $qs_data = @{ 'foo1'='bar1'; 'foo2'= 'complex;/?:@&=+$, bar''"'; 'complex;/?:@&=+$, foo''"'='bar2'; } [System.Collections.ArrayList] $qs_array = @() foreach ($qs in $qs_data.GetEnumerator()...

$scheme = 'https' $url_format = '{0}://example.vertigion.com/foos?{1}' $qs_data = @{ 'foo1'='bar1'; 'foo2'= 'complex;/?:@&=+$, bar''"'; 'complex;/?:@&=+$, foo''"'='bar2'; } [System.Collections.ArrayList] $qs_array = @() foreach ($qs in $qs_data.GetEnumerator()...

Encoded with [uri]::EscapeDataString() First, we'll decode the URL and Query String encoded with [uri]::EscapeDataString() in the above example: https://example.vertigion.com/foos? foo2=complex%3B%2F%3F%3A%40%26%3D%2B%24%2C%20bar'%22& complex%3B%2F%3F%3A%40%26%3D%2B%24%2C%20foo'%22=bar2&am...

Encoded with [uri]::EscapeDataString() First, we'll decode the URL and Query String encoded with [uri]::EscapeDataString() in the above example: https://example.vertigion.com/foos? foo2=complex%3B%2F%3F%3A%40%26%3D%2B%24%2C%20bar'%22& complex%3B%2F%3F%3A%40%26%3D%2B%24%2C%20foo'%22=bar2&am...

Objective-C and Xib Add a target to an existing XCode project In the Add Target select Custom KeyBoard Add the target like this: Your project file directory should look something like this Here myKeyBoard is the name of the added Target Add new Cocoatouch file of type of type UIView and ...

To use the IMAP functions in PHP you'll need to install the IMAP extension: Debian/Ubuntu with PHP5 sudo apt-get install php5-imap sudo php5enmod imap Debian/Ubuntu with PHP7 sudo apt-get install php7.0-imap YUM based distro sudo yum install php-imap Mac OS X with php5.6 brew reinsta...

Once you've connected to your mailbox, you'll want to take a look inside. The first useful command is imap_list. The first parameter is the resource you acquired from imap_open, the second is your mailbox string and the third is a fuzzy search string (* is used to match any pattern). $folders = ima...

Each control has a property DataBindings which is a list of System.Windows.Forms.Binding objects. The Add()-method has some overloads which enables you easily binding to the property of an object: textBox.DataBindings.Add( "Text", dataObj, "MyProperty" ); Note, that binding b...

First of all, install gulp and gulp-jsdoc3 to your project: npm install gulp-jsdoc3 --save-dev Then add it to your gulpfile.js var gulp = require('gulp'); var jsdoc = require('gulp-jsoc3'); gulp.task('doc', function (cb){ gulp.src('src/*.js') .pipe(jsdoc(cb)); }); In order...

// myString is "hi" NSMutableString *reversedString = [NSMutableString string]; NSInteger charIndex = [myString length]; while (charIndex > 0) { charIndex--; NSRange subStrRange = NSMakeRange(charIndex, 1); [reversedString appendString:[myString substringWithRange:subS...

Typically, packages consist of one or more modules. As packages grow, it may be useful to organize the main module of the package into smaller modules. A common idiom is to define those modules as submodules of the main module: module RootModule module SubModule1 ... end module SubModul...

Installation via NodeJS is the recommended method. It is preferred because you can use it to build the files selecting just the components you want. Step 1: Install Node (Link) Step 2: Install Gulp globally ( -g ) on your computer npm install -g gulp Semantic UI uses Gulp to provide command ...

This document details the steps to obtain the facebook access tokens and the using the tokens to fetch FB feeds. Example: A live example is available in https://newtonjoshua.com Introduction to Graph API: The Graph API is the primary way to get data in and out of Facebook's platform. It's a...

MasterDetailPage: Manages two separate Pages (panes) of information. XAML <?xml version="1.0" encoding="utf-8" ?> <MasterDetailPage xmlns="http://xamarin.com/schemas/2014/forms" xmlns:x="http://schemas.microsoft.com/winfx/2009/xaml" x:Class=&quot...