3,509 reputation
21529
bio website
location Bern, Switzerland
age 48
visits member for 3 years, 2 months
seen 10 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
18
revised SQL Server 2008 R2 Missing Index
edited tags
Mar
18
answered SQL Server 2008 R2 Missing Index
Mar
18
revised SQL Server and Entity Framework
added 11 characters in body; edited title
Mar
18
comment Efficient way to Add NON-CLUSTERED Index?
Try your two approaches, measure performance -> pick the better option!
Mar
17
revised SQL Server Express Freezes for a couple minutes
edited body; edited title
Mar
15
comment Update Statement takes forever to complete
If you're trying to update 35'000 rows at once, you might run into the problem that SQL Server will use a lock escalation and will attempt to lock the entire table for an update. If something else is already happening at the same time, SQL Server might just not be able to get that table-wide, update/exclusive lock - so it'll wait until it does get that lock... you can get around this by updating no more than 5000 rows at once
Mar
14
revised SQL Server database change in to single user type and We cannot access the tables
deleted 1 characters in body; edited title
Mar
13
comment SQL Server 2008 R2: cannot attach database
Which part of file not found do you not understand? The file you're looking for to attach isn't there ... Are you trying to attach to a remote SQL Server instance, and the .mdf file is on your local `C:` drive? That won't work! The file must be on the server machine - not your local PC ....
Mar
12
revised how to restore .bkp file in SQL Server
added 15 characters in body; edited title
Mar
11
revised Import remote SQL Server 2008 Express database to local SQL Server 2008 Standard database
added 37 characters in body; edited tags; edited title
Mar
10
revised Oracle dead with unknown reason
deleted 6 characters in body; edited title
Mar
10
revised Is there a limit on the number of blobs storable in SQL Server with filestream?
added 15 characters in body; edited title
Mar
8
revised SQL Server Date Conversion
added 17 characters in body; edited tags
Mar
8
answered Subqueries are not allowed in this context. Only scalar expressions are allowed
Mar
8
revised SQL Server 2012 Not matching Join Query
deleted 9 characters in body; edited title
Mar
7
revised Two relations to same table in SQL Server
Product is officially called *SQL Server* - neither "MS SQL", nor "MSSQL", nor "MS-SQL" or anything like that...
Mar
6
revised Frequent Delete & Insert, impact on performance
deleted 32 characters in body; edited title
Mar
5
awarded  Popular Question
Mar
4
revised SQL Server Express 2008: Can I store database files (.mdf, .ldf) in directory other than the default DATA directory?
added 15 characters in body
Mar
4
revised How to view an encrypted view or stored procedure
added 8 characters in body; edited title