Viewing 15 posts - 16 through 30 (of 1,523 total)
It seems that it is changing. With a more automated cloud version that you click, click, click and it installs it for you, automatically backs up and patches your SQL...
March 4, 2022 at 1:23 pm
I have seen some databases with two transaction log files. One on one drive with a max size and another one on a different drive. The reason for this as...
February 8, 2022 at 3:51 pm
run the select @@version and it will tell you which version you are running.
Are you meaning that when you look in Add/Remove Programs you still see things that say SQL2016?
September 27, 2021 at 8:13 pm
Is the data sort of static during your DBCC run? Do you do mass loads or deletes during that timeframe? I would suspect your encryption process is causing it.
September 3, 2021 at 12:18 pm
I guess I would be interested in knowing HOW the numbers of which versions running SQL Server were determined. Is it a survey, some type of inventory data upload to...
August 16, 2021 at 5:32 pm
In the future to help you with what are these are tables... in the past one thing that has helped me track that answer down is in Mgt Studio, click...
July 15, 2021 at 12:36 pm
Yea. He is running the show, I was just asked to look at everything and give my recommendations from a true DBA prospective. He 'wants' that debug feature for whatever...
June 24, 2021 at 4:27 pm
Thanks for the info. I spoke with the guy that has maintained that server and he said from his workstation it works, just on the server it is not. He...
June 23, 2021 at 3:23 pm
Great. Thanks for your help with this. The SSMS is actually installed on the DB server, sorry, I forgot to mention that specifically.
June 23, 2021 at 2:45 pm
One other thing is that all of the files should be sized exactly the same and have autogrowth set to the same size. I personally would have the autogrowth way...
June 14, 2021 at 1:03 pm
Cars are ever evolving. To me about 2008 was the best of the best for automobiles, right before very heavy computerized and electronized everything became. To me the keyless and...
June 2, 2021 at 7:51 pm
You cannot backup/restore master, model, msdb into a newer version of SQL Server. You have to script out all your users, jobs, etc and put them into the new one.
February 8, 2021 at 3:46 pm
Yes, at work we were TOLD many times lock your PC when you leave your office. The group policy is the catch all. Granted, it won't stop all eyes and...
January 13, 2021 at 3:44 pm
Many places now have a group policy that when a PC goes inactive for 5 minutes it will automatically lock.
January 13, 2021 at 1:00 pm
It does seem crazy that you have to have ADMIN rights to monitor systems doesn't it? The different operating system developers need to come up with a way to view/capture...
January 6, 2021 at 9:20 pm
Viewing 15 posts - 16 through 30 (of 1,523 total)