Reputation
26,569
Next tag badge:
143/100 score
19/20 answers
Badges
9 117 201
Newest
 Enlightened
Impact
~754k people reached

11h
comment The fastest way to get the most recent records
I took 2 minutes to actually run this (thanks for the demo script). and I can't see any advantage over the more usual distinct + cross apply approach? Any reason you prefer it over that?
11h
comment The fastest way to get the most recent records
Possible duplicate of Retrieving n rows per group.
15h
comment Writing SQL query for scenario
I'm closing this question as off-topic because an exact copy exists on Stack Overflow. Please do not do this. See Is cross-posting a question on multiple Stack Exchange sites permitted if the question is on-topic for each site?.
16h
comment Insert data from multiple rows into multiple columns
@Vérace Awarding more upvotes is easily done via the bounty system :)
16h
comment SQL Stored Procedure how to split column
This is too far vague. Please read Help us to help you then edit your question to make it answerable, with tables, sample data, expected output - and please also mention which database product you are using.
17h
comment sql INSERT QUERY
Placing this question on hold while it is clarified as Tom asks. See also Help us to help you.
17h
comment Speeding up insert in SQL Server
Martin and Zane are quite correct. From the information provided, the most likely cause is a missing index resulting in the large eager index spool. You really need to provide details (as Mark and David requested) if you expect a more specific answer. I am going to leave this question open for a while - despite the extended comments and answers based on wild guesses before the execution plan was added - to encourage Martin, wBob, or Zane (anyone really!) to post a (partial) answer. If this unclear question generates much more noise, that window of opportunity will not last long!
20h
comment Improve performance of query with multiple group by column and count function in select
Comments are not for extended discussion; this conversation has been moved to chat.
Feb
6
comment Firebird linked tables in Access 2010
I have tried to improve your answer, but please review my changes for correctness, and perhaps expand on your answer a little. See How to Answer for some guidance.
Feb
6
comment Mixed based replication between two databases on the same server
Comments are not for extended discussion; this conversation has been moved to chat.
Feb
5
comment Recursive Join to get Spans
We have merged your accounts. Please accept an answer, or edit your question to clarify what else is needed.
Feb
4
comment can't update table in stored function/trigger because
I'm placing this question on hold because it is a copy of a question on Stack Overflow. Please decide where you want this question to be. If here, please delete the other copy. See Is cross-posting a question on multiple Stack Exchange sites permitted if the question is on-topic for each site? for more information.
Feb
4
comment Select into statement
Please improve your question by stating the database product you are using, and providing a code sample. See How to Ask.
Feb
4
comment Fatal error when not numeric value - PostgreSQL 9.2
Placing this question on hold until it is updated to be clear.
Feb
3
comment Is it important to make transaction log backups?
Related: Understanding Backup Types
Feb
3
comment bonfire and codeigniter installation error
It's not really clear what this question is about, but please see the help center (1) and help center (2). If not on-topic here, you may be able to ask it on another SE site, but please read their equivalent help pages before doing so.
Feb
3
comment SSMS Registered Servers with ReadOnly Application Intent
The Connect item referenced is now marked as fixed. Can you confirm that updating SSMS resolved your issue? Please add an answer if so.
Jan
31
comment SQL Server 2014 COUNT(DISTINCT x) ignores statistics density vector for column x
The Connect item has been Resolved as Fixed? No comments from Microsoft so far though.
Jan
30
comment SQL Server 2012 Compatibility with New TLS 1.2 Standards
The question referenced has now been updated to include the latest KB information that seems to address this, so I have closed as a duplicate.
Jan
30
comment SQL server service won’t start after disabling TLS 1.0 and SSL 3.0
The answers here are out of date now, so I have closed this question as a duplicate of one with more current information.