3,609 reputation
21733
bio website
location Bern, Switzerland
age 48
visits member for 3 years, 5 months
seen 16 hours ago

Note to all SO beginner:

Please read (and embrace!) Jon Skeet's helpful hints on how to write a good question (or at least his short version here ) - one that has a chance that someone can answer it.


A Pascal/Delphi programmer and database freak at heart, I work as a C# developer on line-of-business applications (mostly ASP.NET).

I'm interested mostly in distributed systems (WCF), database (design and SQL), and Active Directory.


I'm an MCPD .NET 4 Web Developer, MCPD .NET 4 Windows Developer, MCPD Enterprise Application Developer (.NET 3.5), and MCTS for WCF, ADO.NET, Winforms and ASP.NET.


1d
comment utf8mb4 in SQL Server Express
The nchar/nvarchar types are Unicode and thus capable of handling Chinese, Japanese, Cyrillic, Arabic, Hebrew etc. characters. char/varchar are not Unicode, and thus very limited in their support for non-Latin alphabets. If you need far eastern characters, use nvarchar for your strings. Drawback: nvarchar always uses 2 bytes per character for its encoding
1d
revised utf8mb4 in SQL Server Express
added 23 characters in body; edited title
1d
revised Reading Data from SQL Server database
added 4 characters in body; edited title
1d
revised Spatial Index ignored when using additional non-spatial conditions
edited body; edited title
1d
revised Incorrect result when you execute a query that uses WITH RECOMPILE option in SQL Server 2012
deleted 22 characters in body; edited title
Jul
26
comment How to fix the SQL from SQL Server to Oracle?
Bad habits to kick : using old-style JOINs - that old-style comma-separated list of tables style was discontinued with the ANSI-92 SQL Standard (more than 20 years ago)
Jul
26
revised How to fix the SQL from SQL Server to Oracle?
added 50 characters in body; edited title
Jul
25
awarded  Notable Question
Jul
25
revised Derive daily delta from total daily counts? Tsql
added 13 characters in body; edited tags
Jul
25
revised Get complete value of varchar(max) field - SQL Server 2005
added 61 characters in body; edited title
Jul
22
revised Explanation requested for slow DELETE with SQL Server
deleted 11 characters in body
Jul
22
revised CREATE DATABASE defaulting to wrong log path
deleted 7 characters in body
Jul
22
revised Long running simple query SQL Server 2008 R2
added 9 characters in body
Jul
22
revised Recovery from lost SQL Server data file
added 31 characters in body; edited title
Jul
22
revised How do I include nulls during comparisons in SQL Server?
deleted 37 characters in body; edited title
Jul
22
revised Setting up a new database
added 31 characters in body
Jul
22
awarded  Enlightened
Jul
22
awarded  Nice Answer
Jul
22
revised Long running simple query SQL Server 2008 R2
deleted 46 characters in body; edited title
Jul
22
revised SQL Server 2008 R2 memory issue
added 20 characters in body; edited title