Viewing 11 posts - 1 through 11 (of 11 total)
Or could be something like this:
EXECUTE dbo.IndexOptimize
@databases = 'ALL_DATABASES',
@StatisticsSample = 100,
@FragmentationLow = NULL,
@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationLevel1 = 50,
@FragmentationLevel2 = 80,
@UpdateStatistics = 'ALL',
@OnlyModifiedStatistics = 'Y',
--@SortInTempdb = 'Y',
@LogToTable =...
January 6, 2021 at 8:16 pm
You can follow steps from https://datamigration.microsoft.com/scenario/sql-to-sqlserver?step=1 just using DMA to move logins and everything, not just database.
May 15, 2019 at 6:11 am
September 26, 2018 at 11:12 am
You should not drop users as dbo because is a system default user created for all dbs and sa is mapped to most of dbo objects all sysadmins users needs...
September 26, 2018 at 9:49 am
Could be the same case migrating some dbs from 2014 to 2017?
July 23, 2018 at 11:40 am
you can use Olla Hallengren maintenance solution not just for backups https://ola.hallengren.com/sql-server-backup.html
February 7, 2017 at 10:53 am
My boss want to migrate to sql 2014 currently we have another site and he wants to create a DR using AlwaysOn AG what do you suggest to do?
Actual configuration...
January 29, 2015 at 11:07 pm
You should use http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html and schedule for run weekly or dayly for keep your used objects updated
April 23, 2013 at 6:34 am
You can use a tirad party tool like dos exchange from http://www.pragmaticworks.com
September 25, 2012 at 12:57 am
could be this useful for recover a dropped column or only for tables and database objects?
June 12, 2009 at 4:15 pm
Viewing 11 posts - 1 through 11 (of 11 total)