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


Nov
29
answered Column name or number of supplied values does not match table definition error
Nov
29
revised SELECT with lots of left join is very slow in SQL Server 2014
added 30 characters in body
Nov
29
revised SQL Server 2008R2 - how to install replication components
added 8 characters in body
Nov
29
revised Column name or number of supplied values does not match table definition error
deleted 9 characters in body; edited tags
Nov
28
revised Why is casting a string to DATETIME not accurate to the ms?
added 14 characters in body
Nov
28
comment SSRS using select from (Select)
I would recommend to be consistent with the spelling of your SQL keywords - either spell them all in lower case (select, from, where), or all of them in upper case (SELECT, FROM, WHERE, AS, ON), or even all in mixed case - but try to use one style only - right now, your spelling is a mess - all different variations exist....
Nov
28
revised SSRS using select from (Select)
added 214 characters in body; edited title
Nov
27
revised EXCEPT operator vs NOT IN
deleted 8 characters in body
Nov
27
revised Help with indexing narrow table with many millions of rows
added 25 characters in body
Nov
27
revised Columns count in SELECT query and SQL Server buffer cache
added 17 characters in body; edited title
Nov
25
comment how to define trigger scope variable
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 here?? SELECT DiscountPercent FROM Inserted - it's non-deterministic. You need to rewrite your trigger to take this into account!
Nov
25
revised Error after moving FTData folder
added 12 characters in body
Nov
25
comment Performance issue when we directly insert into #temp table
"If you have two horses and you want to know which of the two is the faster then race your horses." ericlippert.com/2012/12/17/performance-rant
Nov
25
revised Performance issue when we directly insert into #temp table
added 14 characters in body; edited title
Nov
25
comment SQL Server Management Studio: how to parse stored procedure code and check if table columns exist?
That is defined behavior, and it's by design. The "Parse" only check for syntactical errors. It does NOT check for object existence, and I'm not aware of any way or option to turn this on.
Nov
25
revised SQL Server Management Studio: how to parse stored procedure code and check if table columns exist?
added 2 characters in body; edited title
Nov
21
revised How can I check for stored procedure consistency across multiples servers
deleted 2 characters in body; edited title
Nov
21
revised How to update a column with values from the same newly inserted row on a SQL Server 2014 trigger?
edited tags
Nov
21
revised Duplicate Key Entry
added 2 characters in body
Nov
21
revised Multiple Instance with different service packs in SQL Server
deleted 15 characters in body; edited title