30,525 reputation
24193
bio website rusanu.com/articles
location Seattle, WA
age 42
visits member for 3 years, 9 months
seen 3 hours ago

9h
answered Overlapping indexes
1d
comment Detached database file permissions
This behavior is sometimes caused by a process opening the file. The typical culprit is the anti-virus which detects the detach as activity and reacts by scanning the file. The scripts runs right after detach, when the AV is scanning. Running the script again later succeeds.
2d
answered many Servers of SQL server 2012 needs mirroring
2d
awarded  Necromancer
Oct
28
comment sql server service broker
No. You cannot, and you should not.
Oct
23
comment Transaction Isolation level different threads massive number of Writes
Bulk insert can be minimally logged, if possible. There is no such thing as 'not logged write'.
Oct
23
comment Seeing multiple CXPACKET blocks when trying to load data from a INSERT SELECT
How to analyse SQL Server performance
Oct
23
answered Transaction Isolation level different threads massive number of Writes
Oct
21
revised sql server service broker
added 966 characters in body
Oct
21
comment Which one is better performance and (approach): store as rows or as a varchar column
There is no OptionB, only A. Storing data as comma delimited values in databases is ground for immediate termination.
Oct
21
comment Does a database backup reduce size/increase free space of the log file?
Read rusanu.com/2012/07/27/how-to-shrink-the-sql-server-log
Oct
20
comment SQL Server database performance is very poor after a month of use
start from How to analyse SQL Server performance to identify the actual cause of the problem.
Oct
17
revised SQL Server 2008 and constant expressions
added 1 character in body
Oct
17
answered SQL Server 2008 and constant expressions
Oct
16
answered Restore backup to different filegroup
Oct
15
answered sql server service broker
Oct
8
awarded  Enlightened
Oct
8
awarded  Nice Answer
Oct
7
awarded  Necromancer
Oct
7
comment What is the best way to create a database diagram for SQL Azure without having to install SQL Server?
Paper and pencil.