I cannot reproduce the problem using SQL Server 2005 Management Studio version 9.0.3042, which is service pack 2.

What is the version of Management Studio ?

Looks like the first time you run the SQL, the database context is unknown but the second time, the context is the user database.

Move the "Use [nagios]" statement before you...

There are 2 solutions as listed below. The second solution using a "convert(convert)" is prefered as it does perform editing and does not rely on the date components having...

"There are definitely times that I think the people that build the system stored procedures and other code we can see don't really work with SQL Server. It seems that...

Finally had time to examine Mark's "not excluded" solution in detail and it produces exactly the same results as the more complicated included solution.

Reference: "Propositional Login" http://en.wikipedia.org/wiki/Propositional_logic%5B\url]

Given Constraints:

1)PersonAddressFromTs <...

"run the normal insert process (from an external app) and to return to the external app. But if the insert required some further processing then I want to be able...

"hemorrhoid" ?

Is that anything like a Vice President, or even worse, the dreaded and feared Partner?

Have the "-c,-m,-T3608 " options been specified as three seperate paramenters? That is

Incorrect:

c,-m,-T3608

Correct:

-c

-m

-T3609

I agree with SSCarpal Tunnel comments that you have created an ugly and non-scalable solution.

"they are mandating that our tables should have identity for primary key "

I agree.

Regarding...

There are 2 temporal designs for how to define a period's end:

1. The end is one time unit less than "next" begin. This is the "closed-closed" design.

2. The...

All in All, I do not see anything significantly wrong with the SQL or the plan. For a dbo.tblDataLogtraceData contains 17,385,758 rows, 45+seconds is not unreasonable.

From your post on...

For the file name only:

select TracesRunning.value as TraceFileName

FROM :: fn_trace_getinfo(default) as TracesRunning

where TracesRunning.property = 2

Try this:

selectCOALESCE (Table1.id, table2.id) as ID

,CASEWHEN Table1.id is null then 'Missing Table1 row'

WHEN Table2.id is null then 'Missing Table2 row'

ELSE'Row exists in both tables'

ENDAS TableRowsMatch

,'UserName ' +

CASEWHEN Table1.UserName...

Q:Which table should come first when we are going to use JOIN ?

A: It does not matter with SQL Server as it will rewrite the query based on "costs". ...

You can use the below SQL to get active trace information including the prefix of the trace file. The actual trace file will have a suffix in the format...