I suspect that this reading was taken straight after you added more memory. You need to use the database to see if it will use all the memory. SQL Server...

I don't know, but I was thinking it could be...

An alternative way to do it:

REPLACE(TRANSLATE(email, '0123456789', REPLICATE(CHAR(1), 10)), CHAR(1), '')

Though you can disable the foreign keys, then truncate, then enable the...

Okay, this is VERY weird. My last post, when I hit submit, errored out with "Are you sure you want to do that?"

And when I hit submit again, it...

You can do it with a cursor which can be faster if you a purchasing a large number of products:

IF OBJECT_ID (N'tempdb..#TEMP1', N'U') IS NOT NULL DROP...

;with cte as
(
    select sum(t.price) over (order by t.price asc, v.N) RunningTotal, * 
      from #TEMP1 t
...

;with cte as
(
    select sum(t.price) over (order by t.price asc, v.N asc) RunningTotal, * 
      from #TEMP1 t
 ...

Create two temporary tables which are copies of D and S but with the additional columns of [O_NAME_04_NOT_NULL], [O_NAME_05_NOT_NULL], [O_NAME_06_NOT_NULL] , then add a clustered index on the name columns.

e.g....

You can query SSAS...

I've found replacing...

Have you looked at the execution plan? Maybe you should paste all the code in this thread.

Jonathan,

There is no problem with the UPDATE. All indexes are created. Moreover, tables #SecuritiesClass and #SecuritiesClassRules only contain 3 records. By putting GETDATE() before and after the UPDATE, I...

If the MERGE statement is just updating or inserting then change it to be an update statement followed by an insert where not exists statement.

Hi Ken,

For your knowledge, this is the actual statement that triggers the problem:

UPDATE SC
SET 
  SC.QuickEffectiveDate = SCR.EffectiveDate,
  SC.QuickNominalValueChangeTypeID = SCR.NominalValueChangeTypeID,
  SC.QuickHasRightToVote =...