SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• Index Creation for large table failed.

  I'm trying to create a clustered index on a very large heap table. Below is the script i'm using to…

  JasonO

  4 replies

  1 year, 7 months ago

  By: JasonO

• Always ON, HA, File Location Problem

  Hello All, I have four VMs setup while I am learning SQL Server Admin tasks and configurations.  S…

  mjdemaris

  7 replies

  1 year, 7 months ago

  By: Jeffrey Williams

• Monthly Partitioning issue a number of months missed

  I've joined a new company and have noticed that a scheduled partition creation job hasnt been runni…

  Vets5

  2 replies

  1 year, 8 months ago

  By: Vets5

• Index

  I have Index Maintenance Job I have stand alone secondary server when I run on secondary server it …

  Nita Reddy

  7 replies

  1 year, 8 months ago

  By: Michael L John

• Some but not all databases in Availability Group are inaccessible

  Hello experts, I'm seeing a strange problem that I don't know how to permanently fix. For an AG tha…

  webrunner

  3 replies

  1 year, 8 months ago

  By: Perry Whittle

• Failover in Availability Group wipes data from sys.dm_db_index_usage_stats

  Im using Brent's sp_blitzIndex results and storing them to prevent any loss during a restart.  I f…

  askcoffman

  3 replies

  1 year, 8 months ago

  By: Jeff Moden

• Error: 18456, Severity: 14, State: 149, no matter what I try

  Hello experts, I'm seeing a strange issue. A user reported that they could not log in with their AD…

  webrunner

  10 replies

  1 year, 8 months ago

  By: webrunner

• multiple PAGELATCH_UP waits on data file

  Hi Experts, What is meant by PAGELATCH_UP waittype ? what does it trying to tell me? what is PFS ? …

  bobrooney.81

  2 replies

  1 year, 9 months ago

  By: Grant Fritchey

• system_versioning = on/off permissions

  All, I would like to give a user permission to set system_versioning on or off on a table. I know t…

  as_1234

  9 replies

  1 year, 9 months ago

  By: as_1234

• SSRS Duplicate records

  Hello, I recently migrated from 2012 to 2016 SQL server.  When comparing SSRS reports, the new ser…

  pricca

  3 replies

  1 year, 9 months ago

  By: Michael L John

• Troubleshooting TCP Provider: Error code 0x274C

  Hello experts, I'm trying to help troubleshoot an issue affecting the connections between one of ou…

  webrunner

  2 replies

  1 year, 9 months ago

  By: webrunner

• Cleaning up 2012 components after an upgrade to 2016

  Hi all, I recently upgraded an instance of 2012 to 2016. successfully. After doing the upgrade, I r…

  rcct

  1 replies

  1 year, 9 months ago

  By: Site Owners

• SQL 2016 updates

  Hello, so Microsoft has two Feb 2023 SQL updates listed under the same CVE.  5021128 Security upda…

  jchendorain

  3 replies

  1 year, 10 months ago

  By: Jeff Moden

• Multiple Mirroring Entries in Mirroring Monitor for the same DB

  Hi there, I just wanted peoples opinion on what I've seen in the Mirroring Monitor. We are encounte…

  SQL Bandit

  1 replies

  1 year, 10 months ago

  By: SQL Bandit

• Log shipping copy job issue

  We observed  one of  the database  is not in sync  on the secondary  server where log shipping…

  ramyours2003

  2 replies

  1 year, 10 months ago

  By: Mlotsa