I can't see anything in the code of the stored procedure that would truncate the data for the RxNumber. I would start by debugging the VB.NET code to ensure...

What does the following return on both principal and mirror servers: select * from sys.database_mirroring.

You should only get a result set when run on a server operating as a witness...

gmrose (6/22/2012)

---

I think that part of the solution would involve converting the Hire Date into a Julian value. Is there any function in SSMS that will convert a date...

Reg_Mayfield (6/22/2012)

---

Lynn Thanks for the quick response...

I have been experimenting with this approach. I do have one question.

If I had a table that had 10 million rows and I...

paul weegar (6/12/2009)

---

Microsoft also has a FREE reporting tool called dashboard_performance that shows missing indexes, plus a lot more. It runs on SQL 2005 SP2 or above. Here is the...

Nope, clear as mud. You are going to have to provide DDL (CREATE TABLE statement) for the table(s) involved, sample data for each of the tables (8 to12 rows...

Here is something for you to play with.

create table #mytable(

ID varchar(12),

EffectiveDate datetime,

TermDate datetime,

[Status] varchar(1)

);

GO

insert...

themangoagent (6/22/2012)

---

Lynn, there are only a few that actually are 'Continuously' active though. They have to be active in December 2011, and January, February, March, April, May, and June of...

Thanks for providing some feedback. I'm sure the OP appreciates it also.

Some of the delay can also be from the OS as it modifies the backup file to the appropriate size due to over allocation when estimating the size of the...

I am assuming that the backups are done serially as it is in a maintenenace plan. Could be due to fragmention, both of the databases and where the backup...

Couple things I have noticed in the sample data, no multiple records for the same ID and no inactive IDs.

themangoagent (6/22/2012)

---

Here is a larger code set with some actual data. I need to select only those ID's who have an effective date on or before 12/01/2011, and I need...

Duplicate post, post answers here.