Viewing 15 posts - 856 through 870 (of 1,838 total)
OK, that shouldn't matter, looking at it further, on my report it looks like it only updates the dependent parameters the first time, it may be related to this bug...
July 19, 2017 at 2:16 pm
the main problem with using data from sys.dm_db_index_usage_stats directly is that the data there gets reset when the service restarts.. Do you know the uptime of this server?
[code...
July 18, 2017 at 3:14 pm
how about something like this?WITH invoice_sums AS
(SELECT invoice_number, passenger_name,
SUM(fare) OVER (PARTITION BY invoice_number) AS total_fare,
SUM(commission) OVER (PARTITION BY invoice_number) AS total_commission,
...
July 18, 2017 at 2:59 pm
how do you have the StartDate and EndDate parameters setup? I've seen something similar, where the StartDate and EndDate parameters have properties of:
Default Values: Specify Value, using a Switch...
July 18, 2017 at 11:04 am
I think the problem with linked servers isn't in how many you have setup, but the performance each time you use one. I've seen systems where the performance limitation was...
July 18, 2017 at 10:33 am
July 17, 2017 at 12:49 pm
OK, if CPU, memory, disks setup the same, have you checked the "cost threshold for parallelism" and "max degree of processing" on the 2 servers?
More importantly, looking deeper...
July 17, 2017 at 12:44 pm
July 17, 2017 at 12:07 pm
I notice on Server1 the execution plan went parallel in multiple places, does Server1 have more CPU cores in it than Server2? That could be a contributing factor in it...
July 17, 2017 at 11:02 am
my favorite way to do this is to use CROSS APPLY to unpivot the data and then just use MAX():DECLARE @yourtable TABLE
(colA INT,
colB INT,
colC...
July 17, 2017 at 10:39 am
The FIRT THING every intelligent person I know does, when building a new PC,...
July 17, 2017 at 10:03 am
Thom A - Thursday, July 13, 2017 7:59 AMdoes anyone know where you find SQL Server 2012 Developer?
I don't think developer...
July 13, 2017 at 12:14 pm
July 12, 2017 at 3:14 pm
Are you sure that tblB.id is the proper foreign key column to join bacl to tblA.id with? If you join on the wrong column then yes the results for tblB...
July 12, 2017 at 3:09 pm
Well I didn't really gain this level of knowledge just from books, it's more a mix of techniques from various resources and years of doing some trial and error experimentation...
July 11, 2017 at 3:06 pm
Viewing 15 posts - 856 through 870 (of 1,838 total)