Viewing 15 posts - 1 through 15 (of 110 total)
Have PowerShell script that repeatedly invokes SQLCMD. Of the hundreds of invocations, a random handful will fail with this error on every invocation of the script. The script is run...
July 31, 2020 at 5:27 pm
Current size on E: drive is shown as 2.02 TB, size to restore on E: is 2.66 TB. Thus you need 0.64 TB of free space on E: (in addition...
August 16, 2019 at 8:19 pm
Yup, all our fault. The trigger ti_Restart_Job was added by the team to handle restarting jobs that are hung, but was not implemented very well. Thanks for help finding the...
August 15, 2019 at 2:44 pm
Great references! I had to do a double take after reading your article and then finding my 4 health logs covered the last two seconds! I am diving deeper now,...
August 15, 2019 at 2:25 pm
Thanks for suggestions. I will reply later with whatever I discover.
August 14, 2019 at 3:29 pm
Yes. Procedures run in indicated times (roughly 2 seconds and one minute) when run directly from query window. Only when run from job is there additional "delay".
August 14, 2019 at 3:28 pm
Is there a reason you are not using SQL Server Management Studio to do your database restore? The GUI provides an excellent interface for point in time recovery, automatically listing...
August 13, 2019 at 9:35 pm
It is the login used by the connection to the instance. Renaming computers with SQL installed can require multiple steps to ensure that SQL is "synched" with the name change.
August 13, 2019 at 2:13 pm
If you are new to SQL, then read about DISTINCT and WHERE parts of SELECT. Happy learning!
August 12, 2019 at 8:47 pm
For context, this appears to be referencing the Ola Hallengren utility code.
August 12, 2019 at 6:12 pm
Yup, I wasn't on the call (IT handled it) but the support response may be because the instance is still on SP1, not SP3 (just guessing on reason).
In any case,...
April 4, 2019 at 2:14 pm
Thanks! Will check and update on progress. So far I know Microsoft said "troll the internet" because SQL 2008 R2 is no longer supported. We may end up just re-installing,...
April 3, 2019 at 2:43 pm
Sounds like a rogue scheduled job that has a hard-coded "sa" password. But could be any service that uses that logon and has an old sa password. Could even be...
November 14, 2018 at 3:00 pm
It is worth noting that if you are using SQL 2016 and above, you can use the built-in STRING_SPLIT function instead of "rolling your own". It is limited to single...
November 1, 2017 at 10:59 am
Replicate to data warehouse, need to be backward compatible with older customers using prior versions of software. So COALESCE old key if it exists, otherwise use IDENTITY (actual case uses...
June 26, 2017 at 2:49 pm