Viewing 15 posts - 2,926 through 2,940 (of 7,187 total)
Yes, or run them less frequently, or at a quieter time.
John
December 1, 2015 at 3:00 am
(1) Maybe, but bear in mind that performance may be affected because there will be a lot of modifications to the server, which will need to be written to the...
November 30, 2015 at 9:35 am
It's a correlated subquery. So for each value of ID in the JOB table, it calculates the average commission for that ID in the COMISSION table. If that...
November 30, 2015 at 9:31 am
zicado (11/30/2015)
What is the result from:SELECT NAME FROM JOB WHERE 2340.00 < (SELECT AVG(VALUE_COMISS) FROM
COMISSION WHERE JOB.ID = COMISSION.ID);
You've gone to the trouble of posting DDL and sample data -...
November 30, 2015 at 9:04 am
Search for, download and create sp_whoisactive. You can use it to see blocking chains and wait types in real time. Use Extended Events to capture blocking events and...
November 30, 2015 at 4:34 am
We can't see your screen, so it's impossible to envisage your requirement. From what you describe, though, it sounds as if you need a MERGE statement to do your...
November 30, 2015 at 4:04 am
WITH Capacities AS (
select en.NAME as ClusterName, SUM(ROUND(CAST(CPU_CORE_COUNT as FLOAT)*CPU_Hz*count(cast(hs.HOSTID as BIGINT))/800000000,0)) as Hub_Capacity
from VPXV_HOSTS as hs WITH (NOLOCK,NOWAIT)
full join VPXV_ENTITY as en WITH (NOLOCK,NOWAIT) on hs.FARMID = en.id
where en.TYPE_ID...
November 30, 2015 at 2:16 am
Yes, I've seen that described as an "unreported cardinality error". In other words, there is more than one value to choose from for any or each of the rows...
November 27, 2015 at 7:15 am
dopydb (11/26/2015)
yea, but if i have 100 suppliers then i need 100 subscriptions?
Yes.
iv managed to send the report using a script, so i think if i can pass the email...
November 26, 2015 at 7:23 am
Mal
You don't need a separate report per supplier - just a separate subscription. You might need to change your report a little to get to where you want to...
November 26, 2015 at 6:00 am
Mal
Have you tried using subscriptions? You can specify parameters for those - not dynamically, as far as I'm aware, but all you need to do is pass the supplier...
November 26, 2015 at 5:16 am
Why not just incorporate the query that determines the parameter values into the report?
John
November 26, 2015 at 5:01 am
Viewing 15 posts - 2,926 through 2,940 (of 7,187 total)