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


Nov
22
comment Clustering vs. transactional replication vs. availability groups
Thanks for a great answer, Thomas! So if I understand correctly, FCI would automatically switch over to a "hot standby" server if the main machine goes down - right? What about AlwaysOn? Does that offer some kind of automatic "failover", too, or is it just a secondary copy of the database, but some admin needs to manually switch over, in case of a failure?
Nov
22
asked Clustering vs. transactional replication vs. availability groups
Nov
22
revised Can Availability Groups replace transactional replication?
added 22 characters in body
Nov
22
revised SQL Server: Can Page Verify be set to Checksum on any database, or must I check compatibility?
Product is officially called **SQL Server** - and neither MS SQL, nor MS-SQL, nor MSSQL or anything like that...
Nov
20
revised SQL Server log file continues to grow?
edited title
Nov
19
revised Self Referencing Table, Child and Master, Update Cascade Through Stored Procedure in SQL Server
Product is officially called **SQL Server** (and not MS SQL, MSSQL MS-SQL or anything like that....)
Nov
19
revised SQL Server 2012. Update second table based on input from first table
added 17 characters in body; edited title
Nov
15
revised Does “use AWE to allocate memory” do anything on a SQL Server 2008 R2 64bit Windows 2003 system?
added 2 characters in body; edited title
Nov
13
revised MySQL (InnoDB) UPDATE SET performance with value in WHERE AND clause
edited tags
Nov
12
revised Unexpected EOF during bulk insert
added 1 characters in body; edited title
Nov
12
revised Extracting text from a column
added 18 characters in body; edited tags; edited title
Nov
12
revised Can SQL Server WebAdmin degrade the performance of my site?
edited title
Nov
10
revised Cannot grant execute to stored procedure
added 25 characters in body
Nov
10
revised Mount mdf file to sql server desktop edition
added 53 characters in body
Nov
10
comment How to extract the last inserted row in SQL Server?
You can output what is being inserted in a INSERT statement using the OUTPUT clause - but after that, once the row has been inserted, then you'll need to either have a date/time column that you keep track of when a row was inserted, or you need an ever-increasing IDENTITY column that allows you to get the last inserted row
Nov
10
comment Why is SQL Server 2012 Recommending This Index Be Created?
Just for kicks: have you tried actually creating the index and see if SQL Server would really use it in your execution plan? Database Tuning Advisor is known to have weaknesses in that sometimes it suggest already existing indices, or an index (like in your case) which is really already present in slightly modified form.
Nov
8
revised Metric to standard unit conversion in SQL Server
deleted 102 characters in body; edited title
Nov
8
comment Metric to standard unit conversion in SQL Server
I always thought that metric was the international standard (and the US and British (Imperial) units are the oddballs....)
Nov
8
revised Central Management Server - can it manage itself?
edited body; edited title
Nov
8
revised Creating a partition on my soft-delete indicator column
Product is officially called **SQL Server** - and neither MS SQL, nor MS-SQL, nor MSSQL or anything like that...