3,709 reputation
21734
bio website
location Bern, Switzerland
age 49
visits member for 3 years, 8 months
seen 29 mins 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.


Sep
13
revised Why would a query in code be slower than a query in a SQL tool
edited tags
Sep
13
revised How to do Partition for MySQL 100GB table in zero downtime?
edited tags
Sep
13
comment Location of the mdf file of the database
But be aware: if your database is used by SQL Server, you cannot just copy away the .mdf and .ldf file. You should use a proper procedure, like backup & restore (or alternatively: detach & re-attach) to handle this!
Sep
7
revised SQL Server backup job last 5 days
Product is officially called "SQL Server" - neither MSSQL, nor MS SQL, nor MS-SQL or anything like that....
Sep
6
revised ROWNUM equivalent in Centura SQLBase (aka Gupta)
edited tags
Sep
6
revised SQL Server 2012 SQL Log “the log file is not using Unicode format”:
added 7 characters in body; edited tags; edited title
Sep
5
revised Intellisense in SSMS 2012 not working for 2008 server
deleted 9 characters in body; edited title
Sep
4
revised Best way to migrate a database involved in bidirectional replication
added 9 characters in body; edited tags
Sep
2
comment Data center from scratch which way to go
Your "IT guy with plenty of certificates" should go take a hike.... seriously.... SQL Server 2012 already has a first Service Pack out, and it's rock-solid! Those comments are totally unfounded, and don't be impressed by "many certificates" - those can be achieved without knowing much about a topic, really...
Sep
2
revised Data center from scratch which way to go
added 27 characters in body; edited title
Aug
30
revised SQL Server select with regex
Product is called **SQL Server** - not "MSSQL" or "MS SQL" or "MS-SQL" or anything like that
Aug
29
revised SQL Server 2008 R2 : A Possible indexing strategy for the given schema?
added 2 characters in body
Aug
29
revised SQL Server 2008 R2 : A Possible indexing strategy for the given schema?
added 20 characters in body; edited title
Aug
28
answered Constant values in columns
Aug
28
comment Constant values in columns
@a_horse_with_no_name: a computed column is not stored - it's computed every time you access it - unless you specify PERSISTED, then it's persisted like a normal column (and thus doesn't save any space)
Aug
28
comment Constant values in columns
If you use a normal computed column - then yes, you might save a bit on disk space - BUT always constantly re-computing those values will most likely cost you more in terms of processing time than you save by loading less data
Aug
28
revised Constant values in columns
deleted 1 characters in body
Aug
28
revised How to setup SSL in SQL Server 2012 with own certificate?
deleted 1 characters in body; edited tags; edited title
Aug
27
revised Freeing space after deleting rows
deleted 1 characters in body
Aug
27
revised How to call Oracle's stored procedure from DB2 stored procedure?
It's a **STORED** procedure - as in **STORED** inside your database server - has nothing to do with a "store" .....