meta user
network profile
| bio | website | adsi.mvps.org |
|---|---|---|
| location | Bern, Switzerland | |
| age | 47 | |
| visits | member for | 2 years, 3 months |
| seen | 5 hours ago | |
| stats | profile views | 207 |
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.
catch me at mscheuner -at- gmail -dot- com if you need to :-)
|
Apr 6 |
revised |
Login failed for user sa ssis 2008 added 34 characters in body; edited title |
|
Apr 5 |
revised |
Invalid Object SQL Server 2005 Express added 19 characters in body; edited title |
|
Apr 4 |
revised |
What will happen if i change the compatibility level of Distribution Database added 21 characters in body |
|
Apr 4 |
revised |
SQL Server 2008 DB Performance on single disk deleted 24 characters in body |
|
Apr 4 |
revised |
Find all the SP's where a particular column is not updated added 26 characters in body; edited title |
|
Apr 4 |
revised |
SQL Server 2008 Group by 30 minute Time Intervals deleted 1 characters in body; edited title |
|
Apr 3 |
revised |
Restoring multiple differential backups SQL Server 2008 deleted 1 characters in body; edited title |
|
Apr 1 |
revised |
Recreate Indexes on 1 billion record table deleted 38 characters in body |
|
Apr 1 |
revised |
SQL Server 2000 Trace Template for SQL Server 2008 R2 Upgrade Advisor added 42 characters in body; edited title |
|
Mar 29 |
revised |
SQL Server 2005 Unexpected Disk Usage during Backups Product is officially called "SQL Server" - neither MSSQL, nor MS SQL, nor MS-SQL or anything like that.... |
|
Mar 27 |
revised |
ISO Week vs SQL Server Week edited body; edited title |
|
Mar 26 |
revised |
SQL Server TDE Stuck at Encryption_State 2 and 0% on a Tiny DB added 19 characters in body; edited title |
|
Mar 26 |
revised |
SQL Server Express on Windows 8 isn't locking MDF database files added 8 characters in body; edited title |
|
Mar 25 |
answered | Back up my ASPNETDB |
|
Mar 25 |
revised |
Back up my ASPNETDB deleted 2 characters in body |
|
Mar 25 |
comment |
Can SQL Server 2000 and SQL Server 2012 CoExist? The OP didn't ask about migration, but about side-by-side co-existance ... |
|
Mar 25 |
comment |
why would command text not execute at all? Just wanted to be sure - sometimes it's the most basic, most silly things that stop us :-) |
|
Mar 23 |
revised |
SQL Server replication conflicts after migration from 2000 to 2008 added 48 characters in body; edited title |
|
Mar 22 |
comment |
Primary Key efficiency @Craig: well, there are two schools of thought - and they're often very religious about their conviction - so if your project was created by someone who insists on never using a "surrogate" key - then that would be the reason. From a practical every-day programmer point of view, I think using a 5-column natural key is just clunky, unnecessarily complicated and annoying.... |
|
Mar 22 |
comment |
Primary Key efficiency Just ask yourself this: if a child table needs to reference this table here - is it easier to have a join condition on a single identity column, or always have to join on five columns that make up your primary key? |
