3,864 reputation
21736
bio website
location Bern, Switzerland
age 49
visits member for 3 years, 10 months
seen 10 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
comment Will a non-clustered index on a column with covering index on all the columns of table affect the Delete statement Records)?
Generally, SQL Server will use row-level locks to lock those rows that are being manipulated (and that includes rows being deleted). However, if you manipulate more than 5000 rows in a single transaction, then SQL Server will do a lock escalation and lock the entire table that's being deleted from exclusively - no other operations (not even SELECT) are possible anymore. So you might want to break up your delete operation into chunks of less than 5000 rows each
2d
revised Will a non-clustered index on a column with covering index on all the columns of table affect the Delete statement Records)?
deleted 6 characters in body
2d
revised SQL Server : scheduled JOB issue
deleted 3 characters in body; edited tags; edited title
2d
revised SQL Server 2008 create database problem
added 12 characters in body; edited title
Dec
21
revised How to fix error Msg 1801, Level 16, State 3, Line 3
added 7 characters in body; edited tags
Dec
20
revised Equivalent data types in Oracle database for SQL Server 2008’s uniqueidentifier and timestamp
added 4 characters in body; edited title
Dec
20
revised Please help me in resolving the error: The definition of object 'trigger name' has changed since it was compiled
added 3 characters in body
Dec
20
revised Turning multiple fields in column to row
added 88 characters in body
Dec
19
revised Microsoft recommends using Rowversion over timestamp , but i can not find “rowversion” data type inside my sql server 2008 R2
added 16 characters in body
Dec
19
comment How to identify unused databases on my sql server
If in doubt, just take the database offline, and if no one complains about it for a week - nobody is using it ....
Dec
19
revised SQL Native backup MIRROR TO performance
added 21 characters in body
Dec
19
revised My database engine cannot see one of the drives
edited tags
Dec
18
comment Microsoft recommends using Rowversion over timestamp , but i can not find “rowversion” data type inside my sql server 2008 R2
You should AVOID using reserved keywords (like TIMESTAMP) as column names - use something more meaningful! Then it'll work.
Dec
18
revised SQL Server CE 4.0 network share access
added 12 characters in body; edited title
Dec
17
revised I do not understand SQL Server Transaction Logs
edited body; edited title
Dec
17
revised SQL Server 2008 R2: After Insert Trigger and Query returning unexpected results for a split second
deleted 12 characters in body; edited title
Dec
17
revised Installing SQL Server 2012 - Wait on the Database Engine recovery handle failed
deleted 43 characters in body; edited title
Dec
17
revised Suspect (Torn) Pages recorded in TEMPDB? (SQL Server 2005 SP3)
added 16 characters in body; edited title
Dec
15
revised What SQL Server database version do I need?
added 4 characters in body; edited title
Dec
15
revised What are the alternates to replication?
added 4 characters in body; edited title