Is there a SQL Agent job that runs at startup that creates the trace?

If the trace definition is still in sys.traces then the trace definition is somewhere.

It is in the default trace as an Object:Altered event with an object type of 16964 which is database. The default trace doesn't tell you that the alteration was...

There are a few things that would make this easier to help with:

1. Execution plans for each query

2. The code for dbo.fn_cti_convertardatetime

3. The schema for the tables...

In addition to what Lynn has shared, the answer depends on:

how good the DBA is at automating things

are you willing to put into place and pay for a third-party monitoring...

I agree with what Luis and Alan have already shared. Anything that requires ordering (the distinct and order by) can spill to tempdb.

Also logically your query is...

So, the first thing is that in this situation you absolutely want to set the Max Memory for the database engine, I can't recommend a value because I don't know...

I believe you can catch that error by wrapping the SP call within a TRY CATCH.

If you are dealing with a linked server you can also use sys.sp_testlinkedserver to check...

First off, I want to be clear that I haven't had to deal with this issue, but a quick search showed this page in BOL, http://technet.microsoft.com/en-us/library/ms152757(v=SQL.105).aspx which has this...

Looks like you want a CROSS JOIN.

I'd provide the code, but I think you'll get more by reading the link above and coding it yourself.

pwalter83 (7/4/2014)

---

Hi,

I need a code for a split function that can also handle double quotes in values along with the usual commas. Could anyone please help in this regard ?

I...

Can you share the Split code?

Have you verified that the split function is returning what you expect?

When you pass in a single value using the Split...

Michael Valentine Jones (7/3/2014)

---

GilaMonster (7/3/2014)

---

Do note that using functions on the columns like that prevents any index seek for that predicate.

If that column is a date, then:

SELECT

dbclaimcnt, dbclaimentered

FROM

EPSClaimsUOA

WHERE

dbclaimentered...

Looking at the SP it looks like you were on the right track to fixing the issue with the dbo.Split() function. When passing multi-value parameters to an SP you...

Another often used solution to something like this is to have a calendar table with a schema similar to this:

CREATE TABLE dbo.calendar

(

theDate...

I think we need more details to be able to provide any kind of help.

If I understand correctly you have a package variable (in the parent package?) the is being...