3,799 reputation
21735
bio website
location Bern, Switzerland
age 49
visits member for 3 years, 9 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
23
revised How long will it takes to rename table
added 6 characters in body; edited tags
Nov
22
comment Clustering vs. transactional replication vs. availability groups
Great stuff - thanks! So given the choice between failover clustering and AG - which do you choose when? Clustering seems to be more mature (been around longer), but AG seems to offer more flexibility (in that the "secondary" can be used for e.g. reporting etc.). So when and why would you still use failover clustering then?
Nov
22
comment Clustering vs. transactional replication vs. availability groups
+1 another great answer - thanks! The clouds are beginning to clear up!
Nov
22
revised Error 18456 error severity 14 state 5 SQL Server 2012 SCCM2012 SP1
added 10 characters in body; edited title
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 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