81 reputation
13
bio website me.com
location Isle of Man
age 34
visits member for 2 years, 1 month
seen Dec 1 '12 at 10:44

Support and DBA SQL server 2008


Sep
11
awarded  Necromancer
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