698 reputation
37
bio website
location Finland
age 38
visits member for 3 years
seen yesterday

Sysadmin with strong focus on scripting. Powershell is the weapon of my choice. When it doesn't just cut it, I will add TSQL, C#, P/Invoke and VBScript.


Nov
17
awarded  Yearling
Nov
11
comment DBCC error reported
Which version of Sql Server? What did you do that triggers the errors?
Oct
29
answered Paging in SQL Server: Is an order by clause required? (currently, rows are being missed)
Oct
6
comment Compress files and directories into zip file and put it into blob field
I still think that using Sql Server to send a zip from the server's HDD to a client is either a) monkey business b) very wrong solution attempt to a valid business problem that's easily resolved with entire different an approach. Why use Sql Server at all?
Oct
3
comment Compress files and directories into zip file and put it into blob field
This sounds like the Xy problem. What are you trying to do anyway?
Sep
24
awarded  Autobiographer
Sep
22
comment Is it possible that records are changed while a read query is still executing?
InnoDB claims full ACID compliance, so no partial insert should be able to mess data consistency. That being said, with right isolation level, a transaction that won't be committed might mess up your data anyway. So, please study carefully the transaction isolation theory and documentation.
Sep
18
answered Is it possible that records are changed while a read query is still executing?
Sep
17
comment How to schedule jobs in Sql server 2008 for less than 10 sec?
Read about the Xy problem and consider about updating the question.
Aug
28
comment How to get Identity Column to jump ahead (by say 1000) on SQL Server 2012
@Gabe For example, merge requires semicolon usage. See also Aaron's blog.
Aug
15
awarded  Organizer
Aug
15
revised How to merge a column in single row in sql server
Fixed formatting, retagged question
Aug
15
suggested suggested edit on How to merge a column in single row in sql server
Aug
11
comment Where to place tempdb and logfiles
What's the target performance you are looking? How much data you got? Describe the server and disk config a bit more.
May
20
comment What is an effective way to wipe sensitive data on a data pages after dropping a table's column?
Don't forget that your old backups still have the data.
May
20
comment How to improve this queries performance by indexing properly?
Please provide the execution plan in xml format.
May
9
comment Order of output row in random order
Please don't assume there is a default sorting without using order by. See Hugo's blog for counterexample.
May
5
awarded  Critic
Apr
24
comment App domain is marked for unload due to memory pressure
@remibourgarel See if Kimberly's document is of any help.
Apr
24
revised App domain is marked for unload due to memory pressure
Added a link for a whitepaper.