Viewing 15 posts - 1,081 through 1,095 (of 22,227 total)
The example query doesn't have a WHERE clause, so you're moving every single bit of the data. Indexes will help a little bit, but not much. A query that moves...
"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
November 30, 2021 at 1:20 pm
ISNULL doesn't exist, but COALESCE is there.
"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
November 29, 2021 at 4:02 pm
Ah, it's asking you to do a LEFT JOIN and then deal with the NULL values to arrive at the value of zero (0) for anyone who doesn't have...
"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
November 29, 2021 at 3:50 pm
You really can't. A clustered index, columnstore or rowstore, defines data storage. You can't really redefine data storage without completely rebuilding the table. So, build a new clustered columnstore table...
"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
November 29, 2021 at 3:44 pm
Oh come on.
Thanks though.
"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
November 27, 2021 at 1:46 pm
Nah, don't apologize. This forum is here to expand knowledge, so please, use it.
I haven't tried troubleshooting the DTA too much, so I'm not sure what you can do there....
"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
November 25, 2021 at 1:34 pm
First, don't use the tuning advisor. It's actually more than a little bit dangerous in its recommendations.
Second, are you providing an XML input document? Is it that it's too large...
"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
November 24, 2021 at 1:42 pm
Hard to know what to say here without detail.
Instead of cursors, use set-based queries.
There you go.
"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
November 24, 2021 at 1:32 pm
You can't restore to another server & try to test it there? I'd argue it's important to get something like this right because messing it up could be painful.
"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
November 22, 2021 at 3:36 pm
Testing is your friend. Try Phil's suggestion. It's likely going to be faster just based on the simple idea of data movement. Moving 100 million rows through the copy may,...
"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
November 22, 2021 at 3:19 pm
Do you mean just a simple backup and restore, not data changes at all, no inserts, deletes, nothing like that, and suddenly SOME values are different after the restore?
Nope.
That doesn't...
"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
November 22, 2021 at 3:16 pm
You are getting a scan of TAllData (please tell you don't have a naming standard where you name all tables T*). It doesn't have filter criteria, but it does have...
"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
November 19, 2021 at 1:45 pm
Read the full error message. It says something about incorrect number of parameters. Without seeing your code or the message or anything else, I can't tell you what's going on,...
"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
November 19, 2021 at 1:29 pm
8gb is probably low. Jonathan Kehayias is someone I really trust on this. Follow his advice.
"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
November 18, 2021 at 2:35 pm
Yep. AdventureWorks in all it's messed up glory. Honestly, I love that sample database. Why? Because it looks like all the other messed up constructs I see everywhere else. 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
November 18, 2021 at 2:16 pm
Viewing 15 posts - 1,081 through 1,095 (of 22,227 total)