x2line blogs

x2line - Blogs

Front Page Recent

Get Fosimo on CNET Download.com!

MSSQL 2008: Spatial Data Types - Geography and Geometry

In addition to new DATETIME data types introduced in MSSQL 2008 there are geography and geometry data types introduced - useful for storing and manipulating geodetic data. Geometry data type is used to store flat map data like points, lines, and shapes [ ... ]

posted @ 05/15/2008 2:28 AM (by Anatoly Lubarsky)

MSSQL 2008: What is DATETIME2

MSSQL 2008 introduces several new DATETIME datatypes for T-SQL: TIME, DATE, DATETIME2, DATETIMEOFFSET. It is obvious that TIME and DATE provide the ability to store separately DATE and TIME parts of DATETIME. It was not possible to do in previous versions of MSSQL, however [ ... ]

posted @ 05/13/2008 7:13 PM (by Anatoly Lubarsky)

T-SQL: LIKE Operator and Wildcard Characters

An interesting issue I came into recently. Suppose you have a search procedure - which consists of some SELECT query which gets a query phrase as a parameter and searches through a table coulumn using LIKE [ ... ]

posted @ 05/08/2008 2:37 AM (by Anatoly Lubarsky)

MSSQL: Search and Replace in a TEXT(NTEXT) column

Sometimes we need to search and replace a text value in the entire table. The column in question is of TEXT or NTEXT datatype. T-SQL REPLACE function does not work with TEXT/NTEXT datatype. Instead we have to use several other functions [ ... ]

posted @ 05/03/2008 8:16 PM (by Anatoly Lubarsky)

Facebook's Standard Security Settings Sufficient ? (Not)

BBC came out with an article today Identity 'at risk' on Facebook which discusses potential stealing of user data by 3rd parties applications of Facebook Development Platform: When you add an application [ ... ]

posted @ 05/02/2008 4:43 AM (by Anatoly Lubarsky)

ASP.NET tip: Autonumber Rows in ASP.NET Repeater control

How to print the current row number in an ASP.NET Repeater control ? The easiest way to autonumber rows in Repeater is to use markup or ItemDataBound event [ ... ]

posted @ 04/26/2008 2:37 AM (by Anatoly Lubarsky)

Reducing Memory Footprint of any Process with EmptyWorkingSet

Ever wondered why does .NET winform application takes so much memory on startup ? It is obvious that most of this memory is not in use. The reason is that JIT compiler and the whole winforms engine is loaded into the process [ ... ]

posted @ 04/20/2008 9:07 PM (by Anatoly Lubarsky)

C# Win32 API: Flash Window (FlashWindowEx)

he following method will flash the title bar or taskbar button or tray icon. Need to wrap a method imported from user32: FlashWindowEx [ ... ]

posted @ 04/19/2008 9:11 PM (by Anatoly Lubarsky)

Calculate Euler Number with Recursion

I recently went through several posts I had made on one of the development forums back then in 2005. I've found one of them interesting and want to repost it here. The question went like this: How can I calculate euler number with recursion [ ... ]

posted @ 03/11/2008 4:01 AM (by Anatoly Lubarsky)

HOW TO: Remove Last Character from String

Very often during development process we need to remove last character from a string. It could be a trailing slash or trailing comma resulted as a side effect of building delimited strings [ ... ]

posted @ 03/10/2008 3:36 AM (by Anatoly Lubarsky)


Community Archives: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74

 

Syndication

OPML (bloggers)
RSS (recent posts)
 

Bloggers

Anatoly Lubarsky
(730, 08/23/2018 12:05 AM)
 
x2line developer
(5, 04/21/2007 5:13 PM)
 
x2line test
(2, 03/29/2006 5:49 AM)
 
AL
(1, 03/27/2005 2:50 AM)