298 reputation
212
bio website freetibet.org
location Varna, Bulgaria
age 25
visits member for 2 years, 9 months
seen 17 hours ago

Free Tibet From China Domination

http://freetibet.org/about/10-facts-about-tibet

enter image description here


1d
asked List with all visible meta data in AFTER UPDATE trigger
Oct
17
comment Search NVARCHAR(MAX) string in other string
Thanks, good to know this.
Oct
17
comment Search NVARCHAR(MAX) string in other string
Sounds like a good time for me to learn something new (PowerShell as you said or C# to write CLR procedure) - I hate when I don't have the knowledge to do something.
Oct
17
comment Search NVARCHAR(MAX) string in other string
Let us continue this discussion in chat.
Oct
17
comment Search NVARCHAR(MAX) string in other string
I have a table with column that holds HTML content. I am not able to do the replace by hand as there are many records, and I am not able to write the whole value as the content is different.
Oct
17
comment Search NVARCHAR(MAX) string in other string
I have added a sample code. Just not been able to add the real base64 string as it is very large, but basically this is the idea.
Oct
17
revised Search NVARCHAR(MAX) string in other string
added 824 characters in body
Oct
17
comment Search NVARCHAR(MAX) string in other string
Try this in your code: UPDATE @foo SET x = REPLACE(x, REPLICATE(CONVERT(NVARCHAR(MAX), N'x'),80001) , N'flarb');
Oct
17
asked Search NVARCHAR(MAX) string in other string
Oct
15
asked Dividing data from one table to multiple storage
Oct
15
comment .WRITE clause performance optimization
Thanks. I have also checked your code on FULL recovery model database and there is indeed less logging when .WRITE is used. I guess the link above is wrong.
Oct
15
accepted .WRITE clause performance optimization
Oct
14
comment .WRITE clause performance optimization
Could you tell how you are detecting Transaction Log Generated ?
Oct
11
comment .WRITE clause performance optimization
Thanks that's interesting. Also, you can point that If the statement inserts or appends new data, the operation is minimally-logged if the database recovery model is simple or bulk-logged and Updates to existing data are not minimally-logged - so I guess in FULL recovery model the logging is not a factor (beyondrelational.com/modules/2/blogs/77/Posts/17835/…)
Oct
10
comment .WRITE clause performance optimization
@MaxVernon Could you give official source confirming this? This clause seems to be very powerful, I cannot understand why there is no more information about it.
Oct
10
comment .WRITE clause performance optimization
@MikaelEriksson Thanks for the suggestions - very interesting - I am not observing any lob read-ahead reads at all.
Oct
10
revised .WRITE clause performance optimization
deleted 31 characters in body
Oct
10
asked .WRITE clause performance optimization
Oct
9
asked [sys].[dm_db_index_usage_stats] returns more entries in some databases
Oct
8
comment MERGE a subset of the target table
+1 for limiting the target rows using CTE.