Steve Jones - SSC Editor (7/25/2012)

mtucker-732014 (7/23/2012)

My recent experience was a rating in which my manager told me (and was obviously embarrassed to do so) that the reason he wasnt...

The first step in accomplishing anything (except by luck), is deciding exactly what it is that you want. If someone asks you to "create a table", is that enough...

Is there an Alert set up on the job? If one or another of the steps fails, it might try to send an alert, and that uses sp_send_dbmail on...

If you check sys.server_principals, you'll see a "default_language_name" column in there. Changing logins changes some defaults based on that, if I'm not mistaken.

If they're strings, something like this is what's needed:

WITH Parser

AS (SELECT *

...

Combining what? Two IPV6 addresses?

First, are they already in HEX format, or are they strings? That determines a lot...

I found a bechmark test here: http://www.8088.net/blog/index.php/2011/01/24/iops-comparison-solid-state-drive-ssd-15000-7200-5900-5600-rpm/?lang=en#chart

I haven't done 15k vs SSD in a database environment, but on every machine I've ever tested on, SSD and platters just aren't comparable....

Default date format is probably the problem. German default is DD-MM-YYYY where English is MM-DD-YYYY. If the date column isn't stored as DateTime (or one of its variants)...

Let me make sure I get the sequence here:

1. Convert Address to HEX (using what? ASCII values? some hashing algorithm?)

2. Convert Net to HEX (same question)

3....

Lynn Pettis (7/23/2012)

GSquared (7/23/2012)

You'll need to look at the Oracle documentation for that....

Are you just trying to Select the correct salesperson from your orderheader__c table, or do you want to actually update your opportunity table? The query is just a Select,...

You'll need to look at the Oracle documentation for that. This website...

Run a trace on the server you're getting the error message from. Either Profiler or server-side, doesn't really matter which. Then run the problematic job. You should...

You have typos in your commands. "se;ec" should be "select", and "creat" should be "create". At the very least, you need to fix those. Try again after...

The main thing I look for is the same thing I do when I'm either side of a job interview. I do what's called a "two-minute psychometry". It...