3,914 reputation
21736
bio website
location Bern, Switzerland
age 49
visits member for 3 years, 11 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.


1d
revised How to identify where a package execution has spent most of the time?
added 6 characters in body
1d
revised How to transfer table in SQL Server 2008 from one computer to another
added 3 characters in body; edited title
2d
revised SQL Server: grant select access to a user in a view and not in its tables
added 12 characters in body; edited title
2d
revised How do I update and insert specific set of rows to an existing table using Merge in SQL Server 2008 R2?
deleted 1 character in body; edited title
2d
revised Un-attaching SPL 2008 BD not willing to Attach
added 40 characters in body
2d
revised SQL Server stored procedure validity checking
deleted 15 characters in body; edited title
2d
revised Maintaining multiple build versions of asp .net / SQL Server applications
Product is officially called **SQL Server** - neither MSSQL, nor MS SQL nor MS-SQL nor anything like that. ...
Jan
20
comment T-SQL — Why do ALTER and UPDATE statement only run when separated into their own batch?
Just a brief side note: GO is not a (SQL) statement - it's a separator that is specific to SQL Server Mgmt Studio.
Jan
20
revised T-SQL — Why do ALTER and UPDATE statement only run when separated into their own batch?
added 3 characters in body; edited title
Jan
20
revised SQL Server - Slow Database for no apparent reason
added 5 characters in body; edited tags; edited title
Jan
15
revised SQL Server changes in tables reverted after two three days in two different DBs
added 1 character in body; edited tags; edited title
Jan
15
revised SQL Server CE tools to modify database in network share
added 9 characters in body; edited title
Jan
15
revised Save multiple SQL jobs in single files
added 4 characters in body
Jan
15
revised What's the best practice to avoid collisions in throwaway temp tables?
added 62 characters in body
Jan
15
revised setting up multi-user, multi database server(sql)
edited tags
Jan
15
comment Subquery returned more than 1 value. This is not permitted + Trigger Error SQL Server
Your trigger has MAJOR FLAW in that you seem to assume it'll be called once per row - that is not the case. The trigger will fire once per statement, so if your UPDATE statements affects 25 rows, you'll get the trigger fired once, but then Inserted and Deleted will each contain 25 rows. Which of those 25 rows will your code select? It's non-deterministic. You need to rewrite your trigger to take this into account!
Jan
15
reviewed Edit Subquery returned more than 1 value. This is not permitted + Trigger Error SQL Server
Jan
15
revised Subquery returned more than 1 value. This is not permitted + Trigger Error SQL Server
Code Block
Jan
14
revised Migrate small sets of data from production to staging/sandbox
added 5 characters in body
Jan
14
revised Change SQL Server 2000 from Active/Active to Active/Passive
added 22 characters in body