max-mulawa

SPSite site = SPContext.Current.Site;
SPSecurity.RunWithElevatedPrivileges(() =>
{
    SPWeb web = site.OpenWeb();
    //Task list contains 4000 elements
    SPList taskList = web.Lists.TryGetList("Tasks");
    if(taskList != null)
    {
        Label1.Text = "Task list has " + taskList.Items.Count.ToString();
    }

max-mulawa

using System;
using System.Collections.Generic;
using System.Data.SqlTypes;
using System.IO;
using Microsoft.SqlServer.Server;

[Serializable]
[SqlUserDefinedAggregate(Format.UserDefined, //Type implements IBinarySerialize 
    IsInvariantToDuplicates = false, //passing the same row will affect the result
    IsInvariantToNulls = false, // passing NULL value will affect the result

max-mulawa

USE DatabaseWithPolishCollation
GO
IF OBJECT_ID('TestCollaction','U') IS NOT NULL 
DROP TABLE TestCollaction


CREATE TABLE TestCollaction
(
	Id Int PRIMARY KEY,
	Name VARCHAR(20) NOT NULL,

max-mulawa

CREATE TABLE #TestCollaction2
(
  Id Int PRIMARY KEY ,
  Name VARCHAR(20) COLLATE Polish_CI_AS NOT NULL ,
  NameUnicode NVARCHAR(20) COLLATE Polish_CI_AS NOT NULL 
)

max-mulawa

SELECT *
 FROM TestCollaction tc
INNER JOIN #TestCollaction2 tc2
 ON tc.NameUnicode = tc2.NameUnicode

max-mulawa

USE DatabaseWithPolishCollation
GO

IF OBJECT_ID('TestCollaction','U') IS NOT NULL 
DROP TABLE TestCollaction

CREATE TABLE TestCollaction
(
	Id Int PRIMARY KEY,
	Name VARCHAR(20) NOT NULL,

max-mulawa

GO
IF NOT EXISTS(SELECT * FROM sys.databases 
               WHERE name = 'DatabaseWithPolishCollation')
BEGIN
 CREATE DATABASE DatabaseWithPolishCollation COLLATE Polish_CI_AS
END
GO
SELECT SERVERPROPERTY('Collation') 
--Resturns on my server: Latin1_General_CI_AS_KS_WS
GO

max-mulawa

IAsyncResult result = _client.BeginGetLocation("Warsaw,Poland",null, null);
//Do some work here
// Wait until the operation completes.
result.AsyncWaitHandle.WaitOne();
List<Location> locations = _client.EndGetLocation(result);

max-mulawa

IF OBJECT_ID('tempdb..#NumbersArray') IS NOT NULL 
  DROP TABLE #NumbersArray
GO
--Create T-SQL version of number array look-like
CREATE TABLE #NumbersArray
(
	ArrayIndex Int PRIMARY KEY CLUSTERED,
	Value Int
)
GO

max-mulawa

INSERT INTO dbo.Employee(FullName, City, Country, Email) 
VALUES('Maksymilian Mulawa',
                  'Warsaw',
                  'Poland',
                  '[email protected]')