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

8h
comment Running SQL job: The login is from an untrusted domain and cannot be used with Windows authentication
This appears to be a MySQL-specific answer. The question is about SQL Server.
2d
comment The fastest way to get the most recent records
@Pasca Thanks for the thanks, but it's really not necessary to comment to that effect. The primary feedback mechanism here is votes and answer acceptance. You have earned enough through this one well-presented question to do both now, please see What should I do when someone answers my question? in the help centre.
Feb
9
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?.
Feb
9
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.
Feb
9
comment sql INSERT QUERY
Placing this question on hold while it is clarified as Tom asks. See also Help us to help you.
Feb
9
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
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 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.
Jan
30
comment Complex view becomes slow when adding ORDER BY in outer query with small LIMIT
@ErwinBrandstetter Closing as unclear seems appropriate to me, after 15 edits and 53 comments. The Q & A itself is most unlikely to be deleted, certainly not automatically (or by the OP). Closing just prevents new answers, not much else. It is a strong signal that the question requires improvement.
Jan
29
comment Stored Procedures under Source Control, best practice
Please be careful about posting exactly the same answer to multiple questions on the Stack Exchange network. See also the advice about self-promotion in the help center. All this applies especially to relatively new accounts that do not have an established record of non-promotional contributions.
Jan
29
comment Create a database in Access with historical records
Discussion on this question has been moved to chat as requested. Please continue any discussion on this question using that facility, thank you.
Jan
27
comment PostgreSQL seems to create inefficient plans in simple conditional joins
Comments are not for extended discussion; this conversation has been moved to chat. Please use that chat room for further discussion.