SELECT AVG(GOAL) FROM dbo.table

WHERE GOAL > 0

I'm pretty sure SQL Express doesn't have the SQL Agent, so it can't schedule automatic jobs..but I've never used it for anything, so I could be wrong.

drew.allen (9/16/2010)

---

Derrick Smith (9/16/2010)

---

r.rozeboom (9/16/2010)

---

all good guys. you all mean well.

But can i do this with t-sql?

i think i forgot to say it has to be done on demand. not...

You could wrap the insert in a try-catch, and then it would at least continue on to the rest of the databases. Then insert the error into a logging table,...

I also disagree with this - completely unnecessary. Prefixing tables with 't' or 'tbl' and stored procs with 'sp'..sure. Columns by their definition are already inside the context of the...

r.rozeboom (9/16/2010)

---

all good guys. you all mean well.

But can i do this with t-sql?

i think i forgot to say it has to be done on demand. not so on surten...

Have you tried stopping and restarting the subscription?

When you say SQL Server Monitor..do you mean the Listener? As in the port it uses for incoming connections? The only Monitor I know of would be a replication or...

Sounds like the account you're running SQL or SSMS under doesn't have appropriate permissions.

Out of curiosity, if you change SQL to run as a local administrator account, does it work?

You need to change the way you're looking at this. Databases don't perform slow - queries do.

This could be due to a multitude of reasons..database contention, memory/cpu pressure, IO contention,...

DCPeterson (9/16/2010)

---

Are the two tables in the same filegroup? Apart from the possibility that the two are on different disks (or arrays) and one is much slower or busier...

Bhuvnesh (9/15/2010)

---

Derrick Smith (9/15/2010)

---

Well DBCC SHOWCONTIG isn't really the best...

Well DBCC SHOWCONTIG isn't really the best tool to use...

Bhuvnesh (9/15/2010)

---

But the above DBCC results show that table is not fragmented and statistics are also updated ( from scan density...

Lowell (9/15/2010)

---

one sleazy way to know if someone opened an email is to have the src of an img tag be processed by a server side script, that was passed...