3,609 reputation
21733
bio website
location Bern, Switzerland
age 48
visits member for 3 years, 6 months
seen 19 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.


Jun
25
revised Error while Installing SQL Server 2012
deleted 13 characters in body; edited title
Jun
25
revised Complete Failover Cluster Failure SQL Server 2012
added 30 characters in body; edited title
Jun
25
revised Flush procedure cache or drop and create?
added 6 characters in body
Jun
24
revised Insert Into does not work with multiple rows
edited tags
Jun
24
revised Changing Databases Dynamically using Variables
edited body; edited title
Jun
23
revised how to solve slow running sub query TSQL
added 2 characters in body
Jun
23
revised Execute a Stored Procedure Daily
added 13 characters in body
Jun
21
revised Is there a negative effect if I place an index on every column in a wide table?
added 4 characters in body; edited tags
Jun
21
revised Best scenario for replication type
added 25 characters in body
Jun
21
revised how to solve slow running sub query TSQL
edited body; edited tags
Jun
20
comment Efficient query for an advanced EAV model
@AaronBertrand: thanks for your post - but I'm still not at all convinced... the messy (and often hopelessly ineffective) queries, the inability to store data in its native format / datatype (everything has to be "squeezed" into a string format) ...... too many drawbacks for my taste!
Jun
20
revised Inhibit SQL Server trigger execution
added 6 characters in body; edited title
Jun
20
revised Identity column as clustured index bad idea?
deleted 6 characters in body
Jun
20
comment Identity column as clustured index bad idea?
Read Kimberly Tripp's blog posts on clustered index - she's the Queen of Indexing in the SQL Server world, and her basic recommendation is always to use INT IDENTITY as the primary (and clustered) key on almost any table. It's a well recommend best practice and usually works just fine. Cases where this is not a good idea are relatively rare in my opinion.
Jun
20
comment Problem creating database using default mdf and ldf path
Instead of SET @logpath = (select ..., I'd recommend to just use SELECT @logpath = ....
Jun
20
revised Problem creating database using default mdf and ldf path
added 156 characters in body
Jun
20
comment Efficient query for an advanced EAV model
See Five Simple Database Design Errors You Should Avoid (point #3) for a discussion of why EAV is really really bad, and see Bad CaRMa for a true horror story of an EAV system design that ruined a thriving company. In brief: don't use EAV - and don't expect a good solution for dealing with an EAV...
Jun
19
revised How to audit users connections via ODBC to all dbs in SQL Server 2008 R2
added 25 characters in body; edited title
Jun
18
revised How to deploy a build from Visual Studio online to local SQL Server?
deleted 10 characters in body; edited title
Jun
18
revised How can I tell how many Cores SQL Server is actually using?
added 55 characters in body