First, eliminate all suspicious things and make smallest possible test example.

E.g. create oracle table with just one varchar2 column and populate it with data (or find one, or select just...

CTE is needed only if you have recursive query or a query that calls a subquery/inline view more than once.

All other cases (such as this one) do not need to...

You do not have to use regular expressions.

You can:

1) separate sentence into words (by space for example),

2) match words with your custom dictionary of words with factors

3) return matched word...

DTG numbers are wrong.

Being too dynamic is not a good thing. It has it's pitfalls.

If you can solve something with static sql, do not use dynamic sql.

If you absolutely cannot avoid dynamic sql,...

What you really need is to insert end-of-moth records where they do not exist.

It's not that hard once you have so called "calendar" table with end dates of each month...

You should use CROSS APPLY because you can't specify other table column as a table function argument you are joining with:

;WITH CTE AS

(

SELECT 1 AS AID , 0 AS Depth

UNION...

What you really need is this result:

SELECT blank_mid.HNum, blank_mid.DTG, has_mid.mID, blank_mid.filterKey, blank_mid.EQuipIndex

FROM #TableA blank_mid -- Per each row with blank mid...

JOIN #TableA has_mid -- ...find a row that has mid.

ON...

They are just assuming or they presented you a proof or measurement (error log, monitor report etc) that clearly shows connectivity is the problem ?

Google for sp_whoisactive from Adam Mechanic....

Ignacio is right:

- Use UNC path (\\servername\sharename\subfolder)

- SQL server service account (the sql agent account is NOT enough!)...

ISDATE() uses LANGUAGE and DATEFORMAT options to tell is something a date.

SET LANGUAGE english

SELECT ISDATE('2011 jan'), ISDATE('2011 gen') -- yes, no

SET LANGUAGE italian

SELECT ISDATE('2011 jan'), ISDATE('2011 gen') -- no, yes

Language...

Experiment with UPDATE TOP(n) as Matt suggested (n between 100 and 10 000), and with OPTION(MAXDOP m) where m is between 1 and 10. You wait info says "your disc...

Good point, Craig! Transaction log backup really is more powerful than plain incremental backup!

Gsquare, excellent signature :hehe:

If you need to update more than 50% of the table rows (your table has 480 mil rows and you want to update 477 mil rows - almost every row!),...