3,689 reputation
21733
bio website
location Bern, Switzerland
age 49
visits member for 3 years, 6 months
seen yesterday

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.


Aug
2
revised Execution Plan in Microsoft SQL Server
deleted 3 characters in body
Aug
1
comment Good pattern to run SQL Server 2008 CDC changes
Side note: you should not use the sp_ prefix for your stored procedures. Microsoft has reserved that prefix for its own use (see Naming Stored Procedures), and you do run the risk of a name clash sometime in the future. It's also bad for your stored procedure performance. It's best to just simply avoid sp_ and use something else as a prefix - or no prefix at all!
Aug
1
revised Good pattern to run SQL Server 2008 CDC changes
added 71 characters in body; edited title
Jul
31
comment How to change the instance name of SQL Server Express 2008?
@CraigEfrein: I don't think it was - at least I never read anything about this being possible in SQL Server 2014 now....
Jul
31
revised Performing deltas / diffs over VPN from Oracle to SQL Server database
Product is officially called "SQL Server" - and neither MS-SQL, nor MSSQL, nor MS SQL or anything like that ....
Jul
31
revised how can I install Microsoft SQL Server 2005 Express Edition on Windows 8.1
added 5 characters in body; edited title
Jul
31
revised Reindexing Clustered Primary Key
deleted 24 characters in body
Jul
28
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
Jul
28
revised utf8mb4 in SQL Server Express
added 23 characters in body; edited title
Jul
28
revised Reading Data from SQL Server database
added 4 characters in body; edited title
Jul
28
revised Spatial Index ignored when using additional non-spatial conditions
edited body; edited title
Jul
28
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
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