3,849 reputation
21736
bio website
location Bern, Switzerland
age 49
visits member for 3 years, 10 months
seen 18 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
18
revised Select only rows with minimum values from union table
added 23 characters in body; edited tags
Nov
18
comment SQL Server is very slow
You have to provide a lot more information so anyone can help you! What does the database look like - tables and their columns, what queries do you run against those tables, how many rows are in those tables, what indexes are in place, what are the hardware parameters of the physical server box, what other activity is on that server? .....
Nov
18
comment Protect SQL Server Express data file
No, this is not dbase or Access - you cannot protect a SQL Server data file by a password or anything. If it's out there in the open, and someone with admin permissions on a SQL Server decides to attach it and peek inside it - there's no way to stop him from doing that.
Nov
17
comment Upgrading SQL Server 2008 R2 Standard edition to SQL Server 2008 R2 Enterprise edition what is the process and the impact?
There's absolutely no impact at all. The only thing that changes is that some additional features in SQL Server become available, so your performance might get better in certain areas, or you have more options to performance tune your queries.
Nov
17
revised Secondary File Group is not online in SQL Server
added 37 characters in body
Nov
17
comment SQL Performance: COUNT or extra attribute?
That highly depends on what concrete database you're talking about, and on what the table structure and available indexes look like....
Nov
16
revised Table design for optimum performance
added 9 characters in body
Nov
16
revised Why does SQL authentication sometimes fail and how can I make it work reliably?
added 18 characters in body
Nov
16
revised Dynamic Creation of Table using Stored Procedure Without a Use of OpenRowSet in SQL Server
added 153 characters in body
Nov
16
revised Find out who ran a query using transaction log backups
added 7 characters in body
Nov
16
revised Mysql pagination without offset
edited tags
Nov
16
revised TSQL substitute for MAX() string ranking
edited tags
Nov
14
revised Restoring master database
added 2 characters in body
Nov
14
revised TSQL substitute for MAX() string ranking
added 57 characters in body
Nov
13
revised Linked Server from SQL Server to SSAS not working - what is missing?
deleted 20 characters in body; edited title
Nov
13
revised SQL Server : error 15208 Level 16, State 1, Line 1
deleted 7 characters in body; edited title
Nov
13
revised Get a specific row from a TSQL common table expression
added 70 characters in body
Nov
13
revised Determining which SQL Server tables are accessed over a week?
added 5 characters in body; edited title
Nov
9
revised Why is cost threshold for parallelism ignored?
added 13 characters in body
Nov
9
revised Error in attaching mdf file from a crashed server to a new server
deleted 527 characters in body