Adam J.R. Erickson

less info
112 reputation
5
bio website
location Seattle, WA
age 36
visits member for 4 years, 3 months
seen Jun 5 at 19:10
Sr. Software Engineer, Total Living Choices.

Jun
5
awarded  Supporter
Feb
20
awarded  Popular Question
Dec
13
awarded  Popular Question
May
14
awarded  Student
May
14
accepted eventcreate with multiline description
May
14
comment Do I need to recreate statistics if I had to drop them to add a foreign key
I have to drop (and recreate) indexes too, but it specifically complained about statistics. Perhaps you've never run into it because you've never had to recreate all the FKs on an already running db. ;)
May
14
accepted Do I need to recreate statistics if I had to drop them to add a foreign key
May
14
asked Do I need to recreate statistics if I had to drop them to add a foreign key
May
10
comment eventcreate with multiline description
I think I copied and pasted. Hitting Ctrl-l did the trick. How would I get that into a batch file, though?
May
10
comment Maintenance Plan Reporting - Append To File - Clean Up?
I thought that just cleaned out the database table that kept track of the database. I have another task set that can find files by extension (e.g. trn) and delete them from a folder if they're X days old. But can that look inside a file and delete backup data that is X days old?
Apr
30
comment eventcreate with multiline description
This doesn't work for me. It's all on one line in the event log with the ^L printed out literally.
Apr
30
asked eventcreate with multiline description
Apr
29
awarded  Scholar
Apr
29
accepted Can you make a SQL Server Maintenance Subplan run after a previous subplan completes
Apr
29
asked Maintenance Plan Reporting - Append To File - Clean Up?
Apr
14
asked Can you make a SQL Server Maintenance Subplan run after a previous subplan completes