Viewing 15 posts - 6,766 through 6,780 (of 8,755 total)
davidwarner (10/16/2014)
BTW i read i shouldn't make any changed to maxdop or cost of parra during business hours as SQL will dump the plan cache?
That is correct, so be careful!
It...
October 16, 2014 at 1:04 am
Quick thought, the cost threshold for parallelism is way too low, would suggest setting it to 50 for a start. Can you provide more information on the setup?
😎
October 15, 2014 at 11:34 pm
Further on Luis's post, do only one dateadd operation and use convert for the formatting.:cool:
October 15, 2014 at 10:50 pm
Done this on exactly the same version/edition and the performance is brilliant so no worries there. One thing to check though is the configuration of tempdb, rule of thumb, recommend...
October 15, 2014 at 10:21 pm
Further on mickyT's post, the cross row referencing window functions are perfect for this kind of queries, here is a quick sample.
😎
USE tempdb;
GO
;WITH SAMPLE_DATA(SD_ID,SD_DATE) AS
( SELECT * FROM (VALUES
...
October 15, 2014 at 9:52 pm
dhans123 (10/15/2014)
I also got errorMsg 156, Level 15, State 1, Procedure my_sp, Line 2
Incorrect syntax near the keyword 'FROM'.
Thanks for the question:-)
Got the same on 2014, non of the options...
October 15, 2014 at 12:21 pm
Had few time-outs today, took me half an hour to respond to one post using the 3/4G on the mobile. Thought it was a carrier issue but then on a...
October 15, 2014 at 12:12 pm
Grant Fritchey (10/15/2014)
BOR15K (10/15/2014)
I have created Countries_View and placed the problematic CASE within the view and then JOINT Cities A table with Countries_View B
and all...
October 15, 2014 at 11:49 am
peacesells (10/15/2014)
October 15, 2014 at 10:06 am
BOR15K (10/15/2014)
Eirikur Eiriksson (10/15/2014)
BOR15K (10/15/2014)
I have created Countries_View and placed the problematic CASE within the view and then JOINT Cities A table with Countries_View B
and...
October 15, 2014 at 10:04 am
BOR15K (10/15/2014)
I have created Countries_View and placed the problematic CASE within the view and then JOINT Cities A table with Countries_View B
and all works like...
October 15, 2014 at 9:21 am
Quick thought, you cannot execute the 2K5 function on the 2K server, the execution has to be in the scope of the 2K5 only. A workaround could be in the...
October 15, 2014 at 1:51 am
Quick question, why are you using the nolock hint?
😎
October 15, 2014 at 12:58 am
jacksonandrew321 (10/15/2014)
HiI have created stored procedure to find out first word of the keyword. I am getting error below on execution:
"Must declare the scalar variable "@SubjectBeginning"."
Please suggest
Quick note, for a...
October 15, 2014 at 12:58 am
Viewing 15 posts - 6,766 through 6,780 (of 8,755 total)