SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• 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 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 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 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 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 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 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 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 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 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 ago

  By: Johan Bijnens

• Recovering SQL databases

  Hi I'm looking into recovery plan for individual SQL databases. The scenario I'm planning for, is i…

  alex.palmer

  1 replies

  5 years ago

  By: alex.palmer

• Permissions

  I am looking to grant minimum permissions to the account which needs access to create schema and ta…

  Admingod

  1 replies

  5 years ago

  By: Admingod

• I/O Statistics by file per database?

  Do you look at something like that or any alert set on this info anywhere in your environment? What…

  VoldemarG

  5 replies

  5 years ago

  By: Jeff Moden

• Login to SQL Server cross domain AD Group user

  Our MS SQL Server is on another trusted domain (Trusted Domain T). We created a Universal Group wit…

  Papote

  4 replies

  5 years ago

  By: Andy sql

• DQS LogOnWindowFailedToConnect

  HI every one I'm running into problems in DQS I'll appreciate your advice, I tried several things b…

  frankn

  1 replies

  5 years ago

  By: frankn