Make an attempt with your own logic and i'll help fill in the gaps.

E.g.

if comparison

begin

send email

end

or maybe this is enough

Ok, now I understand.

Thanks guys!

Yeah that works (See earlier post).

Then the only way to get rid of this NULL character is by selecting LEFT(CounterDateTime, 23).

I haven't been able to REPLACE the CHAR(0) nor have...

Both of there return the same error.

SELECTTOP 1 CAST(REPLACE(CounterDateTime, CHAR(0), '') AS SmalldateTime)

FROMCounterData

SELECTTOP 1 CAST(REPLACE(CounterDateTime, CHAR(9), '') AS SmalldateTime)

FROMCounterData

Msg 295, Level 16, State 3, Line 1

Conversion failed when converting character...

Hi Sean,

Welcome to the party.

Your query returns 0's. Testing for > 0 returns no rows.

This mean the last char is a NULL ??

Returns: 24 783000 (Current row count)

Seems to be the 24th char.

Unless SQL 2012 (Express) auto trims, I only count 23 chars in the original Char(24) column values.

SELECTTOP 5

CAST(LEFT(CounterDateTime, 23)...

Returns all rows.

I'm thinking its a regional problem.

Trying to convert 2013-08-31 to 2013-31-08.

If tried some combinations of SET DATEFORMAT to no avail.

The only thing that seems to work is converting...

Hi John,

Thanks for taking the time to reply.

Table has some 766k rows and counting.

I don't think it has anything to do with the CASE statement.

Even this results in the same...

http://stackoverflow.com/questions/8229989/bulk-insert-w-fmt-file-operating-system-error-code-null

States that the .fmt file needs a blank line at the end.

Though when I try it i get even more errors.

Msg 4832, Level 16, State 1, Line 1

Bulk load: An...

Great blog!

I've been doing the same this last year. Reading, watching, testing.

Working great so far, but really miss having someone to brainstorm with.

Posting on forums can be slow going and...

Looks like we're in the same boat.

I'm also looking into reducing OLEDB waits.

Here are some links I've found that might help you out.

http://www.sqlservercentral.com/blogs/sql_server_dba/2011/10/15/sql-wait-type-_1320_-oledb-and-how-to-reduce-it/

http://www.sqlservercentral.com/blogs/kyle-neier/2008/12/03/oledb-wait-stats-in-sql-server-2005/

http://www.dbadiaries.com/the-oledb-wait-type-and-how-to-reduce-it

http://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/

I'm pretty sure my OLEDB waits are caused...

Thanks. Glad you like it. 🙂

Sorry for bumping a really old post...

I've been looking into this for a while now but have not managed to find much info.

http://msdn.microsoft.com/en-us/library/ms152482.aspx

States that it should be running continuously.

http://sqlmonitormetrics.red-gate.com/disabled-replication-jobs/

Explicitly ignores...

Lynn Pettis (5/7/2013)

---

First, I don't think your question is really about why is the index on the view being selected as much as why the first query generates 5 index...

Ok. Thanks for the education guys. 🙂