SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• Migrating MDS model individually using MDS UI

  Hi All,   Is there a way i can create package for an individual model from MDS and then import…

  jaango123

  1 replies

  1 week, 3 days ago

  By: jaango123

• Perfomance in views

  Hello, I want to ask you about the following case that I live with a company in my country. They ha…

  rusbel.rubio

  3 replies

  2 weeks, 3 days ago

  By: EdVassie

• Unknown Token Received From SQL Server

  I have an issue when a stored procedure is executed from the SQL Server Agent it fails with the err…

  RonMexico

  17 replies

  3 weeks, 4 days ago

  By: mightierthor

• KB5046856 fails to install

  Hello experts, The following SQL update is failing to install on some of our SQL Servers with the f…

  webrunner

  3 replies

  3 weeks, 4 days ago

  By: Perry Whittle

• Tempdb issues

  Thanks for the assistance in advanced.... i am trying to create my temdb with 4 data files and one …

  DHeath

  11 replies

  3 weeks, 6 days ago

  By: Michael L John

• Availability Group Latency Check

    How can I check if there is latency between primary and secondary on SQL Server 2016. Are th…

  sizal0234

  2 replies

  1 month ago

  By: Srinivas Merugu

• SSMS 2016 Default Open + Save Path for Scripts

  I finally found the settings in the registry and ssms.application.pkgdef file to get the default pa…

  Ingo

  12 replies

  1 month ago

  By: Ahr Aitch

• Over period of time application stop connecting to AG database

  Hello. SQL version - 2016 , windows 2019 both are enterprise edition Over period of time applicatio…

  SQL Galaxy

  9 replies

  1 month, 3 weeks ago

  By: SQL Galaxy

• SQL Clustered Resource in online pending for about 3-5 mins before coming online

  Hello! SQL Clustered resource used to come online during manual or automatic failover in less than …

  PJ_SQL

  2 replies

  1 month, 4 weeks ago

  By: EdVassie

• ADSI Query Issue for Remote Connection Not Working After Laptop Change

  So I have a DB on a remote server I do ADSI queries into AD with.  The queries work when on my old…

  robert.steele 53480

  4 replies

  2 months, 1 week ago

  By: robert.steele 53480

• Possible SQL 2014 to 2016 Issue - Some Application Functions Slow/Failing

  First time here...hoping I can find some direction and answers so I can devise a proper solution. N…

  Allenii02

  5 replies

  2 months, 3 weeks ago

  By: Jeff Moden

• Tracing a performance issue

  Hello, We have a SQL agent job that runs daily. It runs a procedure, which for the purposes of this…

  as_1234

  9 replies

  2 months, 3 weeks ago

  By: Michael L John

• Import Extended Events XEL File ?

  I have a 300 Meg .XEL file from an Entended Event session that I used recently. I stopped the sessi…

  homebrew01

  10 replies

  2 months, 3 weeks ago

  By: pietlinden

• Backup issues

  I''m running a stripped backup (2 files) to a Network share. It's a 32gig machine in which 10gig fr…

  Bruin

  7 replies

  3 months ago

  By: Bruin

• Tempdb is filling due to background process.

  I have it narrowed down to which session id is causing the issue, but that session is a background …

  KTLO_DBA

  7 replies

  3 months, 1 week ago

  By: Grant Fritchey