You should be able to assign the cores to specific instances by setting the processor affinity. Look at the properties of the instances.

Jeff Moden (3/3/2013)

---

Lynn Pettis (3/3/2013)

---

Curious if the following would work in this situation with proper indexing of the target table.

WITH TableA_CTE AS(

SELECT TOP (@TOP_HANDLED_ROWS)

TableAID,

...

Jeff Moden (3/3/2013)

---

Lynn Pettis (3/3/2013)

---

This method requires that the developer understand the date format code and that silent truncation is taking place. Like I said, how many times have...

This method requires that the developer understand the date format code and that silent truncation is taking place. Like I said, how many times have we seen people complain...

polkadot (3/3/2013)

---

Well, if that's all it is, then great. I tend to overblame myself. I was sure it was me.

Well, Joe Celko forewarded the book. I would have...

Curious if the following would work in this situation with proper indexing of the target table.

WITH TableA_CTE AS(

SELECT TOP (@TOP_HANDLED_ROWS)

TableAID,

TableAStatusTypeID,

...

GilaMonster (3/3/2013)

---

aviadavi (3/3/2013)

---

I'm using NOLOCK because integrity is not that important for me and again - I want good timing and i want to avoid potential deadlock by not locking...

You can trying stripping the backups to multiple files and email those separately. You could also look at encrypting the zip file and using something like SkyDrive to server...

First answer, yes. You can only have one mirroring endpoint per instance.

Regarding the second question, from MSDN:

LISTENER_IP = ALL | (4-part-ip ) | ( "ip_address_v6" )

Specifies the IP address...

You would probably get better answers if you asked this on an Oracle forum. This is a Microsoft SQL Server forum.

Yes, but '20130227' is guaranteed to convert from a string to a date in SQL Server regardless of the setting of DATEFORMAT where as '2013-02-27' can be affected...

I would say yes as long a MS doesn't add anything with the same name, then you may have problems.

One, is there a reason you did not provide the entire test of the error message?

Two, just a shot in the dark, but have you checked the permissions on the...

Looking at this but I am slightly confused as to what it is you are actually attempting to accomplish.

Based on your description what you seem to be looking for is...

Decided to up the test to Jeff's normal 1,000,000 row test:

(1000000 row(s) affected)

======================================================================

Now, do the exact same tests adding hard-coding of the calculation

being done with the various functions with a...