SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• Compare instance performance before and after a change

  I'm about to make some changes to a set of related databases (yes, the change is tested in QA and i…

  Jenda

  2 replies

  1 year, 2 months ago

  By: cyrusbaratt

• Managed Service Accounts and DatabaseMail

  I have a SQL Job that Emails some data from a user database. The Job owner is SA. The Job has one s…

  planetmatt

  11 replies

  1 year, 2 months ago

  By: cyrusbaratt

• SQL Error Log - number of files

  Hi All, I need some assistance in understanding why my SQL error logs are not being deleted. I init…

  Tava

  4 replies

  1 year, 2 months ago

  By: Tava

• 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

  1 year, 3 months 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

  1 year, 3 months 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

  1 year, 3 months 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

  1 year, 3 months 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

  1 year, 4 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

  1 year, 5 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 sa…

  rjjh78

  3 replies

  1 year, 5 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

  1 year, 5 months 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

  1 year, 5 months 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

  1 year, 5 months 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

  1 year, 6 months 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

  1 year, 6 months ago

  By: Sailor