"No one suffers meaning that SQL has voluntarily reduced its memory usage and manages with less"

OK, make sense- like as during robbery one asked you for money and you voluntarily...

"the OS will ask SQL to reduce its memory and SQL will do so, down to min server memory at the lowest. No one suffers, this is the best possible...

GilaMonster (3/28/2012)

---

Depends on the memory settings.

If SQL's min server memory is lower than the max, the OS will ask SQL to reduce its memory and SQL will do so, down...

As per BOL:"Members of SQLAgentUserRole have permissions on only local jobs and job schedules that they own."

Therefore: 1) add User to SqlAgentUserRole 2) make User the owner of job

As per BOL: "ISNUMERIC returns 1 for some characters that are not numbers, such as plus (+), minus (-), and valid currency symbols such as the dollar sign ($). For...

Actually you can use:...

Yes, it's possible (as per BOL: "Any column whose data type can be used as an index key can also be specified as a partitioning column, except the timestamp data...

You should use “definition” column (WHERE definition like ‘%your_tbl_name%’) from sys.sql_modules system view as Gail suggested if you would like to find what SP refers to "your_tbl_name" table

It's no so easy-

check this:http://sqlblog.com/blogs/aaron_bertrand/archive/2008/05/06/when-was-my-database-table-last-accessed.aspx

Sorry, but this update statement:

UPDATE OPENQUERY(SUGAR, 'SELECT * FROM bitnami_sugarcrm.accounts_cstm')

SET prospect_c=1 WHERE _PJ_SUGARCRM_LINK.last_order_months>=24

IMO looks a bit confisung, I mean what this _PJ_SUGARCRM_LINK.last_order_months is about?

Or you can use ASCII function to separate upper from lower case letters

Sorry Robert but honestly- not. This is production server and to make snapshot I need RFC, etc- long story. As I already mentioned it's out of my hand now...

DBCC CHECKDB did not work for me with any argument. It's now out of my hand- I only investigated and reported.

I heard another DBA wanted to move this DB to...

Thanks Robert- I'll try and let you know results

Thanks guys for help- I am looking for backup right now