jferrel-1093506 (1/14/2010)

---

True Lynn, I have not read much else on SSC.... but as disgusted as he is about customer support, I can equate that to me having to wade through...

jferrel-1093506 (1/14/2010)

---

I get a SQL ServerCentral.com about once every week or so, but never read it.

Then I read this because of the catchy title, and its a rant about a...

Take a look at "sys.dm_exec_sessions" in Books Online.

Here's a sample query that might get you started:

select *

from sys.dm_exec_sessions

where status = 'running'

and datediff(minute, last_request_start_time, getdate()) >= 5;

You could set up a separate process that would run every five minutes, look for long-running queries, and alert you to them. There isn't a way that I know...

I've got a short list of companies that I refuse to do business with over similar situations.

Best Buy: I ordered a product from their web page that said it was...

You're welcome.

One index with both columns will almost certainly be better. The order for them in the index will depend on how often you just use one or the other...

Change:

DECLARE curCSDOrderedByCttrLoanIPTMAXValue

cursor for

to

DECLARE curCSDOrderedByCttrLoanIPTMAXValue

cursor local fast_forward for

You're just adding the two...

If you look at the bottom of the script I posted, there are commands commented out that will stop the trace, query the trace, get rid of the trace, and...

I use the bold tags for that.

lmu92 (1/13/2010)

---

@Gus (again): Another thought:

If you'd add AND (@Sum & power(2, Number)) > 0 to your WHERE clause in the Rules CTE you'd get rid of the repetitive Col1=@Col1...

lmu92 (1/13/2010)

---

@Gus:

Just as a side note: AFAIK varchar(max) columns tend to have a bad influence on performance due to the handling of more than one page (8k).

I guess, varchar(8000) will...

Take a look at this, see if it gets you going in the right direction:

if object_id(N'tempdb..#Options') is not null

drop table #Options;

create table #Options (

Val int primary key,

RuleStr varchar(max) not null);

insert...

It looks to me like all this does is create an ascending number partitioned by certain columns in the data set. Is that correct?

If so, then SQL 2000 doesn't...

Okay, why not just test for a negative? Or reverse the logic?

If you really need a statement that does nothing at all, you could assign a variable to itself,...