Set Memory Limit

In wp-config.php edit or add this line: define('WP_MEMORY_LIMIT', '256M');

By |2017-02-24T17:54:34+02:00February 24th, 2017|Comments Off on Set Memory Limit

ERD Notation

Relationships illustrate an association between two tables. In the physical data model, relationships are represented by stylized lines. Cardinality and ordinality, respectively, refer to the maximum number of times an instance in one entity can be associated with instances in the related entity, and the minimum number of times an instance in one entity can [...]

By |2016-02-18T22:21:23+02:00February 18th, 2016|Comments Off on ERD Notation


WHILE @@ROWCOUNT <> 0 BEGIN DELETE TOP (1000000) FROM [database].[schema].[table] WHERE [Col1] = 'abc' DBCC SHRINKDATABASE(N'_APPL' ) END

By |2015-06-15T22:01:20+02:00June 15th, 2015|Comments Off on DELETE BULK

Split (String)

string[] _Split = _DataRowView[2].ToString().Split((char)44); int _SplitCount = 1; foreach (string s in _Split) { if (s != "") { if (_SplitCount == 1) { _CursorX = System.Convert.ToInt32(s); } if (_SplitCount == 2) { _CursorY = System.Convert.ToInt32(s); } } _SplitCount += 1; } MSDN Artikel

By |2015-06-15T21:56:59+02:00June 15th, 2015|Comments Off on Split (String)


System.Net.HttpWebRequest _httpWebRequest = (System.Net.HttpWebRequest)System.Net.HttpWebRequest.Create(_URL); // Proxy Credentials System.Net.WebProxy _WebProxy = new System.Net.WebProxy(); _WebProxy.Address = new Uri(_ProxyServer); _WebProxy.Credentials = new System.Net.NetworkCredential(_ProxyUsername, _ProxyPassword); _httpWebRequest.Proxy = _WebProxy; // Network Credentials _httpWebRequest.Credentials = new System.Net.NetworkCredential(_NetworkUsername, _NetworkPassword); _httpWebRequest.PreAuthenticate = true; _httpWebRequest.Timeout = System.Threading.Timeout.Infinite; System.Net.HttpWebResponse _httpWebReponse = null; try { _httpWebReponse = (System.Net.HttpWebResponse)_httpWebRequest.GetResponse(); } catch (System.Net.WebException ex) { } System.IO.StreamReader [...]

By |2015-06-15T21:53:38+02:00June 15th, 2015|Comments Off on HttpWebRequest


System.IO.DriveInfo[] _allDrives = System.IO.DriveInfo.GetDrives(); foreach (System.IO.DriveInfo _Drive in _allDrives) { System.Windows.Forms.MessageBox.Show(_Drive.TotalSize.ToString()); System.Windows.Forms.MessageBox.Show(_Drive.TotalFreeSpace.ToString()); }

By |2015-06-15T21:51:29+02:00June 15th, 2015|Comments Off on Drive(s)


public delegate void Finished_EventHandler(System.DateTime _FinishedDateTime, string _RunTime, string _ThreadID); public event Finished_EventHandler Finished; private input_DelegateVoid private_DelegateVoid; public void Start(input_DelegateVoid _DelegateVoid) { Run(); } private void Run() { if (Finished != null) { Finished(System.DateTime.Now, (System.DateTime.Now - _StartTime).ToString(), System.Threading.Thread.CurrentThread.ManagedThreadId.ToString()); } } MSDN Artikel

By |2015-06-15T21:40:26+02:00June 15th, 2015|Comments Off on Events


delegate void delegateUpdateProgress(int _ProgressValue); this.Invoke(new delegateUpdateProgress(this.UpdateProgress), new object[] { 'some value' }); private void UpdateProgress(int _ProgressValue) { this.UltraStatusBar.Panels["Progress"].Visible = true; this.UltraStatusBar.Panels["Progress"].ProgressBarInfo.Value = _ProgressValue; } MSDN Artikel

By |2015-06-15T21:36:01+02:00June 15th, 2015|Comments Off on Delegate

Cursor (C#)

// wait System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor; // reset System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;

By |2015-06-15T21:29:18+02:00June 15th, 2015|Comments Off on Cursor (C#)

context connection (SQL CLR)

using (System.Data.SqlClient.SqlConnection _SQLConnection = new System.Data.SqlClient.SqlConnection("context connection=true")) { // SQL Connection öffnen _SQLConnection.Open(); } MSDN Artikel

By |2015-06-15T21:25:48+02:00June 15th, 2015|Comments Off on context connection (SQL CLR)
Go to Top