Can you explain what you mean by is partitioning working?

If you have partitioned the table and have data that belongs on multiple partitions and the data is on the multiple...

Yes you have parallelism running in this case. Here are some questions:

1. What is the max degree of parallelism setting for the SQL Instance? If it is...

If [schemaName] is really owned by dbo, then execute permissions on the procedure should work using ownership chaining. Unless there is a specific deny update permission for that user....

Hey, it's not like I...

The difference in days between today (2014-10-27) and the dates you have listed is not greater than or equal to 0, so the code will not change the expected ship...

The problem is that you don't have "\test.bak" in @BackupLoc...

Based on your test data is looks like this works:

WHEN j.JobStatus <>'S' AND DATEDIFF(DAY,CAST(J.ExpectedDate AS DATE), @Date) >= 0 THEN

...

spaghettidba (10/22/2014)

Stefan Krzywicki (10/22/2014)

Of course, regionalisms mean it could be called most anything.

For example: In most of the USA, a blended milk and ice cream drink is called a Milk...

I think you should read the BOL article on Recovery Models, http://msdn.microsoft.com/en-us/library/ms189275(v=sql.90).aspx because some of your assumptions are incorrect. For example a database in SIMPLE recovery can have differential...

You should read this article, http://www.sqlservercentral.com/articles/72993/, by Jeff Moden. As far as I'm concerned that's got the best method for splitting strings.

Since DBCC CHECKDB is returning errors, my best suggestion is to restore from the last good backup. Unfortunately that appears to be a few days ago, so you will...

I'd suggest reading this article by Erland Sommerskag, http://www.sommarskog.se/query-plan-mysteries.html. It explains how different SET OPTIONS are used by different providers and can affect query compilation. I'd be willing...

It depends. The way the current code I provided works it just links the first 2 rows for a specific med_rec_no regardless of gap. So if I have...

I'd say both are grills here in the U.S.

Your welcome. Just note that is only works for 2 rows per med_rec_no and doesn't take into account the likelihood for a gap in times. The code assumes...