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.


Dec
7
revised Replication stopped working, no errors
added 5 characters in body
Dec
7
revised SQL Server 2012 Replication, how to ignore action with specific trigger?
added 7 characters in body; edited title
Dec
5
revised Query on a SQL Server view with openquery to Hive returning wrong answer
added 66 characters in body; edited title
Dec
5
revised SQL Server : how to create user with access only from specific HOSTNAME or IP addres
added 5 characters in body; edited title
Dec
5
revised How to import DB with .sql extension into SQL Server 2012?
added 26 characters in body; edited title
Dec
5
revised SQL Server 2012 Standard Edition using more than 64GB of memory, why and how?
It's "Standard" - not "Standart"
Dec
5
revised How to get data from multiple tables in one row
added 75 characters in body
Dec
5
revised T-SQL View — How to 'pre-fetch' schema using scalar function, then populate using table query
added 73 characters in body; edited tags
Dec
4
awarded  Popular Question
Dec
2
revised Application running slow when querying against SQL Server 2008R2
added 29 characters in body; edited tags
Dec
2
comment Why could a SQL Server table grow far quicker than the data to it?
Since it appears to be mainly LOB_DATA - could it be that the newly added rows have significantly larger entries into the AuditData column? Since it's a nvarchar(max), it could theoretically hold up to 2 GB for each row.
Dec
2
revised Controlled shutdown/startup of a cluster
added 30 characters in body
Dec
2
revised Default value for SQL Server CE 4.0 column
added 26 characters in body; edited title
Dec
2
revised Best practise how to sync SQL Server 2014 database with other database
Product is officially called "SQL Server" - and neither MS-SQL, nor MSSQL, nor MS SQL or anything like that ....
Dec
1
revised Create nonclustered index on uniqueidentifier type
added 115 characters in body
Nov
30
revised I couldn't see Conflict tables in replication monitor SQL Server 2008 R2 in Merge Replication
added 7 characters in body; edited title
Nov
29
comment Column name or number of supplied values does not match table definition error
@codeOholic: no - you just need to insert valid values for those two foreign keys....
Nov
29
revised Dump all binary columns from a table as files
added 2 characters in body; edited title
Nov
29
revised Transaction Log won't shrink, DB thinks it is replicating
added 51 characters in body
Nov
29
comment If a database is in memory does it still need indexing?
OF COURSE! even if it's in memory, if you have to scan tens of thousands of pages for a full table scan, that's vastly less efficient than being able to walk through an index tree on a handful of pages..... also: it's much more likely that the tens of index pages are kept in memory, rather than ALL of thousands or tens of thousands of actual data pages