542 reputation
1413
bio website members.virtualtourist.com/m/…
location Palma de Mallorca,Spain
age 38
visits member for 2 years, 7 months
seen 21 hours ago

SQL addict, trying to get insights of DBA tasks, mountainbiker


Nov
26
asked databases cross references baselines
Nov
11
comment Getting Time Duration
If you're using SQL Server 2008R2 my advice is to retag the question so it gets answers for that particular version. Maybe some solution could apply just to 2012 or above for example.
Nov
11
revised Getting Time Duration
code formatting improvements
Nov
11
suggested approved edit on Getting Time Duration
Sep
30
comment MySQL backing up MyISAM tables by copying the physical files - and automating the process
Have you checked the related questions recommended to take a look when you created the question? There are couple of them that I think will answer your question, with plenty of details and scripts to test. Copying database files from one location to another seems not the right thing to do.
Sep
25
comment Disabling certain steps in a job
You are now talking about a different thing, stopping jobs, not preventing steps inside of a job to execute. My advice, choose from the answers the one that solves your current question, check it as correct answer. Then create a new question with the new scenario, maybe using the comment you added on the other answer.
Sep
25
comment Reading a SQL Server Execution plan
Before doing anything else, download SQL Sentry Plan Explorer it will really help a lot into looking execution plans and analyzing them more thoroughly
Sep
24
comment Disabling certain steps in a job
Question was about not running one particular step of a job and as example the OP mentioned not running 1st one. Is as easy as taking that one and changing the order to, say 9, on my example. Then which used to be 2nd, now is the first...easy peasy. With my answer you can leave out of the job as many steps you want without the need of creating more jobs, deleting steps or whatever.
Sep
24
answered Disabling certain steps in a job
Sep
24
answered How to delay replication start
Sep
24
revised How to delay replication start
small code correction
Sep
23
revised How to delay replication start
corrected smal bug code
Sep
23
revised How to delay replication start
added more details on question body
Sep
23
asked How to delay replication start
Sep
18
revised Unable to SQL => Getting content of last 7 days
code formatting
Sep
18
suggested approved edit on Unable to SQL => Getting content of last 7 days
Sep
16
accepted Lower performance on newest servers
Sep
5
comment Monitor SQLAgent
@Shanky, useful comment, similar to Kin answer, but different on how to send the email. Will test it though, to have a different solution available.
Sep
5
comment Monitor SQLAgent
Thanks, the last part of checking the checkboxes for autorestart was already done. But first recommendation to restart service in case of failure was not. Hope not to get same problem with this configuration.
Sep
5
accepted Monitor SQLAgent