Front Page Recent
| Fosimo |
Fosimo.TR |
 |
 |
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 [ ... ]
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 [ ... ]
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 [ ... ]
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 [ ... ]
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 [ ... ]
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 [ ... ]
Bathroom Stall Vandalism on BEBO has passed 2000 users. Originally a Facebook application - it was scaled up in january 2008 t osupport Bebo platform [ ... ]
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 [ ... ]
he following method will flash the title bar or taskbar button or tray icon. Need to wrap a method imported from user32: FlashWindowEx [ ... ]
Since one of my applications - Bathroom Stall Vandalism works both on bebo and on facebook as well - it is always useful to compare performance on both platforms. BTW, Bathroom Stall Vandalism is all about people virtually write and vandalize their rest rooms (LOL) [ ... ]
|
