Viewing 15 posts - 9,856 through 9,870 (of 59,066 total)
poratips - Sunday, February 3, 2019 3:32 PMAny other tips?
Do the errors in the log contain a TCPIP address?
February 3, 2019 at 5:22 pm
It would appear that the ID is only unique to the table it is used in and, therefore, would not satisfy a join between the two tables. What, other than...
February 3, 2019 at 5:00 pm
Heh... and all of those scripts appear to be using MSDB, which does you no good at all if the original server(s) where the backups were taken from isn't available.
February 3, 2019 at 4:39 pm
February 3, 2019 at 4:35 pm
We have backup job taken every 20 mins(trn) every 1 hour(diff) and weekly full....
February 3, 2019 at 4:12 pm
Never mind... I did it the other way, too.
-- DROP TABLE #MyHead
--==========================================================================
-- Create the test data
-- (This is NOT a part of the...
February 3, 2019 at 4:01 pm
February 3, 2019 at 2:40 pm
I think a much more difficult thing to do is to convince people that some of the changes they propose (especially when it comes to tools) aren't actually improvements.
February 3, 2019 at 2:13 pm
There was a change in the Cardinality Estimator in (IIRC) 2014. When we made the change from 2012 to 2016, it did nothing for us but make several of our...
February 3, 2019 at 1:55 pm
Then why on this good Green...
February 3, 2019 at 1:06 pm
January 31, 2019 at 7:15 pm
January 30, 2019 at 11:31 pm
Steve Jones - SSC Editor - Wednesday, January 30, 2019 11:02 AMSeems like a not-Jeff day
Heh... more like a "not an SSC...
January 30, 2019 at 10:11 pm
Viewing 15 posts - 9,856 through 9,870 (of 59,066 total)