Jeff Moden (4/3/2012)

Microsoft deprecates yet another incredibly useful tool and replaces it with a piece of garbage with much fewer...

i know, in know.... i will eventually get to it. i promise. should be pretty simple since this is still the method i use for my alerting... thanks for the...

thanks for the help everyone. my final code looked like this;

create table #mytable (ID int, StartDate datetime, EndDate datetime)

insert into #mytable

select '239', '05/05/2011','07/21/2011'

UNION ALL

select '239', '10/04/2011', NULL

UNION ALL

select '240',...

ok, ok . sorry guys, crazy morning....

declare @mytable table (ID int, StartDate datetime, EndDate datetime)

insert into @mytable

select '239', '05/05/2011','07/21/2011'

UNION ALL

select '239', '10/04/2011', NULL

UNION ALL

select '240', '06/14/2010', NULL

UNION ALL

select '264',...

SELECT Mirroring_Connection_Timeout

FROM sys.database_mirroring

WHERE database_id = db_id('MyDB')

in any case, its still a good article. I have already added your script to my tool box. The missing column is not too much of a concern to me.

you might want to throw this in your statements too so you can really get an accurate measurement of a difference.

DBCC DROPCLEANBUFFERS

DBCC FREEPROCCACHE

how many rows generally would your nested statement of

Select Location from Actors

where ScreenID= @ScreenID

return?

If table Actors is large and ScreenID is not indexed, as you say, that might...

Nice article, but there is an issue with Windows 2008 and xp_logininfo.

Since my domain is all Windows 2008, the column logininfo_note is always either NULL or xp_logininfo returned error 15404.

The...

ok, i respect both your opinions and thank you for your input.

if that query ran multiple times and you are setting your isolation level to READ COMMITTED, it would explain its 40 minute run time behavior.

depending on how big your Dimension tables are, you could implement partitioning by date.

include is a statement that is used when creating the index.

USE AdventureWorks2008R2;

GO

CREATE INDEX IX_Document_Title

ON Production.Document (Title, Revision)

INCLUDE (FileName);

yeah, the with (nolocks) hints i know to look out for too. Just need confirmation on dirty read behavior.

thanks alot.

this type of environment is actually quite common. the thought process being the application is static, therefore the DB environment should be too.

I usually didn't let it bother me to...