324 reputation
215
bio website
location Netherlands
age
visits member for 1 year, 5 months
seen 5 hours ago
stats profile views 38

Enthusiast programmer!


1d
awarded  Constituent
May
14
awarded  Popular Question
May
13
awarded  Caucus
Apr
25
awarded  Popular Question
Dec
16
awarded  Yearling
Dec
12
comment grant permission
Are you trying to grant permissions on myTable as user dummyRole? Not enough information in the question as it is now to help you further...
Dec
12
revised Solve conflict between affinity mask and I/O affinity mask?
updated the question with the way I solved the problem in the end
Dec
11
accepted Solve conflict between affinity mask and I/O affinity mask?
Dec
11
comment Solve conflict between affinity mask and I/O affinity mask?
Great answer, thanks a lot for your explanation! I will read up on this. It's not an option I configured myself, I just encountered it on one of our machines and wanted to know what's behind it.
Dec
11
revised Solve conflict between affinity mask and I/O affinity mask?
slight edits
Dec
11
revised Solve conflict between affinity mask and I/O affinity mask?
added tag
Dec
11
asked Solve conflict between affinity mask and I/O affinity mask?
Oct
5
awarded  Excavator
Oct
5
revised Why is it a bad practice to allow everyone to use the sa login?
fixed broken link
Oct
5
suggested suggested edit on Why is it a bad practice to allow everyone to use the sa login?
Oct
5
comment Still wrong to start the name of a user stored procedure with sp_?
Interesting finds, thanks! I'll use your example in combination with Aaron's example to run some more tests.
Oct
5
accepted Still wrong to start the name of a user stored procedure with sp_?
Oct
5
comment Still wrong to start the name of a user stored procedure with sp_?
Thanks for your answer, very useful addition on the prevalence of master sp's.
Oct
5
comment Still wrong to start the name of a user stored procedure with sp_?
Great example, thanks Aaron. I'm still testing it on 2008 R2 (and probably testing it the wrong way, cause 'dbo.wrapper_sp1' and 'dbo.wrapper_sp2' seem significantly faster than the other two right now).
Oct
4
revised Still wrong to start the name of a user stored procedure with sp_?
made edit (and questions) more clear