all the features we are talking about SQL server 2016 are of enterprise edition but for sql server std edition u can only guess

normal trend is that features...

http://www.mssqltips.com/sqlservertip/3090/how-to-find-user-who-ran-drop-or-delete-statements-on-your-sql-server-objects/

check this out it might help u

select DB_NAME(mf.database_id) database_name

, mf.name logical_name

, CONVERT (DECIMAL (20,2) , (CONVERT(DECIMAL, size)/128)) [file_size_MB]

, CASE mf.is_percent_growth

WHEN 1 THEN 'Yes'

ELSE 'No'

END AS [is_percent_growth]

, CASE mf.is_percent_growth

WHEN 1 THEN CONVERT(VARCHAR, mf.growth) + '%'

WHEN 0 THEN...

http://www.mssqltips.com/sqlservertip/3090/how-to-find-user-who-ran-drop-or-delete-statements-on-your-sql-server-objects/

check this out

HI warning Is because u r using the expression in where clause .. avoid that use something else whose output will be same as ur expression or satsisfy u r...

http://www.sql-server-performance.com/2014/trouble-shooting-sql-server-ra-memory-consumption/

Go through this .. its quite a useful for reindexing and update stats .. by my colleague and friend satnam singh

ola's scripts are the perfect . but u can use sql server maintenance plan and few job also to this task. also configure some mannual alerts if the something goes...

index rebuild job on weekend 🙂

get the All SQL server under u r control. check the maintainenace task on all server . ensure valid backups are taking place . and all required acees ...

+100000000

start with this

http://www.red-gate.com/community/books/accidental-dba

Quite useful

have u thought of using sharepoint ?

Yes You are not supposed to create all the indexes. if u create one then there lots of chances are few will become redundant. so analyse them and create one...

Try to login with system admin account and check the permissions of the account you are currently using

http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/124961/

today's post by SSC

see if it helps