3,509 reputation
21529
bio website
location Bern, Switzerland
age 48
visits member for 3 years, 2 months
seen 22 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.


2d
revised SQL Server Permission
edited body; edited title
2d
comment New SQL Server 2008 instance, load old instance DB's
MDB is MS Access - not SQL Server. SQL Server data files are .mdf (and .ndf), transaction log files are .ldf
2d
revised New SQL Server 2008 instance, load old instance DB's
added 22 characters in body; edited title
Apr
14
revised TSQL change column constraint between null and not null
added 54 characters in body
Apr
14
revised Full text index search returns an unexpected result
deleted 7 characters in body; edited tags; edited title
Apr
13
revised SQL Server 2012 Tuning process exited unexpectedly. DTAEngine
Product is officially called "SQL Server" - and neither MS-SQL, nor MSSQL, nor MS SQL or anything like that ....
Apr
13
revised RETURNING syntax with multiple columns
added 15 characters in body
Apr
13
revised Getting Visual Studio to deploy a UDF to Return NVARCHAR(MAX)
added 5 characters in body
Apr
8
revised SQL Server: CONVERT From ISO8601 To DateTime Within Query
added 14 characters in body
Apr
8
revised Can SQL Server Bulk Copy cause timeouts when querying the table
deleted 4 characters in body; edited title
Apr
8
revised SQL Server: CONVERT From ISO8601 To DateTime Within Query
added 209 characters in body; edited title
Apr
8
reviewed Approve suggested edit on SQL Server 2008 R2 - Limit viewing on database list
Apr
8
revised SQL Server 2008 R2 - Limit viewing on database list
added 1 characters in body; edited tags
Apr
7
comment How control 27 locations and 27 databases?
You might need a third-party tool like Spotlight on SQL Server to handle such a job
Apr
7
comment How control 27 locations and 27 databases?
There is no SQL Server 2012 R2 - there are versions 2008 R2, or then 2012, and now just recently 2014 was released ....
Apr
7
revised How control 27 locations and 27 databases?
deleted 8 characters in body; edited title
Apr
5
comment Which should I use on my DB? - Clustered Index or Non Clustered Index or Both
To be very clear: the primary key in SQL Server DOES NOT determine the physical ordering of the table! It's the clustering key which does that. By default, the primary key is also the clustering key - but it doesn't have to be. The primary key is "just" a logical construct to uniquely and reliably identify every single row in your table.
Apr
3
comment Database Normalization: A Case Of The NULLs
Another option could be to make the column non-nullable, and define a "magic" value that sort of "takes over" the meaning of NULL - like -1 for an INT column. It's sometimes frowned upon - but it makes your queries a lot easier if you can rely on an INT value to always be there for sure.
Apr
3
comment SQL Performance issue after migration from SQL Server 2005 to SQL Server 2012
Shrinking the database can totally screw up your indexes and can massive fragmentation. If you insist on keeping that step, do this before you reorganize & rebuild your indexes, so that those indexes can be defragmented after shrinking the database. Or leave out that step altogether.
Apr
3
revised SQL Performance issue after migration from SQL Server 2005 to SQL Server 2012
added 9 characters in body