Are you performing the left join because you don't always have a Case.addressID for a particular case row,  meaning that the Case.AddressID could be NULL?

In that case, you could use a special address...

What happens if you navigate to the first URL?  The second?  They are not the same.  The first one specifies port 80 (http default port) and the second one specifies...

I forgot a couple things.

In general, I would also back up the beta before destroying it, just in case some developer forgot to get everything into source control.

 I would also script...

This can be some fun stuff to try to do.  Good luck!

What I've done in the past is approximately like so:

I create a staging database on the destination server. 

Then...

Hello a-malik,

you could set up transactional replication, and distribute the updates at the end of the day.  Log-shipping is another way as mentioned earlier.

jg

This question doesn't have an answer.  It is not possible, because we do not know anything about the table [mytable], or if it even exists at all.  If it does exist,...

Hello,

If you have multiple tape drives available, you can multi-stream (aka stripe) the backups in NetBackup so that they run in parallel.  This can cut down the amount of time required...

Rajesh,

Did you create another file in the same filegroup, or create a new file and filegroup?

The other posts in this thread appear to deal mostly with moving tables/data to different...

It seems to me that you would want to use a VPN of some sort.  These can be set up between firewalls if they include that feature. 

If you can't...

I've also seen this kind of behavior caused by a backup agent that is hung, or in the middle of a backup on the affected file.  In this scenario, the...

Hi Tim,

That's good information.  Now, can you observe the execution plan of the delete statements?  One thing that I've found is that a select or delete that causes a table or...

Tim,

How many casecade-related tables do you have, that you can't get out of the way of an insert every 9 seconds?

Also, why doesn't the insert just get blocked and then succeed...

Hi Tim,

Your particular situation is probably a bit too complicated to give you a cookie-cutter answer, so instead I propose a strategy rather than a solution. 

First, if you don't care...

Hi GArry,

I don't know the direct answer to your question, but I can offer a way for you to perhaps find what you seek on your own.

If you start a...

You can use something like what Dave I suggests, but use NULL to avoid data type conflicts.

Order by

Case when @Direction = 'Asc'

       Then Case when @ColumnID = 1 then...