@MaxVernon arguably Joe Sack covered it: "Adaptive joins will introduce a higher memory requirement than an index nested loop join equivalent plan. The additional memory will be requested as if the nested loop was a hash join. With that additional cost comes flexibility for scenarios where row counts may fluctuate in the build input."
@JackDouglas Sorry to bother you but I've noticed recently that dbfiddle's Oracle engine no longer works (at least it doesn't work for me, throws an error page every time). Just wanted to make sure you know about that.
Hello. Sql Server 2014. My username in my machine is Royin - which is the active directory user.(dah) I'm connecting via SSMS to a SQL server via SA account login ( _don't ask me why - this is how we do it here and there's no way to change it_) Question : is there any query which I can run in SSMS that will show me `royin` ? ( and not `sa` ?)
Running SSMS17.x on newly established MSSQL-2016-standard.
When trying Select Top 100 from object explorer, there is very slow on even no response.
When trying on another long-running MSSQL2016 server, it is ok. Trying from SSMS2012 is ok! When scripting directly as new query, it is also ok. Pro...
What makes something spam and when should I flag it?
A post should be marked as spam ONLY when it contains an unsolicited message.
It should NOT be marked as spam when:
The answer contains no useful information, such as an answer that says “I don't care about your problem”. Flag an answer as ...
I have solution for shis:
Alter library sequelize file: squelize/lib/sql-string.js
incluid on line 56 this:
change
if (dialect === 'postgres' || dialect === 'sqlite' || dialect === 'mssql'){
// http://www.postgresql.org/docs/8.2/static/sql-syntax-lexical.html#SQL-SYNTAX-STRINGS
// http:...
Pretty sure anything like this would be too broad or unclear but does anyone have suggestions on where to start troublshooting lockouts that last about a second on a SQL Server 2008r2 DB? This should not be an issue but it impacts users workflow. I have seen things like this(DBCC opentran()) but that my window is super damn small. Admitting I am not a good DBA yet so I don't have a lot of XP in this area.
Well, if performance is really a matter, a bit of mess in the code cannot hurt :) Otherwise, you can create those tables as temporary ones, adjust work_mem and temp_buffers, wrap the whole thing in a function and hopefully done. Otherwise, seeing an actual execution plan of your query could help coming up with better ideas. — dezso13 mins ago
I have a question regarding clustered index selection. I have a SQL Server 2014 table that looks like the following:
OrderId int not null IDENTITY (this is the primary key column)
OrderDate datetime2 not null
CustomerId int not null
Description nvarchar(255) null
Some folks on my team have s...
I think a composite clustered index key with CustomerID as the first column will be best since the that's in the WHERE clause of nearly all queries. OrderID or OrderDate may be best for the second column depending on most critical queries. For example, if customers see a chronological list of recent orders after logging in to a web site, OrderDate should be next to optimize ORDER BY OrderDate DESC. — Dan Guzman23 mins ago
I would think that starting a new sequence would be far less common than asking for the next number, so it seems reasonable to do extra work for that piece
You're getting a trivial and autoparameterized plan for your simple query. Add AND 1 = (SELECT 1); to the end, and you'll get the constant scan/contradiction detection. — sp_BlitzErik1 min ago
I'm going to disagree with the wiki answer. Choosing CustomerID as the first column of a composite clustered key is going to generate a lot of mid-page splits. You hopefully have lots of existing customers and also get many new customers all the time. Because customers are (hopefully) placing m...
my translator goggles appear to be failing. What does he mean by "seeders"?:
Max I somewhat agree with not needing nomenclature for its own sake, however this has been extremely relevant lately in the context of seeders, where the seeders seeding so called "mutable" tables are seeding them with truly fake data, but the seeders seeding "reference tables" are seeding them with more or less real data — chiliNUT11 hours ago
What makes something spam and when should I flag it?
A post should be marked as spam ONLY when it contains an unsolicited message.
It should NOT be marked as spam when:
The answer contains no useful information, such as an answer that says “I don't care about your problem”. Flag an answer as ...
I have solution for shis:
Alter library sequelize file: squelize/lib/sql-string.js
incluid on line 56 this:
change
if (dialect === 'postgres' || dialect === 'sqlite' || dialect === 'mssql'){
// http://www.postgresql.org/docs/8.2/static/sql-syntax-lexical.html#SQL-SYNTAX-STRINGS
// http:...
I have a question regarding clustered index selection. I have a SQL Server 2014 table that looks like the following:
OrderId int not null IDENTITY (this is the primary key column)
OrderDate datetime2 not null
CustomerId int not null
Description nvarchar(255) null
Some folks on my team have s...
I'm going to disagree with the wiki answer. Choosing CustomerID as the first column of a composite clustered key is going to generate a lot of mid-page splits. You hopefully have lots of existing customers and also get many new customers all the time. Because customers are (hopefully) placing m...
