3,799 reputation
21735
bio website
location Bern, Switzerland
age 49
visits member for 3 years, 9 months
seen 12 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.


12h
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!
12h
revised Error after moving FTData folder
added 12 characters in body
12h
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
12h
revised Performance issue when we directly insert into #temp table
added 14 characters in body; edited title
12h
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.
12h
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
Nov
21
revised SQL Server Express: difference between connecting to localhost and localhost\sqlexpress
edited body; edited title
Nov
21
comment Where's my missing Sql Server Express 2005 Database space? Size and space available dont add up to SQL express size 4G?
Upgrade to SQL Server 2008 R2 Express (or even newer) - the limit has been upped to 10 GB
Nov
21
revised Where's my missing Sql Server Express 2005 Database space? Size and space available dont add up to SQL express size 4G?
added 29 characters in body
Nov
20
revised How to restrict access to current user record and its rights in postgres
added 16 characters in body; edited title
Nov
18
revised Skewed Clustered Index
added 6 characters in body
Nov
18
revised Use of MAX data types when over >8000 characters. (error exceeds the maximum allowed for any data type (8000)
edited body
Nov
18
revised This instance of (MS) SQL Server has been using a process id of X since dd/mm/yyyy
deleted 8 characters in body
Nov
18
revised Join select queries on an id in SQL Server
added 89 characters in body; edited title
Nov
18
revised Oracle 11g SSIS SQL Server 2014 Truncation
added 13 characters in body; edited title
Nov
18
revised Any caveats using SQL Server 2008 CDC off replicated tables?
deleted 14 characters in body; edited tags; edited title