Viewing 15 posts - 496 through 510 (of 1,524 total)
We have several databases that the apps folks want refreshed on a scheduled basis. Some weekly and some monthly. Just create a backup job and schedule it and then...
March 5, 2014 at 7:48 am
Sweet Ray..... I found out Reds home game tickets go on sale Saturday morning... I will be getting our tickets then! 🙂
February 26, 2014 at 12:02 pm
Can't wait... although it doesn't seem like Opening Day is close with a wind chill of 1 degree and snow still on the ground here in Ohio.
February 26, 2014 at 9:39 am
Restoring master will give you the logins to SQL Server as well. If you have a ton of them or aren't able to manually recreate them then you need...
February 26, 2014 at 7:52 am
When doing an upgrade from one SQL Server version to another running update stats is kind of critical. The optimizer makes access path decisons based on that and they...
February 26, 2014 at 7:50 am
At minimum Microsoft recommends full update stats when you upgrade... however, I always rebuild the indexes as they recommend that if you have the time.
February 25, 2014 at 6:16 am
Every so often my cleanup job will fail as well with a deadlock. Nothin you can do about it really.
February 25, 2014 at 6:11 am
Same here... some apps they need that elevated privledge to run... you simply have to have it documented that the app requires it. Nothing really you can do about it.
February 25, 2014 at 6:08 am
I RDP into them quite often. Especially if it is late at night and we have an outage window to do major things like Service Packs or a major...
February 20, 2014 at 1:43 pm
Once in a while we will do a snapshot before hand... but.... typically we patch servers a few per month every other month. So far we haven't had a...
February 19, 2014 at 1:08 pm
Luis Cazares (2/18/2014)
Jim P. (2/18/2014)
Markus (2/18/2014)
February 18, 2014 at 9:39 am
Jim P. (2/18/2014)
Markus (2/18/2014)
February 18, 2014 at 9:26 am
jay-h (2/18/2014)
Markus (2/17/2014)
February 18, 2014 at 8:55 am
Funny this article comes up. Saturday I was at my parents house and my Mom said look at this message I am getting on our PC.... she fires up...
February 17, 2014 at 1:46 pm
Service ID for SQLServer will need changed on the Configuration panel...
UserIDs: Need to give that service ID on the new Domain 'sa' rights...
All users using their domain ID within...
February 17, 2014 at 1:42 pm
Viewing 15 posts - 496 through 510 (of 1,524 total)