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

15h
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.
Oct
7
reviewed Approve suggested edit on Alternative way to compress NVARCHAR(MAX)?
Oct
3
answered Alternative way to compress NVARCHAR(MAX)?
Oct
1
answered READ_COMMITTED_SNAPSHOT locking on Non-Clustered Index
Oct
1
comment SQL Server Error log - strange date
@Debbie: the errorlog time is always the server time
Sep
30
answered SQL Server Error log - strange date
Sep
30
awarded  Explainer
Sep
24
answered SQL Server, firewall and linked servers
Sep
22
answered Instead of Trigger Continue with operation after custom logic?
Sep
22
comment SQL Server: compare names ignoring non-alpha
+1 STRIPPEDDOWNNAME should be a persisted computed column. SQLCLR can be used to do all the char handling (remove spaces etc)
Sep
19
answered Find reason long running stored proc SQL Server
Sep
17
comment What is the logic behind ISNUMERIC for certain special characters?
@MarkSinkinson correct, but OP mentions 2012