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

Nov
20
comment Tracing, debugging and fixing Row Lock Contentions
An anonymous user submitted this suggested edit
Nov
20
reviewed Approve Standby controlfile error
Nov
20
reviewed Approve DBF file exist while user has been dropped?
Nov
20
reviewed Reject Tracing, debugging and fixing Row Lock Contentions
Nov
19
reviewed Approve 250 billion rows - computing interconnectedness on a really huge scale
Nov
19
comment query processor ran out of internal resources and could not produce a query plan
@SQLSpartan sqlserver.error_reported should do it I would have thought.
Nov
19
comment Introducing an 'age' category in a patients database
@FrustratedWithFormsDesigner - A trigger wouldn't be suitable as the categorization changes according to current time and date and there may be no inserts that would fire it.
Nov
18
answered Move Primary Key to Filegroup (SQL Server 2012)
Nov
18
revised How to alter primary key constraint for 2 columns in same table in SQL Server?
added 656 characters in body
Nov
17
comment HELP with SQL WHERE syntax
Just apply the brackets in your pseudo code to your actual code.
Nov
16
comment clustered and covering index ignored on delete statement. Table scan occurs
How have you established this delete statement is causing that amount of scans?
Nov
16
comment Finding exact statement causing error 3930
What version of SQL Server? The lightest weight trace possible would probably not be a trace at all but extended events.
Nov
16
reviewed Approve Oracle locked sessions with ASP.Net
Nov
14
answered How to alter primary key constraint for 2 columns in same table in SQL Server?
Nov
14
comment Why does DELETE leave a lingering effect on performance?
@RichardTheKiwi - Thanks! There is probably more to say on this. As I'll try upgrading to the same version as SQL Kiwi and seeing if I still see the different code paths. If so maybe it is hardware dependant that it makes such a difference (my tests have been on my desktop PC with all data and log files on the same SSD)
Nov
14
awarded  Nice Answer
Nov
13
reviewed Approve Query returning data from two rows of a table in a single row
Nov
12
comment Why do I have to select from the dual table?
SELECT CURRENT_TIMESTAMP FROM (VALUES(1)) V(C) is standard compliant I believe and doesn't rely on any particular table.
Nov
12
reviewed Approve Replication Error when adding small table as new article
Nov
12
reviewed Approve ORA-00905: missing keyword when trying to create a synonym