Yes, different databases can easily have tables, views, stored procedures, whatever with the same name. Being a former Oracle person myself, it sounds like you do have a good...

OK, thanks Gail for confirming that clustering does not have load balancing capability.

Does anyone have insight on what advantages if any clustering would have over mirroring? It...

I can't think of any...

You mentioned this is a high volume...

here's a WHERE EXISTS example for your code...

...

CASE WHEN EXISTS

(SELECT NULL FROM ForeignBins

WHERE CONVERT(INT, SUBSTRING(CardNum, 1, 9)) BETWEEN TopRange...

This tells me that BIT would be too small. You'd have to use 5 BIT fields to cover all...

check out the CONVERT function in SQL Server, it will let you explicity decide what format the string is in to convert to date.

CONVERT(datetime, @mystringdatevariable, 103)

for examle, would expect...

The CAST function is closer to the SQL standard specification. While CONVERT is more propriatary, it does give you an advantage when working with the DATETIME datatype because you...

if you want to get the value just inserted into the table after your INSERT, and you know that the INSERT in your stored procedure only adds 1 row to...

I see a couple of things offhand, but you should still get the information that Gail requested.

davidsalazar01 (9/26/2008)

---

CREATE PROCEDURE [dbo].[sp_UpdateTrans]

@firstTransId decimal,

@lastTransId decimal

AS

BEGIN

SET NOCOUNT ON

...

A few things to consider:

- What indexes do you have on these tables, and what is the clustered index on each table?

- Have you performed a trace in...

OK, so we have new information, I didn't realize before you were doing bulk loads every minute. How are your disks setup, RAID level etc. How is your...

How long does creating an index on 2 million rows take you? It would seem that trying to query from a 2 million row unorganized heap would almost always...

Do you have another college name in your table that includes the word AND? Just trying to narrow down if your problem is with this one particular college name...

I'm not sure I understand the nature of your question, but the database engine will automatically add space to the file(s) of the snapshot whenever the first time data on...