| bio | website | tckspress.blogspot.com |
|---|---|---|
| location | Prague, Czech Republic | |
| age | ||
| visits | member for | 11 months |
| seen | Dec 22 '12 at 13:01 | |
| stats | profile views | 0 |
|
Jun 21 |
awarded | Scholar |
|
Jun 21 |
awarded | Editor |
|
Jun 21 |
accepted | Self blocking session |
|
Jun 21 |
revised |
Self blocking session added solution |
|
Jun 20 |
awarded | Supporter |
|
Jun 19 |
comment |
Self blocking session Thanks for moving the question. This is propable much better site to ask. I changed the the TVP to the varbinary(max) and created clr function which accept varbinary(max) and returns the guids in table form. Its faster than spliting text. Now its in production I must wait some time for collecting results. I have not good experience with subselects because of performance. Joins made us much better performance. However, if change from TVP to varbinary(max) will not help, I'll try you solution. Thank's a lot for your concern. Your advices are best I found on the net. |
|
Jun 18 |
asked | Self blocking session |