Thanks to all involved who had a look at this.

For closure: We tracked the issue down to query store consuming more resources than what we would have liked....

In a perfect world MDW would be nice, but there will always be a couple of 2005 and/or 2000 instances floating around...

Thanks Gail.

Well worth the read!

dwilliscp (1/24/2012)

---

Thanks for your imput.. they are trying to keep Very small log files. I guess the forecasting software must create batches of large changes, when someone re-forecasts or makes...

Please read the article below for more information:

http://www.sqlservercentral.com/articles/Administration/64582/

Sorry, the only other thing I can think of is using RANK() instead of ROW_NUMBER().

Sybase also has window functions. See below:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc38151.1510/html/iqrefbb/BCGEEBHA.htm

Or are you trying to add the row numbers in SSRS?

Will this work?

ROW_NUMBER() OVER(PARTITION BY <Market> ORDER BY <sorting column>) AS 'Row Number'

Will this work?

CASE WHEN RISK >= 8 THEN DATEADD(DAY, 30, VULNDATE) ELSE DATEADD(DAY, 90, VULNDATE) END AS DueDate

EDIT:

">=" in the case statement...

Yes, either that, or re-install 🙁

Very strange. Just installed on my machine & it's listening on IPV4 as well.

Only other thing I can think of is SP1?

Can you confirm, via the Configuration manager, that SQL is listening on that port for IPV4?

Have you tried restarting the browser?

Hi,

See if this helps:

http://msdn.microsoft.com/en-us/library/ms177440.aspx

Guessing here...

Maybe a tape backup agent?