Viewing 15 posts - 1 through 15 (of 6,595 total)
What's wrong with a simple ALTER INDEX cl_ix ON schema.table REBUILD ... ? ( as that does not impact the non-clustered indexes )
Keep in mind this will also interfere with...
September 19, 2019 at 9:38 am
replay the deadlock with SentryOne PlanExplorer (free) ! It shows what is happening and causing the deadlock !!!
btw: this is the...
March 28, 2019 at 1:12 am
I would suggest BOL : https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/failover-and-failover-modes-always-on-availability-groups
Try to break it in your DBADEV environments, then figure out what and how to fix it. #YourMindIsYourStrength
March 12, 2019 at 4:55 am
Shrink file is the better choice because of its scopeKeep in mind you need to rebuild all indexes in that file after your shrink datafile ( not log )...
March 12, 2019 at 4:50 am
With SQLServer 2017 or the current Azure SQL Managed Instance, you also need to set configuration clr strict security to 0 ! ( it is 1 by default !!...
January 18, 2019 at 12:52 am
did you perform full database maintenance after the upgrade to the new engine ?
You've seen the "missing index", right ?
January 10, 2019 at 8:26 am
What's the cluster service account ? Does it have AD auth to register computer objects ?
January 9, 2019 at 2:47 am
You have to register the Listener computer object in AD yourself and grant the cluster computer object full authority to manage that listener object !
January 9, 2019 at 2:22 am
I always configure it using Powershell.As marked: did you restart the cluster resource to enable the listener ?
# create listener with default DHCP$NewAGListener =...
January 8, 2019 at 11:57 pm
can you find any information in the SQLServer Errorlog file or in the cluster logfile ?
January 8, 2019 at 12:24 am
" ... just installed an instance of SQL 2017 and restarted the server.... " chances are, that may have reset the folder / file permissions.
January 7, 2019 at 8:24 am
January 7, 2019 at 5:09 am
Could you elaborate why these databases would be in recovery pending state ?Apparently the SQLServer service account cannot access the folder E:\Databases
January 7, 2019 at 3:09 am
How did you configure the listener ? ( TSQL / Posh script please )Check your cluster logs !
January 7, 2019 at 2:44 am
what seeding setting do you currently have on your AGs ?I've set it to "manual" once I have my AGs in a fucntioning state.
November 28, 2018 at 1:51 pm