511 reputation
1210
bio website devworx.de
location Augsburg, Germany
age 47
visits member for 6 months
seen 31 mins ago
stats profile views 19

Softwaredeveloper and shareholder of www.devworx.de.

Main interests component development (Delphi), SQL.

Hobbys: sports shooter, diver


Dec
29
answered Max connections SQL Server Express could have?
Dec
29
comment Max connections SQL Server Express could have?
Last edition with limitation in concurrent users was Server 2000 msdn.microsoft.com/en-us/library/ms165672%28SQL.90%29.aspx
Dec
28
comment How much do foreign keys affect performance?
stackoverflow.com/questions/507179/…
Dec
27
answered How to login in database if we have lost password?
Dec
25
awarded  Commentator
Dec
25
comment Pivot a table to repeat the first column for each following column
You can find examples here ewbi.blogs.com/develops/2005/01/access_sql_tran.html msdn.microsoft.com/en-us/library/office/… but if I got you right you are searching for the opposite.
Dec
25
answered Pivot a table to repeat the first column for each following column
Dec
24
comment Sql server update query locking stages?
@ThomasStringer why didn't you post this as answer?
Dec
24
answered New login is created but 'sa' cant assign grant/deny permissions to user in SQL Server 2008 R2?
Dec
21
comment Monitor Sql Server 2000
this might be useful: zabbix.com/screenshots.php
Dec
18
answered How many fields is too much for a primary key?
Dec
17
awarded  Enthusiast
Dec
16
answered Copy data between two databases periodically
Dec
7
answered case versus isnull versus coalesce
Nov
26
comment Bitwise operations in TSQL
AFAIK no, sorry
Nov
26
awarded  Teacher
Nov
26
comment Bitwise operations in TSQL
anything is stored binary, just a arrangement (perhaps bad translation) what's the meaning of the data, perhaps you are looking for a funtion for displaying data in binary format as varchar?
Nov
26
comment Bitwise operations in TSQL
it's no matter of cast , it's bitwise operation 0x64 or 0x01 = 0x65 = dezimal 101
Nov
26
answered Bitwise operations in TSQL
Nov
23
revised What is the fastest way to export a table to a text file
added 57 characters in body