Viewing 15 posts - 7,186 through 7,200 (of 14,953 total)
jferrel-1093506 (1/14/2010)
January 14, 2010 at 11:08 am
jferrel-1093506 (1/14/2010)
Then I read this because of the catchy title, and its a rant about a...
January 14, 2010 at 11:06 am
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;
January 14, 2010 at 8:48 am
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...
January 14, 2010 at 8:27 am
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...
January 14, 2010 at 8:08 am
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...
January 14, 2010 at 6:51 am
Change:
DECLARE curCSDOrderedByCttrLoanIPTMAXValue
cursor for
to
DECLARE curCSDOrderedByCttrLoanIPTMAXValue
cursor local fast_forward for
You're just adding the two...
January 13, 2010 at 2:46 pm
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...
January 13, 2010 at 2:44 pm
lmu92 (1/13/2010)
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...
January 13, 2010 at 1:43 pm
lmu92 (1/13/2010)
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...
January 13, 2010 at 1:40 pm
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...
January 13, 2010 at 1:04 pm
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...
January 13, 2010 at 12:31 pm
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,...
January 13, 2010 at 11:25 am
Viewing 15 posts - 7,186 through 7,200 (of 14,953 total)