583 reputation
26
bio website
location Finland
age 38
visits member for 2 years, 9 months
seen 18 hours ago

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.


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.
Apr
23
answered App domain is marked for unload due to memory pressure
Apr
15
comment Help me improve my query
Where's the execution plan? Table definitions and indexes would be useful too.
Apr
11
answered Drop permission from a dbowner
Apr
4
answered How to know DB size using backup file without restoring it
Apr
1
comment Transaction Time out error C#
What additional workloads (both Sql Server and any other service, like file shares, IIS etc) the server is doing? What kind of storage the server has? Are the execution plans the same?
Apr
1
answered Short CIrcuit in WHERE clause
Feb
10
comment Simple method to setup SQL Server for development access
@MikeFal, Are you certain? Without Run as Admin, UAC strips local admin membership for user's security token. If the Sql Server has been set up so that only local admins belong into sysadmin role (typical setting on a next-next-next install often found on dev boxes) and there are no additional privileges being granted, the permissions need to be fixed. In order to do that, SSMS must be launched first with a priviledged mode and then used to assign additional permissions to the actual user account.
Jan
22
comment How to reduce the size of index file in SQL Server 2008?
What index is that? Why was it created in the first place? How do you know it is decreasing performance?
Jan
10
awarded  Yearling