Viewing 15 posts - 16 through 30 (of 373 total)
Hello,
have you installed the newest version of SSMS?
Have you tried to start SSMS with administrator permission.
Have you tried, to start SSMS without any AddIn? (try to hit the shift-button until...
September 22, 2023 at 7:36 am
Hi,
can you show your t-sql, where the error happened?
Best regards,
Andreas
September 19, 2023 at 5:17 am
Hello,
have you tried to shrink in smaler trunks, like:
DBCC SHRINKFILE(db1_dat,921600);
We had sometime trouble to shrink, if the step was to big. We used smaler "steps", and every...
September 19, 2023 at 5:13 am
Hi,
we got this kind of error as well. We had a lot of domaincontroller. If one of them is in maintenance, or will just reboot, the sql server needs some...
September 12, 2023 at 8:31 am
Hi,
page count 2??
The Ola scripts work from above 1.000 pages.
"
MinNumberOfPages
Set a size, in pages; indexes with fewer number of pages are skipped for index maintenance. The default is 1000 pages....
September 11, 2023 at 12:36 pm
Hi,
I think, these small icons ara just icons in the ssms, I wouldn't care about it.
Do you start the aoag dashboard from a single node, or from the listener. If...
August 15, 2023 at 9:15 am
Hi,
have you tried google?
"Maintenance Plan The Maintenance Plan node is now available in Object Explorer."
Please update your ssms to the newest version, and the error should be fixed.
Kind...
August 15, 2023 at 9:09 am
Hy,
sorry, but I don't understand your question.
The sql server is able to handle a lot of connetions in the same time.
It only depends on your database, the query and a...
August 14, 2023 at 11:13 am
Hi,
we got this error sometimes, and we don't care about it.
I think, the error occours, if the AD controller, the sql server is connect, is in maintenance, and the next...
August 8, 2023 at 12:52 pm
Good morning,
thanks for your answers and your thoughts. I will change the check in sql monitor, so I will not get a warning with an index < 2.000 pages.
So nobody...
August 2, 2023 at 4:53 am
Hello Jeff,
I check the fragmentation with this script, I found some years ago in the internet:
SELECT
dbschemas.[name] as 'Schema',
dbtables.[name] as 'Table',
dbindexes.[name] as 'Index',
indexstats.avg_fragmentation_in_percent,
indexstats.page_count
FROM
sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL,...
August 1, 2023 at 4:51 am
Good morning,
I am able to rebuild this index. And thats the problem, when I could rebuild the index, why wouldn't the Ola script rebuild the index?
I thinks, this is just...
August 1, 2023 at 4:48 am
Hi,
after you restored the database on the new sql server 2019, you may change the compatibility level to 2019.
Otherwise you may not use all the new features from 2019.
On the...
July 3, 2023 at 11:19 am
Hi,
is the SSMS on the same server like the sql server?
And what kind of protocols are active on the sql server?
May 31, 2023 at 10:37 am
Hi,
thanks for your post, you safed my day, maybe my whole life.
It works, and now I am able to support my team.
Thanks a lot,
Kind regards,
Andreas
May 9, 2023 at 1:57 pm
Viewing 15 posts - 16 through 30 (of 373 total)