Viewing 15 posts - 5,851 through 5,865 (of 22,226 total)
Oops. yes. Another query1, query2, not your query1, query2. Sorry about that.
First most likely issue, the two different tables in the query, DIM_MATERIAL vs. DIM2_MATERIAL are showing different statistics right...
"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
July 10, 2015 at 6:44 am
And the first several chapters of my book on query tuning should help.
"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
July 10, 2015 at 2:50 am
It doesn't matter a lick.
I'd just strongly argue for consistency to help promote clarity.
"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
July 10, 2015 at 2:49 am
These are two completely different queries:
SELECT PT.created_dttm Created_Datetime,
PT.proj_task_id Project_Task_Id,
CONVERT(VARCHAR(2000), text, 0) text
FROM...
"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
July 10, 2015 at 2:46 am
Maybe you mean how frequently can you run log backups?
You can run them as frequently as they complete, but no faster. Considering the management overhead and the work involved in...
"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
July 10, 2015 at 2:34 am
sindura.pulimamidi1 (7/9/2015)
WHAT ARE BACKUP DEVICES? ANY PERFORMANCE ADVANTAGE WITH USE OF BACKUP DEVICES?
They're just a way to identify where you're storing backups to simplify code. Nothing more. It doesn't hurt...
"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
July 10, 2015 at 2:32 am
rodjkidd (7/10/2015)
I can get to Redgate for about 4 pm, traffic permitting. Maybe a bit before.
So if you are still up to meet and have a chat let me...
"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
July 10, 2015 at 2:14 am
Isn't the CHARINDEX just checking the existence of the value in a column? Can't you use equals? If not, can you use LIKE? If you really are searching through an...
"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
July 9, 2015 at 8:24 am
Junglee_George (7/8/2015)
Instead of removing cursor, please help to me to modify the existing code within.
I did. Those functions on columns are going to kill your performance. You must remove them.
"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
July 9, 2015 at 2:47 am
Interesting. Which add in?
"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
July 9, 2015 at 2:41 am
It must have something to do with parameter sniffing. The hard coded values are going to get specifics from the OID column. The query is open to interpretation. In other...
"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
July 9, 2015 at 2:38 am
Eric M Russell (7/8/2015)
"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
July 8, 2015 at 8:22 am
rodjkidd (7/8/2015)
Grant Fritchey (7/8/2015)
rodjkidd (7/8/2015)
BrainDonor (7/8/2015)
Yes, PASS UK isn't well organised. I found out about by chance, having decided to search on the PASS website for anything in trhe UK.
Really?...
"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
July 8, 2015 at 6:38 am
rodjkidd (7/8/2015)
BrainDonor (7/8/2015)
Yes, PASS UK isn't well organised. I found out about by chance, having decided to search on the PASS website for anything in trhe UK.
Really? It's mentioned at...
"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
July 8, 2015 at 6:22 am
Doing an operation like this with a large query like that within a cursor is extremely problematic. Instead of a cursor, I'd suggest modifying or loading your temp table such...
"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
July 8, 2015 at 6:00 am
Viewing 15 posts - 5,851 through 5,865 (of 22,226 total)