|
Nov 24 |
answered | Users cannot view tables in non-default schema in SSMS |
|
Nov 24 |
answered | “TASK MANAGER” process is taking over a single-user mode database. What is it? |
|
Nov 24 |
awarded | Autobiographer |
|
Nov 24 |
revised |
Help to create indexes to improve query performance and reduce report generation time added 211 characters in body |
|
Nov 24 |
answered | Help to create indexes to improve query performance and reduce report generation time |
|
Nov 24 |
comment |
Sql Server - Best Practices for Growing Database Files I remove the "AND instance_name = 'database your interested in" so it returns all databases. Then use a count where the log size is a above a threshold in the IF statement. If the count is higher than 1 I do a sp_send_dbmail with a select name statement from the temp table to email the names of the logs above the limit. |
|
Nov 23 |
awarded | Teacher |
|
Nov 23 |
answered | What is Better SQL Server Configuration? |
|
Nov 23 |
awarded | Editor |
|
Nov 23 |
revised |
Sql Server - Best Practices for Growing Database Files deleted 16 characters in body |
|
Nov 23 |
answered | Sql Server - Best Practices for Growing Database Files |