Steve, spam deletion in a good thing, but preventing spam is better in my opinion.

I just registered to the site with one of my addresses and it simply asks to...

I think it might have to do with the bitness of the client.

VS runs the x86 version of the client (which you don't have, since I posted the link for...

Then you need a JOIN.

WITH Query1 AS (

Select col1, col2 from Tb1 where col4=''and col5='' and col6=''

)

, Query2 AS (

select col14,col5 from...

SQL Server itself.

I use the built-in Data Collector for most of my monitoring.

It can be easily be extended using ExtendedTSQLCollector

You need UNION ALL

Select col1, col2 from Tb1 where col4=''and col5='' and col6=''

UNION ALL

select col14,col5 from tbl3 where col2='f' and col6='4'

UNION ALL

select col17,col8 from tbl3 where col1='sd' and col3='6'

The Oracle 9 client is not available since 2010 if I recall correctly.

You can use newer versions of the client to connect to older server versions.

You can download the Oracle...

Ed Wagner (11/17/2014)

---

Steve, let me know if you'd like help...

Here is the script I'm using:

http://www.sqlservercentral.com/Forums/FindPost1002319.aspx

zedtec (11/17/2014)

---

Thanks for that.

Unfortunately I didn't collect the wait statistics. I will check next time and also see how full the cache gets before it causes slow performance in order...

Sorry, I haven't answered your questions.

Here you go:

There is no limit. A...

2 GB is not too bad. At least, not something able to bring your instance to its knees.

It was worth investigating though.

Did you capture the wait stats?

Duplicate post.

Replies here please: http://www.sqlservercentral.com/Forums/FindPost1635433.aspx

During the weekend the spam rate was so high that it came in faster than I could report it.

Some things come to my mind:

1) Isn't there a captcha for registration?...

In my experience, scaling out the reporting workload to the secondary is a very sleek process that saves lots of headache.

I've never had issues with that. It just works and...

I would monitor the memory clerk usage instead of a perform counter:

SELECT TOP(10) [type] AS [Memory Clerk Type], SUM(single_pages_kb) AS [SPA Mem, Kb]

FROM sys.dm_os_memory_clerks

GROUP BY [type]

ORDER...