446 reputation
410
bio website foxtricks.com
location Belgium
age 38
visits member for 2 years, 8 months
seen May 26 at 9:12

All round developer leading a development team for a Software company building a Backoffice solution for Banks for Risk, Accounting and MIS.

I'm mainly interested in SqlServer performance tuning, Developing C# Server side software and general Software Development best practices. (And a bit of Finance on the side)

In my free time I like to play around with Ruby.

https://github.com/FilipDeVos

http://foxtricks.com


Nov
30
awarded  Yearling
May
14
awarded  Caucus
Apr
5
comment Insert performance progressively deteriorating for indexless table
@MarkStorey-Smith I will write a proper answer based on my comments somewhere today.
Apr
4
comment Insert performance progressively deteriorating for indexless table
The database growth settings are terrible out of the box. It creates fragmented database files and when you have a big database the filegrowth phases are going to take forever. The best is to set the growth to fixed chunks (and enable instant initialisation). In really big databases it is best to manage files and filesizes manually (where you schedule the jobs to grow the files on moments where there is no or low activity on the server).
Apr
4
comment Insert performance progressively deteriorating for indexless table
Isn't your database file growth set to "10%" or something (without having instant initialisation enabled msdn.microsoft.com/en-us/library/ms175935(v=sql.105).aspx)?
Dec
5
awarded  Good Answer
Nov
30
awarded  Yearling
Jul
5
awarded  Scholar
Jul
5
accepted What could trigger that a login created from a certificate is not visible in metadata
Jul
3
revised What could trigger that a login created from a certificate is not visible in metadata
added 146 characters in body
Jul
2
comment What could trigger that a login created from a certificate is not visible in metadata
I can only do that in another 2 days.
Jul
2
revised What could trigger that a login created from a certificate is not visible in metadata
deleted 91 characters in body
Jul
2
awarded  Commentator
Jul
2
comment What could trigger that a login created from a certificate is not visible in metadata
Problem solved (See the answer I posed), but could have been avoided if the error was a bit clearer.
Jul
2
answered What could trigger that a login created from a certificate is not visible in metadata
Jul
2
comment What could trigger that a login created from a certificate is not visible in metadata
I will post a complete repro script from C# project to this deployment. It seems there is a relation with the certificate since it will give "Login exists" even when the create login has never been executed.
Jul
2
revised What could trigger that a login created from a certificate is not visible in metadata
added sysadmin member list
Jul
2
awarded  Student
Jul
2
revised What could trigger that a login created from a certificate is not visible in metadata
added missing certificate code
Jul
2
awarded  Editor