Your sample data for WOParts has PK violations.

Please provide the actual code to create the tables and some sample data inserts too. After that we should be able to help you with the query.

At first glance...

Well you could use the copy-only option with your native backups until you feel comfortable with the NetBackups. Here is a link on copy only backups: http://bit.ly/181yi6y

It won't be the...

Have you verified that the SQL Server service account has access to write to that network directory?

If you create those tables and add some test data and run both queries you will notice that you get the same exact plan. The two statements are identical.

As far...

I'm not sure I understand why you need to do both backups? What is the situation that you are trying to solve by having to do both native and NetBackups...

This should get you pretty close.

select

coalesce(a.UnitDate,dateadd(dd,1,b.UnitDate)) as UnitDate

,coalesce(a.UnitID,b.UnitID) as UnitID

,case

when a.UnitID is null then 'Unit No Longer Available'

when b.UnitID is null then 'Newly Available Unit'

end

from @AvailableUnits a

full outer...

The log file will simply change it status from a 2 (active) to a zero which means that the 1's and 0's are still there. He could do what you...

Take a look at the following link on how to create, use and manage partitioned views:

http://technet.microsoft.com/en-us/library/ms190019(v=sql.105).aspx

add a "select @DB" before you run the sp_execute statement and verify that the query looks correct.

sp_execute needs the statement to be unicode, so change @DB to NVARCHAR...

This will work, but I'm not sure how the performance will be on 10 million rows.

insert into SessionNumber

values (123, '09:00:00')

, (123, '09:01:00')

, (123, '09:02:00')

, (123, '09:05:00')

, (123, '09:08:00')

, (123, '09:11:00')

,...

Would this work?

create table SessionNumber (userID int, startTime time, sessionNum int)

insert into SessionNumber

values (123, '09:00:00', 0)

, (123, '09:01:00', 0)

, (123, '09:02:00', 0)

, (123, '09:05:00', 0)

, (123, '09:08:00', 0)

, (123, '09:11:00',...

As mentioned above try using this:

coalesce(st.markdownprice1,st.sellprice1)

That should get you what you want.

A couple of questions:

Is the growth due to the log file or the data file in TempDB?

Are you using Snapshot Isolation?

Have you checked for long running transactions?

What have you...