Tutorial by Examples: i

Most KVO and KVC functionality is already implemented by default on all NSObject subclasses. To start observing a property named firstName of an object named personObject do this in the observing class: [personObject addObserver:self forKeyPath:@"firstName" ...

Objective-C NSURL *url = [[NSURL alloc] initWithString:@"YOUR URL"]; // url can be remote or local AVPlayer *player = [AVPlayer playerWithURL:url]; // create a player view controller AVPlayerViewController *controller = [[AVPlayerViewController alloc] init]; [self presentViewC...

A function is a block of organised, reusable code that is used to perform a single, related action. Functions usually "take in" data, process it, and "return" a result. User defined function A function defined by user. Example in PHP //Function definition function a...

You can execute a database query from a String rather than a regular SOQL expression: String tableName = 'Account'; String queryString = 'SELECT Id FROM ' + tableName + ' WHERE CreatedDate >= YESTERDAY'; List<SObject> objects = Database.query(queryString); Since dynamic SOQL queries a...

DROP INDEX IX_NonClustered ON Employees

sys.dm_db_index_physical_stats ( { database_id | NULL | 0 | DEFAULT } , { object_id | NULL | 0 | DEFAULT } , { index_id | NULL | 0 | -1 | DEFAULT } , { partition_number | NULL | 0 | DEFAULT } , { mode | NULL | DEFAULT } ) Sample : SELECT * FROM sys.dm_db_inde...

avg_fragmentation_in_percent valueCorrective statement>5% and < = 30%REORGANIZE>30%REBUILD ALTER INDEX IX_NonClustered ON tableName REORGANIZE; ALTER INDEX ALL ON Production.Product REBUILD WITH (FILLFACTOR = 80, SORT_IN_TEMPDB = ON, STATISTICS_NORECOMPUTE = ON);

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'

PHP can also be run from command line directly using the CLI (Command Line Interface). CLI is basically the same as PHP from web servers, except some differences in terms of standard input and output. Triggering The PHP CLI allows four ways to run PHP code: Standard input. Run the php command ...

Enables the use of local type inference in declaring variables. What is type inference? You can declare local variables without explicitly stating a data type. The compiler infers the data type of a variable from the type of its initialization expression. Option Infer On: Dim aString = "12...

Document level It is on by default, but you can set it by placing Option Infer On|Off at the top of the code file. The option will apply to the whole document. Project level You can switch it on/off via the menu in Visual Studio: Project > [Project] Properties > Compile Tab > Option i...

Basically you can use type inference whenever it is possible. However, be careful when combining Option Infer Off and Option Strict Off, as this can lead to undesired run-time behavior: Dim someVar = 5 someVar.GetType.ToString() '--> System.Int32 someVar = "abc" someVar.GetType.To...

Sub Main() Dim People = New List(Of String)({"Bob Barker", "Ricky Bobby", "Jeff Bridges"}) Console.WriteLine(People.Contains("Rick James")) Console.WriteLine(People.Contains("Ricky Bobby")) Console.WriteLine(Pe...

There are three ways to create a graphics object From the Paint Event Every time the control is redrawn (resized, refreshed...) this event is called, use this way if you want the control to consistently draw on the control 'this will work on any object's paint event, not just the form ...

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...

SQL Server 2016 Escapes special characters in texts and returns text (nvarchar(max)) with escaped characters. Parameters: text. is a nvarchar expression representing the string that should be escaped. type. Escaping rules that will be applied. Currently the only supported value is 'json'...

From MSDN In a future version of SQL Server, ANSI_NULLS will always be ON and any applications that explicitly set the option to OFF will generate an error. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. ANSI NULLS being set t...

There is an example for extract a folder from an archive in the current location : tar -xf archive-name.tar If you want to extract a folder from an archive to a specfic destination : tar -xf archive-name.tar -C ./directory/destination

There is an example of listing content : tar -tvf archive.tar The option -t is used for the listing. For listing the content of a tar.gz archive, you have to use the -z option anymore : tar -tzvf archive.tar.gz