leancz

Frankfurt Am Main, Germany

Age: 49

Jun
26
awarded Teacher
Jun
26
answered How can I write a query to aggregate multiple strings into one field?
May
26
awarded Informed
May
6
answered How to minimize log operations in SQL Server to avoid "log full" error
Apr
20
awarded Caucus
Mar
13
awarded Yearling
Mar
13
awarded Yearling
Mar
9
answered JSON read from sparkcore to python
Mar
2
awarded Notable Question
Feb
13
comment SQL Job used as JobScheduler
Any reason why you don't create one job with a number of job steps?
Jan
2
answered SQL First capital letter - Function bad performance
Nov
5
awarded Student
Oct
29
revised powershell failing to import module
Added extra detail to this answer to clarify why and to offer a couple more solutions applying to the same underlying cause.
Oct
16
answered How can I configure a default server connection in SSMS for when I open any .sql script file?
Oct
6
reviewed Needs Improvement Is the golden rule considered childish in philosophy?
Oct
6
reviewed Needs Improvement What a "Bismarckian realist"
Oct
6
awarded Custodian
Oct
6
reviewed Satisfactory Who owns the means of production?
Aug
7
comment SQL Server : trigger to retrieve duplicates and stop them from being entered whilst inserting new values
If you try to insert with a duplicate key you should get an error: Msg 2601, Level 14, State 1, Line 1 Cannot insert duplicate key row in object 'dbo.Bob' with unique index 'IX_Bob'. The duplicate key value is (1). Check for this exception/error in your code.
Jul
25
awarded Commentator
1 2 3 4 5