Reputation
32,843
Next tag badge:
503/400 score
72/80 answers
Badges
8 84 145
Newest
 Enlightened
Impact
~1.0m people reached

11h
awarded  Enlightened
11h
awarded  Nice Answer
14h
awarded  Nice Answer
1d
awarded  Caucus
1d
awarded  Nice Answer
Jul
21
comment does getdate() function causes deadlocks
As you are on 2012 you can get the deadlock graph from the default trace dba.stackexchange.com/a/10646/3690 (if not there you might have to wait till the problem recurs). Please add this to your question.
Jul
20
comment How to full text search worked with special character like “of”?
it depends...
Jul
19
revised Index on a persisted computed column not seekable?
No need for RIGHT to reproduce the issue
Jul
19
comment does getdate() function causes deadlocks
No. please show the deadlock graph.
Jul
19
awarded  Nice Answer
Jul
18
comment Index on a persisted computed column not seekable?
Please update this if you get any interesting response!
Jul
18
revised Index on a persisted computed column not seekable?
added 277 characters in body
Jul
18
revised Index on a persisted computed column not seekable?
Spelling, formatting
Jul
18
comment existing foreign key that references fields with different datatype (char(8) and varchar(8))
@Paolo - You'd be looking for "breaking changes" in the release notes for SQL Server 7 but I don't think much documentation is online for SQL Server prior to 2000.
Jul
18
comment existing foreign key that references fields with different datatype (char(8) and varchar(8))
@ypercube - From testing on 2005 with 6/6.5 compatibility mode this would not be allowed Columns participating in a foreign key relationship must be defined with the same length.
Jul
18
comment Database Maintenance Planner greyed out (disabled)
Any help? dba.stackexchange.com/q/12584/3690
Jul
18
comment existing foreign key that references fields with different datatype (char(8) and varchar(8))
@PaulWhite - Yep this test on 2005 shows it was preserved that long i.stack.imgur.com/2w7cj.png (2005 supported 60/ 65/70, 2008 just 80 up)
Jul
17
answered Index on a persisted computed column not seekable?
Jul
17
awarded  Enlightened
Jul
17
awarded  Nice Answer