SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• What does it mean when Query Store Tracked Queries shows the same Plan Id twice?

  I'm investigating a query which sometimes performs badly and, when I locate one of the query instan…

  StarNamer

  6 replies

  6 months, 2 weeks ago

  By: Johan Bijnens

• User permissions and showplan

  All, I'm trying to find a way to let some of our users see at least some details of a query plan pa…

  as_1234

  3 replies

  6 months, 2 weeks ago

  By: cyrusbaratt

• Failover Clustered Instance (FCI) how to unconfigure from cluster to standalone

  Hi All, We have 2 x physical servers with windows server installed connected to a SAN via iSCSI. We…

  MMSQL99

  5 replies

  6 months, 2 weeks ago

  By: cyrusbaratt

• Table partitioning best practice

  I've inherited a couple of rather large databases from my ex-colleague when I join this company. To…

  JasonO

  7 replies

  6 months, 2 weeks ago

  By: cyrusbaratt

• SQL server native CDC

  Have anyone implemented CDC, and if so, what has been your experience with it? We are considering u…

  SQL_Surfer

  3 replies

  8 months ago

  By: Perry Whittle

• SQL Server Time Outs within the application

  I have a situation where our application has sql timeouts set to 120 seconds. SQL Time Outs occur e…

  ericwenger1

  2 replies

  9 months ago

  By: Jo Pattyn

• Creating New Version of a Database

  Hello, I am interested in creating multiple versions of an existing database.  For example, lets s…

  rjjh78

  3 replies

  9 months ago

  By: ScottPletcher

• emergency!!! RecoveryPending how to fix it?

  How to fix Recovery Pending State in SQL Server Database,please help

  juliava

  8 replies

  9 months, 1 week ago

  By: Jeffrey Williams

• SSRS email via Subscriptions

  All, Getting this error: Failure sending mail: The remote certificate is invalid according to the v…

  dbigelow123

  4 replies

  9 months, 1 week ago

  By: cyrusbaratt

• DBCC CheckDB errors

  How can I identify automatically(like email alert if error shows up) through code if DBCC check db …

  mtz676

  8 replies

  9 months, 1 week ago

  By: cyrusbaratt

• What is the \"from\" email used for msdb.dbo.sp_notify_operator?

  Hi, folks, I've inherited a couple of 2016 SQL servers, and they both have maintenance plans on the…

  Rich Mechaber

  1 replies

  9 months, 2 weeks ago

  By: Rich Mechaber

• system_health configuration

  I'm on SQL Server 2016 (SP2-CU11-GDR) (KB4535706) - 13.0.5622.0 (X64) Dec 15 2019 08:03:11 Copyrigh…

  Sailor

  6 replies

  9 months, 3 weeks ago

  By: Sailor

• Local admin cannot view/launch failover cluster manager

  hi all. I am new to this and hope someone can help me. We have created a failover cluster for our S…

  lhooipg

  3 replies

  10 months ago

  By: cyrusbaratt

• Migrate MS SQL Cluster to a New SAN

  Hi, As the title states, I am in the process of moving my sql cluster from an older SAN to a new on…

  dg

  2 replies

  10 months, 1 week ago

  By: dg

• 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

  3 replies

  10 months, 2 weeks ago

  By: Mr. Brian Gale