GoofyGuy (6/1/2015)

If that's a requirement, but unless you're an ISV providing a solution that is installed at the client's site, then there is no compelling business reason to design an...

You can query the job history from msdb.dbo.sysjobhistory. Here is a link to an article that describes in more detail.

http://www.mssqltips.com/sqlservertip/2850/querying-sql-server-agent-job-history-data/

What is "Line 29", and what is the error message you're getting ?

GoofyGuy (6/1/2015)

I'm curious if/how the 'repeatability' design philosophy includes being able to swop...

I'm not sure what you mean by "removing" addresses from a "list". However, the following example assumes your need is to delete rows from a table where IPAddress is contained...

That's a big part of why I love being a database developer; I rarely get mired in the muck of "why does the code work on X machine but not...

You mentioned above that your update is running within 45 seconds. It's unclear why this would be unacceptable. If you are updating this table multiple times per day, then you...

When it comes to politics, I think they first draw the pie chart to make a point, and then they twist the data to fit the chart.

Before attempting to revover data from a damaged .mdb file, consider that you may still have the option of recoving a previous version of the file intact. From Windows Explorer,...

The following will easily give you what you want, without resorting to a loop. It basically just applies row_number() across a resultset to get a sequential set of numbers, multiplying...

Not just for data scientists, basic statistical analysis can also be incorporated into a database at the operational level. For a dashboard application that monitors ETL processes, I leverage the...

Confirm that both tests, the straight select and then the insert / select, are performed in the same SSMS query window, using the same session and default session settings. Settings...

Confirm is no primary key or unique index with "ignore_dup_key = on" or "instead of" triggers.

Also, what happens if you simply SELECT .. INTO <table> ?

dlsilsbury 63952 (5/28/2015)

Eric M Russell (5/27/2015)

Thanks, I understand this...

The default timeout can be overridden at connection or command level within VB programming code.

http://stackoverflow.com/questions/1354271/timeout-setting-for-sql-server