Finally near a computer and can post about the Rally last week.

Was my first DBA conference of any sort, other than presenting one time for Jack's group a year and...

I went. There were a number of good presentations. Definitely worth the time spent and all that. Learned more than a little bit.

Your code isn't complete. There are no calculations taking place in what you posted. Arithabort causes transactions/batches to fail if they violate data type rules on arithmetic operations....

The only one of those that's actually correct is that you do have to have a port open to allow SMTP to send the mail. Otherwise, every "feature" they...

cfradenburg (5/10/2011)

---

Eric M Russell (5/10/2011)

---

I'm not sure how many users monitor their guest book or blog posts close enough on a daily basis to notice if one (out of a...

Cool biz.

If you can post any of the code here, we can probably help with the refactoring and performance issues.

Joy Smith San (5/10/2011)

---

Thank you so much. Am clear now. Will go through the books you mentioned.

.......... I am bit worried that you are the only one responded to...

I use the SSMS stats to start tuning before I go into traces. Actually, I use it before I even convert a script into a proc. Gives me...

It sounds more like this is an HP issue than a Windows 7 one. I'm running on Win 7 64-bit right now, and SSMS has no problem with it,...

Here's a sample of how a string parser might look:

IF OBJECT_ID(N'tempdb..#T') IS NOT NULL

DROP TABLE #T ;

CREATE TABLE #T

(ID INT IDENTITY

...

Part of why I was asking about sample data is I'm hoping there's some format to it, like the product codes are separated by spaces or by some other character...

Here's the MS data on PRINT: http://msdn.microsoft.com/en-us/library/ms176047.aspx

The MS article on returning data to a client application (http://msdn.microsoft.com/en-us/library/ms189583.aspx) includes this:

The Database Engine can return information to the caller in one of...

Honestly, if what matters is how they affect salary/hirability, I recommend checking with your employer's HR people about raises associated with certification or other continuing education efforts. Hirability, I'd...

I'll be there Thu/Fri, not on Wednesday though. Could be there for part of Wed evening, if there's an advantage to that.

You probably don't need to use a cursor.

Can you provide sample data? If so, optimized code without overlap errors, et al, is possible.

(Don't get me wrong, Ninja's code is...