Viewing 15 posts - 181 through 195 (of 389 total)
Hi,
what are you going to reach with this connection.
Do you like to do some t-sql scripting?
There is a visual studio for mac available, sorry, but I find...
December 20, 2018 at 1:32 am
Hi,
this is quite simple:
https://www.brentozar.com/archive/2014/10/send-query-results-sql-server-agent-job/
Brent Ozar did a good job to explain.
Kind regards,
Andreas
December 13, 2018 at 12:37 am
Hi,
there are much samples for your question in this forum and on google.
It depends, if you have got maintenance windows for your server, or if the server is...
December 6, 2018 at 12:26 am
Hi,
I don't understand your question.
Do you think, your table is fragmented?
Did you use a script to get this information?
Kind regards,
Andreas
December 6, 2018 at 12:23 am
Hm,
first 4 hits in google explained it very good:
https://www.sqlskills.com/help/waits/msql_xp/
Try to run the script .
There are some extended stored procedures running in the sql server.
December 5, 2018 at 5:39 am
Hi,
it would be nice, if you can tell us, what kind of solution you find.
Kind regards,
Andreas
November 26, 2018 at 12:05 am
Hi,
what features are you using on the sql server? Only the database engine, or something like SSRS, SSIS, SSAS.
Not every feature is limited with the max memory setting.
November 26, 2018 at 12:03 am
Hi,
do you mean the pagefile.sys?
What kind of OS are you using, how much memory are available for the server, and how much for the sql server?
Do...
November 14, 2018 at 1:35 am
Hm,
what is the version of the sql server and the SSMS?
Are you able to test this from an other sql server / SSMS?
Kind regards,
Andreas
November 2, 2018 at 7:22 am
Hi,
start the dashboard from the "listener", and all icons will be green.
Kind regards,
Andreas
November 2, 2018 at 12:04 am
Hi,
It would be wounderfull, if you put more information in you questions.
Transcational replication, or do you mean always on availibility groups?
Kind regards,
Andreas
October 26, 2018 at 6:41 am
Hi,
It depends on your setup. If you use mirroring with witness-server, the wittness-server knows the state of the mirror nodes. If you don't use a wittness-server, the primary node...
October 26, 2018 at 6:40 am
Hi,
you should take a look on the page from ola hallengren
https://ola.hallengren.com/sql-server-backup.html
Very good scripts for backups, the scripts know, if the node is the primary...
October 26, 2018 at 6:26 am
Viewing 15 posts - 181 through 195 (of 389 total)