you can query sys.dm_os_performance_counters, looking at user connections and/or logins per second. Based on these values you could send an email.

I sample these and other metrics every 15 minutes and...

Steve Jones - SSC Editor (8/22/2013)

---

Don't get caught up in the politics here. This isn't a debate over government collecting data. The point in the editorial was about research and...

you should first define your CTE as a monthly aggregation (sum(Amount) group by month EMPlyee#)

the your final query is just:

SELECT {emplyee #, Name, etc.}, total=SUM(Amount)

group by {emplyee #, Name,...

I might suggest having a small control table for this job.

Set up the job schedule to run @ 9:30 and every 10 mins for as many retry intervals...

I assume you have tested the ODBC connection manually with the ODBC applet? Make sure that the service account that the instance is running as has permission on the...

What I have done in the past is to have the broker request procedure write a request row to a separate table then send the ID of the row into...

Correct....

If the heap and the clustered index both start out completely empty with no data page allocations the heap inserts will be faster. Beyond that, as Grant stated, there...

Think about it: there is going to be more overhead inserting into a table with indexes Vs one with no indexes.

You could set up a SQL Agent job that triggers at a certain time or at even at fixed intervals. Another methodology I have used is just a stored procedure...

Your question is to too general to give you specific advice. Replication can have so many different topologies, design goals and performance requirements it is not logical to provide recommendations...

Minimizing the network throughput for one... the whole query can be run in the engine and potentially be better optimized. Faster query results & better scaling.

Yes it is possible to create the table ahead of time. If your create the subscription you should be offered the option of not creating the snapshot.

Yes, you can set up the replication of the new article without doing a snapshot. Create the table first then populate it yourself, or do it later when you have...

By not working do you mean not updating any rows? If that is the case it would be because none of the rows have Branch='NG26' and logindate='2013-08-07'. If...