SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• How to Delete an SSAS .ABF File from HDD

  Hello, I have a SQL Server 2016 on a Windows Server 2012, and have made a number of SSAS tabular cu…

  quinn.jay

  2 replies

  8 years, 12 months ago

  By: Lowell

• owner of db file

  Hi, I just checked and the owner of db file of a critical db server is blank, when I set it to sa o…

  sqlguy80

  7 replies

  9 years ago

  By: Steve T

• Upgrade Advisor Errors

  I'm attempting to use the new Data Migration Assistant tool for the first time.  I've used the…

  John Rowan

  4 replies

  9 years ago

  By: John Rowan

• SQL Server 2016 on Windows Server 2016 Listener without a domain

  Configuration:I have setup an AlwaysOn availability group using SQL Server 2016 on Windows Server 2…

  MG-253362

  2 replies

  9 years ago

  By: Perry Whittle

• Query is using new plan suddenly

  I have one query which  is executing two days once, which is executing one day with 58 seconds…

  GA_SQL

  12 replies

  9 years ago

  By: Grant Fritchey

• Licensing High Availability - DR

  HI, Not sure if this is the correct forum but here it goes: We have server A and server B they are …

  krypto69

  4 replies

  9 years ago

  By: krypto69

• User database by database

  HI, I would like a list in T-SQL with : Col1                …

  contact 14920

  1 replies

  9 years ago

  By: Ant-Green

• unable to start services from configuration manager

  Hi Team, I'm unable to restart services from configuration manager... they show that SQL services a…

  atulyan.aries

  3 replies

  9 years ago

  By: atulyan.aries

• SQL 2016 Browser \Advanced \Active

  Hi With  SQL 2016 Browser, in Advanced tab there is an Active Yes/No setting.By default this i…

  sqlguy7777

  1 replies

  9 years ago

  By: Sue_H

• Log Shipping - Exclusive access could not be obtained because the database is in use

  Hi, We have been facing an issue with Log Shipping. Few databases struck in Restoring status. If we…

  Ram:)

  9 replies

  9 years ago

  By: Ram:)

• tempdb shrinking and emptying datafiles

  Hi I found some script online to emptyfile and shrink data files for tempdb. We have 10 data files …

  sqlguy80

  1 replies

  9 years ago

  By: Sue_H

• SQL 2016 - Certification Roadmap

  I am planning to do my first SQL cerrtification. Can anyone please let me know know the roadma…

  balasach82

  1 replies

  9 years ago

  By: Ant-Green

• SQL Server 2016 SP1 Master Data Services UI issues with SilverLight 5 on Chrome & Edge

  I am using a SQL Server 2016 SP1 developer copy on a local machine not AZURE to learn MDS. &nb…

  Peter Heller

  3 replies

  9 years ago

  By: Phil Parkin

• A little tale and a seven questions about SQL partition

  The tale Once up a time a small software shop had a application used Firebird DBMS.The small shop m…

  jcb

  17 replies

  9 years ago

  By: Saurabh.D

• In-Memory Table Alter fails

  Created an In-Memory demo db to play with in SQL Server 2016 SP1, and I am getting a failure each t…

  gkolson

  10 replies

  9 years ago

  By: Saurabh.D