Reputation
29,111
Next tag badge:
186/100 score
18/20 answers
Badges
10 133 227
Newest
 Good Answer
Impact
~891k people reached

11h
comment Why is Include Actual Execution Plan not included in @@Rowcount when it produces a row count?
This reminded me of an old Connect item of yours.
12h
comment Does table size matter?
@FLICKER Answer updated.
13h
comment What sort of exec requests don't have a sql handle? (sys.dm_exec_requests)
@Shanky Would you like to convert that into an answer?
17h
comment Group daily schedule into [Start date; End date] intervals with the list of week days
The site mains a revision history automatically. There is no need to add edit or update unless it is absolutely necessary. In most cases, the question and answer shown should simply be the best version, without any unnecessary noise. Just FYI.
17h
comment Group daily schedule into [Start date; End date] intervals with the list of week days
The discussion on this answer has been moved to chat.
17h
comment Group daily schedule into [Start date; End date] intervals with the list of week days
@VladimirBaranov Please see What is the official etiquette on answering a question twice?
1d
comment Execution Plan is NOT using INDEX and uses Table Scan
The discussion on this answer has been moved to chat.
1d
comment Does table size matter?
Comments are not for extended discussion; this conversation has been moved to chat.
1d
comment When are computed columns computed?
@ArthurD It is an optimizer decision based (mostly) on the estimated costs of each alternative, see my answer to another question here.
1d
comment Intermittent errors sending email from SQL Server Database Mail
You can accept your own answer by clicking the check mark.
1d
comment Convert table values into column header without PIVOT [number of column values is dynamic] - Oracle 10g
Related Q & A (maybe a duplicate): Pivot rows into multiple columns
1d
comment Return a fully dynamic table from an Oracle function
Comments are not for extended discussion; this conversation has been moved to chat.
2d
comment Select a range of values
I fixed the formatting and removed the broken link. Your answer could be improved further by providing a definition for the banks table, and some sample data (as in my answer). If you leave it as just code that no one can run, the community here will likely delete it.
2d
comment Improving mongodb read throughput for tiny database
Your accounts have now been merged. You are able to edit your question, leave comments anywhere on this page, and accept an answer (by clicking the check mark).
2d
comment DIfferences beween two data from different column
I have migrated your question to Stack Overflow so it can be merged with the other copy of your question there. Please see Is cross-posting a question on multiple Stack Exchange sites permitted if the question is on-topic for each site?.
2d
comment How to rewrite a query with MAX in WHERE clause
@Allen Please see What should I do when someone answers my question?. If this answer solved your problem. you should accept it (by clicking the check mark). Thanks.
Apr
25
comment Duplicates when checking for two different column values based on a key that is not unique in table
Please ensure you edit your question to keep it up to date with all the latest information. Do not leave important details in comments only, thank you. Please also provide the table schema as Chad requested.
Apr
25
comment How to return rows between two datetimes stored as date and time?
Your original question was answered. and your update seems like it should be a new question to me. I improved some of the formatting for you in case you want to copy it to your new question.
Apr
25
comment OrderBy int slow for large table join
@RobertBaldini It seems like you have a new question :)
Apr
24
comment Unknown System SPID blocking user SPIDs
@ChrisWoods Post it somewhere publicly accessible like gist or pastebin and add a link into your question. While you're at it, move the extra information you have provided so far from comments to the question body. Not only does that make it easier for people to answer, the edit will bump your question to the home page so people will see the update.