Viewing 15 posts - 2,926 through 2,940 (of 7,191 total)
Only you can see your database, so it's up to you to investigate what's causing the problems and hence whether the best solution would be batching, rescheduling, rewriting, upgrading or...
December 2, 2015 at 2:22 am
Is there any reason to leave them in the old compatibility mode? If there isn't, you ought to bring them all up to date to take advantage of the...
December 1, 2015 at 7:01 am
That makes me suspect that your existing databases have a low compatibility level - SQL Server 2000 (80), maybe?
John
December 1, 2015 at 6:45 am
Yes, just do your preparatory work and then run the exe. It's not easy to back out of. You'd need to reinstall SQL Server and then reapply the...
December 1, 2015 at 3:56 am
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
Viewing 15 posts - 2,926 through 2,940 (of 7,191 total)