SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• Replication sending same change over and again when doing a batch update

  Good morning, I recently set up replication on my sql server - Microsoft SQL Server 2016 (SP2) (KB4…

  duncanburtenshaw

  3 replies

  5 years, 5 months ago

  By: duncanburtenshaw

• Replaced deprecated types (text, ntext) with Varchar(max) and NVarchar(max) !

  in 500 tables, on thousands of columns in all databases on entire server, I have replaced deprecate…

  VoldemarG

  5 replies

  5 years, 5 months ago

  By: Jeff Moden

• NOT able to backup database

  Hello All, Facing a problem backing up a database. When i click on backup database in the select ba…

  akashi

  4 replies

  5 years, 5 months ago

  By: Jeff Moden

• Database Mail - Not sending mail

  Hi there,I have been attempting to troubleshoot my issue with email not being sent from the se…

  cs_source

  4 replies

  5 years, 5 months ago

  By: Singhka

• Sql error log

  We have job which is configured to recycle the sql error log on daily basis and its failing with th…

  ramyours2003

  5 replies

  5 years, 5 months ago

  By: ScottPletcher

• Fragmentation & Statistics

  Hi All Was approached with a slow running query. First thing I did was update statistics on the ent…

  SQLSACT

  4 replies

  5 years, 5 months ago

  By: SQLSACT

• PARALLEL_REDO_WORKER_WAIT_WORK.: Not sure how relevant this may be..

  Attached file shows the top waits... PARALLEL_REDO_WORKER_WAIT_WORK.: Not sure how relevant this ma…

  VoldemarG

  2 replies

  5 years, 5 months ago

  By: Alejandro Santana

• Shrink or not to shrink that is the question?

  Hi. Upon a vendors request I have run maintenance against a single table and deleted 158 million ro…

  2Tall

  14 replies

  5 years, 5 months ago

  By: Sergiy

• Distributed Availability group

  Is there a guideline or does anyone have any step by step process on removing Distributed Availabil…

  LearningDBA

  2 replies

  5 years, 5 months ago

  By: CC-597066

• Restore DIFF backup over COPY_ONLY

  Hi All Hoping someone can give me some clarity. Server A Server B Took a copy_only backup on Server…

  SQLSACT

  2 replies

  5 years, 5 months ago

  By: SQLSACT

• UNION ALL Question

  SQL Server Enterprise BUILD 13.0.5598.27 3 Queries that when run individually each complete in arou…

  YSLGuru

  20 replies

  5 years, 5 months ago

  By: Jeffrey Williams

• MAXDOP Setting

  When upgrading and creating my new SQL server farm on 2016 I researched things to set on the server…

  garryha

  2 replies

  5 years, 5 months ago

  By: C-M-A

• DBmail error - driving crazy

  I have spent enough time on this trying to troubleshoot, wanted to check if anyone else has experie…

  curious_sqldba

  1 replies

  5 years, 6 months ago

  By: curious_sqldba

• Audit connection which are connecting to a server using AG listener.

  I am in a middle of removing a server which is part of AG and someone has asked me to see if there …

  LearningDBA

  2 replies

  5 years, 6 months ago

  By: Alejandro Santana

• Page Verify = Checksum

  Hi I'm belated changing the page verification option for a database from NONE to CHECKSUM.  I'm awa…

  Sporidium

  3 replies

  5 years, 6 months ago

  By: Johan Bijnens