4,039 reputation
21938
bio website
location Bern, Switzerland
age 49
visits member for 4 years, 1 month
seen 22 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.


May
20
comment SQL SERVER 2008 Cursor Problem
the best way to tune a cursor is to get rid of it :-) That keeps coming back as a recurring insight over and over again! :-) Great to hear you got your performance to a useful level!
May
20
revised Sync two MySQL databases in two different locations
edited tags
May
20
comment SQL SERVER 2008 Cursor Problem
WHY OH WHY a cursor for something as simple as this?? Use a CTE and a proper, set-based approach to AVOID cursors altogether!
May
20
revised Identity in a view treated as ordinary int - migrating from SQL Server 2000 to 2012
added 15 characters in body; edited title
May
18
revised Performance hit of CONVERT from nvarchar to money (SQL Server)
added 4 characters in body
May
18
revised Delete image/blob content to reduce *.mdf file size?
added 11 characters in body
May
16
revised Update+Select in one SQL Server transaction, and concurrent deadlocks
added 27 characters in body; edited title
May
13
revised Error updating zoned field from SQL Server stored procedure linked server to iSeries
Product is officially called **SQL Server** - and neither MS SQL, nor MS-SQL, nor MSSQL or anything like that...
May
12
revised Using OPENQUERY to execute a script
added 2 characters in body; edited title
May
11
revised New database server hardware and software inserts slower than old setup
Product is officially called "SQL Server" - and neither MS-SQL, nor MSSQL, nor MS SQL or anything like that ....
May
9
comment Trigger to update a date field on one table when another table is updated
Please do not put code samples or sample data into comments - since you cannot format it, it's extremely hard to read it.... Instead: update your question by editing it to provide that additional information! Thank you.
May
7
revised Keyword Search a single SQL Server table for multiple search terms and create a new table from results?
Product is officially called "SQL Server" - and neither MS-SQL, nor MSSQL, nor MS SQL or anything like that ....
May
7
revised How to create a versioning DDL/DML change script for SQL Server?
Product is officially called **SQL Server** - and neither MS SQL, nor MS-SQL, nor MSSQL or anything like that...
May
7
revised Any advantage of having a second index with included columns on a primary key?
added 3 characters in body
May
7
revised Backup name in Maintenance plan
added 22 characters in body
May
7
revised Restore a backup from SQL Server 2008 R2 to SQL Server 2014
added 24 characters in body; edited title
May
6
revised Sync postgreSQL with SQL Server database- on data change event
Product is officially called "SQL Server" - and neither MS-SQL, nor MSSQL, nor MS SQL or anything like that ....
May
6
comment Designing a database with Ints
YES! Physical database design does matter - even today in 2014!! Check out Kim Tripp's interview on .NET Rocks - and if you have a Pluralsight video subscription, check out her Pluralsight course on "Why physical database design matters" - you won't ever ask such a question again after that!!
May
5
revised How to copy a subset of SQL objects across databases within a transaction?
added 6 characters in body; edited tags; edited title
May
1
revised Convert this Ruby function into MySQL Function?
edited tags