Viewing 15 posts - 1,486 through 1,500 (of 22,219 total)
And then you toss in aggregations and columnstore gets faster. Or, an XML index can speed up Xquery. Spatial indexes can speed up spatial queries.
There isn't a single "This index...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 6, 2021 at 2:30 pm
Just reinforcing the correct answer. A TOP query without an ORDER by doesn't guarantee any particular order. Further, if you look at the execution plans for the two queries, you...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 6, 2021 at 2:27 pm
Without seeing the execution plan itself, I'm just guessing. However, it's likely that you're seeing lookups because of foreign keys. Modifying columns that don't contain any foreign keys will likely...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 6, 2021 at 2:24 pm
Do you really need all those DISTINCT statements? Shouldn't the one that fills the temporary tables do the job for the ones that follow? Each of those requires aggregation. Also,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 6, 2021 at 2:20 pm
The deal with shrinking databases is not the simple act of a one-time shrink:
"Oops, we had a bad data load. Gotta shrink the database."
Despite the dire warnings you get all...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 5, 2021 at 1:34 pm
You may have to restore to a new database and then migrate the data over manually or using a tool.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 28, 2020 at 1:25 pm
I wonder if the virus was the cause of PASS's demise, or was it the final nail in the coffin?
Personally, I'd say it's 70/30. We had a balanced budget...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 22, 2020 at 12:36 am
We also watch Miracle on 34th Street, with Natalie Wood, Maureen O'Hara, John Payne and Edmund Gwenn, in black and white (the best way to watch it). Note: Edmund...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 21, 2020 at 4:04 pm
Yep. All done. Sucks.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 17, 2020 at 11:21 pm
They are only going to affect the query if there is blocking. If there is a lock over on resource X and you're accessing resource Y, it doesn't matter. It's...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 17, 2020 at 12:32 pm
And for reference, here's the documentation on synonyms.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 16, 2020 at 1:32 pm
Ah, so you're not after locks as such, you're looking for blocking and what's causing the blocking?
If so, here is a great article on exactly how to do that.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 16, 2020 at 1:31 pm
One thing that few consider is that it might be "recompiles". We had a query that was taking "only" (way too long in my eyes) 100ms to execute. The...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 16, 2020 at 1:26 pm
First, you'll need to detail exactly what it is you're hoping to see, which events you're capturing and how what you want for filtering.
Second, just so you know, Profiler has...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 16, 2020 at 1:00 pm
You'll see tons of variation on the duration even if every other thing about the query is identical, the rows returned, the parameter values used, everything exactly the same. Why?...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 15, 2020 at 1:37 pm
Viewing 15 posts - 1,486 through 1,500 (of 22,219 total)