23,721 reputation
873144
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 4 years
seen 2 hours ago

1d
comment Oracle 12c Installation in Windows 7 error INS-30131
Please click the 'checkmark' to mark your answer as "the" answer.
Mar
27
comment Is it possible to get seek based parallel plan for distinct/group by?
Skip Scan Connect Item. Closed as Won't Fix, but that doesn't mean it won't be addressed in future. Just that it probably won't :)
Mar
20
comment MAXDOP not working?
@EdwardDortland I had seen that question before - judging by my upvote - but had forgotten about it. At the time, I didn't answer because the existing one seemed to cover it. If I helped clarify things with this answer, that's a bonus! Thanks for alerting me :)
Mar
20
comment Index Optimization Error in SQL Server 2012
Perhaps relevant: connect.microsoft.com/SQLServer/feedbackdetail/view/497580/…
Mar
8
comment How to optimize a table/db with 200 insert/sec
Please merge your accounts
Mar
2
comment Ola Hallengren Index Optimise Script not Rebuilding Indexes
Possible duplicate of Why not rebuild indexes with page count <1000?
Feb
27
comment Subselect of MAX(Version) takes many minutes, though there are only ~20K records
@DavidKrider Yes sorry I meant to mention that in the answer. I used SQL Sentry Plan Explorer for the screenshots. There is a free version of this very popular plan analysis tool.
Feb
27
comment Why would a query work slower when a where clause is added?
The presence of a filter (or not) affects the way the query optimizer estimates the effect of the TOP. You can use OPTION (QUERYTRACEON 4138) on modern versions of SQL Server to see the effect on the chosen plan by disabling the optimizer's 'row goal' logic. This trace flag is documented, but only really intended for debugging purposes.
Feb
27
comment Optimizing queries for 25+ million rows
@Atieh Not materially, no. Unless it also includes DATE and AFTER, using that index will also require an RID lookup. Check the execution plans.
Feb
27
comment Optimizing queries for 25+ million rows
I did ask for an edit and improvements by adding a detailed (and polite) comment. That's what comments are for. You should also tag your question with the version of SQL Server you are using (e.g. SQL Server 2014). DDL for the table might be helpful too (CREATE TABLE statement). The down vote was because the question was not clear.
Feb
27
comment T-SQL bulk insert fails on specific word “DENY” in string-data
I'm voting to close this question as off-topic because it lacks a clear reproduction script.
Feb
25
comment mysql dump a table to remote host
possible duplicate of How do you mysqldump specific table(s)?
Feb
17
comment How list of netezza system tables/views?
@a_horse_with_no_name Many DBMSs support such a thing. The number of rows reported would depend on the isolation level, or possibly be implementation-specific; there's no logical reason such a thing can't exist just because transaction do.
Feb
7
comment SQL Server 2008 user, group, or role already exists in the current database
Please consider expanding this answer beyond just raw code. For example, you could explain what this does, and why you think it will fix the problem described in the question.
Feb
4
comment How can I optimize a mysqldump of a large database?
This is an exact copy of your answer to another question. You might want to customize it a bit more for this specific question.
Feb
4
comment Database cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery
Please edit your answer rather than using a comment (comments may be deleted at any time and are not searchable). Thanks.
Jan
31
comment How to add External data source into MySQL?
An ODBC data source to a MySQL database? Or from a MySQL instance to something else? Edit more details into the question please. This will avoid your question being put on hold for being unclear.
Jan
31
comment This Extended Events session works on Dev but not on Pro. Why?
Please merge your accounts. The question is on hold because there aren't enough details to allow someone else to reproduce the issue. This leads to extended discussion and guesswork, which is not a good fit for this site. It might be a good question; it's just not on-topic here.
Jan
24
comment Optimization around static cursor use
Be careful changing cursor threshold because it will prevent allocation order scans
Jan
22
comment How do I update and insert specific set of rows to an existing table using Merge in SQL Server 2008 R2?
@predestination If you're asking about concurrency and locking, try Kalen's book (the PDF version is free).