Viewing 15 posts - 5,836 through 5,850 (of 22,211 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...
July 10, 2015 at 6:44 am
And the first several chapters of my book on query tuning should help.
July 10, 2015 at 2:50 am
It doesn't matter a lick.
I'd just strongly argue for consistency to help promote clarity.
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...
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...
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...
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...
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...
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.
July 9, 2015 at 2:47 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...
July 9, 2015 at 2:38 am
Eric M Russell (7/8/2015)
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?...
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...
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...
July 8, 2015 at 6:00 am
Viewing 15 posts - 5,836 through 5,850 (of 22,211 total)