There probably are ways to tune it. You'll need to start by providing definitions for what it's pulling from. Looks like at least one view and maybe some...

If it says they are in use, that means the traces are still running. You'll need to turn them off.

Definitely don't truncate the log file. Didn't even notice that in there.

Steve: I have to ask, why not use maintenance plans? I've found them very reliable and easy...

I'll go with the single-table solution, with specifics beyond the base-address in the join tables (suite/appt number, etc.), as well as having types in the join table (billing, residence, legal,...

XML disappears when you post it in the forum. Works best if you save it in a text file and attach that to the post.

I didn't actually change any of the joins, I just moved them around so they each table joins to the table immediately before it in the list. Doesn't affect...

You might be able to get some performance improvement out of something like this:

declare @MinWeight float

select @MinWeight =

ceiling(

dbo.GetLargerDecimal(

@Weight,

dbo.GetMinWeightForService(

@incentiveServiceID ) ) )

select top 1

@serviceIncentiveType =...

Create a table of months, join it to the two tables, where join date is less than the end of the month, and leave date is either null (hasn't left...

Change the final Where clause to allow for 5s.

The point of the query is that a Numbers table allows you turn the data into rows instead of instances in a...

Chris (2/12/2009)

---

Some aren't impressed by the consensus among climatologists across the globe. So for their benefit, here are just a few organizations and reports with statements concurring with the conclusion...

Use the same solution, but use a derived table in the From clause instead of a CTE. The final query just changes to:

select distinct Day

from

(select (number-1)/24 + 1...

Did someone delete the directory while it was installed? That's what it sounds like.

You'll probably end up having to manually edit the registry to get this one to work....

Do you have a full text index on the string?

Why can't you use "like"? That's the most obvious and easy answer.

Or is this a homework question and you're being...

Bert (2/12/2009)

---

jcrawf02 (2/12/2009)

---

GSquared (2/12/2009)

---

Bert (2/12/2009)

---

GSquared (2/12/2009)

---

Sounds like we all agree on this, at least on the parts that matter. Now, our job becomes, to convince others to agree. ...

Join the table to itself in a query where the record numbers don't match, but either the ID1, ID2 or ID3 do match.