3,509 reputation
21529
bio website
location Bern, Switzerland
age 48
visits member for 3 years, 2 months
seen 3 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.


Mar
4
revised How to view an encrypted view or stored procedure
added 8 characters in body; edited title
Mar
4
revised SQL query optmization
deleted 10 characters in body; edited tags
Mar
4
revised why stored procedure performance is very high compared to plain select query
deleted 22 characters in body
Mar
4
revised SQL Server error importing an Excel sheet
added 4 characters in body; edited title
Mar
2
comment Reduce DB size - SQL Server, SSMS
There is no version 2012 R2 - there is 2008 R2, or 2012 (with or without SP1) ....
Mar
2
revised Reduce DB size - SQL Server, SSMS
deleted 4 characters in body; edited title
Mar
2
revised If user owns a database fixed role are they the admin of the role?
deleted 1 characters in body
Mar
2
revised What can cause Reads to slow down on SQL Server 2008R2?
added 14 characters in body; edited title
Feb
28
revised SQL Server 2000 - 'Performance: Deadlock'
added 11 characters in body; edited title
Feb
28
revised MySQL beginner in troubles
added 11 characters in body; edited tags
Feb
27
revised indexing on multiple nvarchar(max) columns
added 29 characters in body
Feb
27
revised SQL Server 2008 R2 index rebuild fails with severity 17
added 4 characters in body; edited title
Feb
27
revised indexing on multiple nvarchar(max) columns
deleted 12 characters in body
Feb
26
comment Help with “Flexible” vs Fixed Tables
I definitely share your concern .... this already smells bad now.... wait until you have millions of rows ..... tell your super-clever boss to read this exposé on how EAV can go horribly wrong and sink companies - hopefully we'll come around and change his mind!
Feb
26
revised Help with “Flexible” vs Fixed Tables
added 6 characters in body
Feb
23
revised Need to migrate SQL Server to MySQL
added 7 characters in body
Feb
23
revised SQL Server to MySQL sync, using Workbench, FreeTDS, and iODBC on 10.9
added 9 characters in body; edited title
Feb
23
revised Performance of dynamic SQL Server reporting queries?
added 7 characters in body; edited title
Feb
22
revised SQL Server 2008 mirroring migration to SQL Server 2012 always on
added 52 characters in body; edited title
Feb
22
revised SQL Server 2012 database 3 mirroring questions
added 40 characters in body; edited title