Viewing 15 posts - 1 through 15 (of 19 total)
prem.m38 - Monday, August 14, 2017 7:09 AMWill we get any performance issues by doing this ?? please suggest.
At least you will...
August 16, 2017 at 4:30 am
You can also collect values directly from windows performance monitor: https://www.red-gate.com/simple-talk/sql/performance/collecting-performance-data-into-a-sql-server-table/
August 16, 2017 at 4:17 am
You can try ALTER DATABASE File to modify the name.
There is an example at https://msdn.microsoft.com/en-us/library/bb522469.aspx
To modify the logical name of a data file or...
August 16, 2017 at 3:43 am
sorry, post can be deleted: sys.availability_group_listeners
December 14, 2016 at 10:26 am
https://msdn.microsoft.com/en-us/library/bb522469.aspx
To modify the logical name of a data file or log file, specify the logical file name to be renamed in the NAME clause, and specify the new logical name...
December 12, 2016 at 8:06 am
If you want to automate this process the best way is to configure trust between domains. If you nedd to do this operation once, you can use local account on...
December 12, 2016 at 8:01 am
Hi!
The easiest way is to convert disks to dynamic and make RAID1 for each data array at windows OS level. When synchronization will complete you should delete old drives from...
December 12, 2016 at 5:50 am
tazzman (12/7/2016)
December 8, 2016 at 4:16 am
If you have dedicated SCOM action account for SQL server then you need to give permissions for this account on your witness server. If you use default account, try to...
December 8, 2016 at 3:51 am
If you have same Windows Server versions you can add SQL Server 2016 to the same AG, but when you change primary replica to SQL Server 2016 all synchronization will...
December 7, 2016 at 6:29 am
Looks like there is no way to exclude some of databases from report. But you can increase number of displayed queries in report by editing "snapshots.rpt_top_query_stats" stored procedure (change "SELECT...
December 7, 2016 at 6:12 am
As mentioned earlier, you can remove the object from the cluster. You can use failover cluster manager for it.
You can delete offline object at step 4.
November 20, 2016 at 6:29 am
If you don't need to perform point-in-time database recovery and doesn't use mirroring or other HA-solutions you can use simple recovery model.
November 20, 2016 at 6:13 am
There is not enough information in your message. Is it same group of servers every time? Are they in same domain? May be it is different sql server instances on...
November 18, 2016 at 1:46 am
If you place only database to hosting there is no reason to make an account for audit in database. Because all changes can be tracked correctly only on SQL server...
November 18, 2016 at 1:30 am
Viewing 15 posts - 1 through 15 (of 19 total)