Sounds like you need a case statement:

select a.casecode, a.[Goal_Weighing],b.ddate, CASE WHEN b.ddate < GETDATE() THEN 0 ELSE 1 END as GoalBehindFlag

from [dbo].[VRep_Calc_1] as a

inner join [dbo].[VRep_Goals] as b

on a.casecode =...

Matthew Darwin (6/7/2013)

---

I had also noticed that if I take a small set of ServicerHistoryIDs as an input to the main ServicerHistory table, then the APPLY operator worked better; I'm...

If we skew your test data so there's a lot of rows per "ServicerHistoryID" that are not the top 1, you can see the dramatic switch in the cost of...

Apply is definitely not the fasted method in any scenario, but there are plenty where it can outstrip other approaches.

In this particular comparison against Row_Number, although it's not the most...

No, can't think of any technical reasons not to do this. The 64gb limit in Standard Edition is per-instance.

Have you granted any server level permissions like sysadmin to the web user?

edit: 4 seconds too late!

It was new to R2, though, I believe? 2008 allowed the OS limit in standard...

Lynn Pettis (6/4/2013)

---

Actually, SID is the security id in SQL Server. PID is more likely synonymous with SPID in SQL Server.

From the definition of SID in sys.server_principals:

SID (Security-IDentifier) of...

They're typically Oracle terms. SID would most closely relate to SPID in SQL Server and PID to the OS level process ID.

There's no direct correlation to SQL Server, as in...

demonfox (6/4/2013)

---

Yes, I tried for Newton Raphsson method, i.e. binay search .. It's the proper way to find out the correct resultset ; and SSIS is even better ..

As for...

The insert order isn't guaranteed to be the same between two inserts, so the identity trick may not work. Also, I suspect it may allocate identities before the error is...

I'm not running 2012 yet, but SSMS (at least in previous versions) is 32-bit only, and therefore the import/export wizard will only see 32-bit MySQL drivers, not 64-bit, so that...

If you want it to run on a particular day number each month, but move to the next day only on a Sunday, the built in scheduler won't be able...

Remember if you're not on Enterprise Edition, you will need the WITH(NOEXPAND) hint in all queries to actually make use of the indexes.

There is also a long list of things...

Partitioning can clearly improve query performance in a different way than indexing can. Partition elimination can be vital to query performance with very large tables, particularly in Data Warehousing, where...