312 reputation
214
bio website freetibet.org
location Varna, Bulgaria
age 25
visits member for 2 years, 10 months
seen 15 hours ago

Free Tibet From China Domination

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

enter image description here


19h
accepted How to get CPU usage by database for particular instance?
1d
revised How to get CPU usage by database for particular instance?
added 32 characters in body
1d
asked How to get CPU usage by database for particular instance?
Nov
14
awarded  Tumbleweed
Nov
13
accepted Is there a way to minimally log insert under Always on?
Nov
11
comment Is there a way to minimally log insert under Always on?
Could anyone tell if the numbers of records inserted matters, or the size of the row? I have 37 millions rows to insert, but I can group them in 147 772 rows if I change the table structure (for example XML and ID). The data will be the same as size (maybe bigger) but the rows will be less.
Nov
11
comment Is there a way to minimally log insert under Always on?
Thanks but Minimally logged operations are available only if your database is in bulk-logged or simple recovery mode. (technet.microsoft.com/en-us/library/dd425070(v=sql.100).aspx) and the database in full recovery mode. I am going to check the batches insert examples either.
Nov
11
asked Is there a way to minimally log insert under Always on?
Nov
10
asked A transaction log grows unexpectedly
Nov
7
revised How to fix deadlock caused by “X” locks on same resource?
added 214 characters in body
Nov
7
asked How to fix deadlock caused by “X” locks on same resource?
Nov
5
awarded  Popular Question
Oct
23
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');