SQL Server 2019 - Administration

• Topics

  Started by

  Posts

  Last post

• Transitioning AlwaysOn Availability Group to Synchronous Commit Mode

  Hello, I have a SQL Server with an AlwaysOn configuration consisting of three replicas operating in…

  abdalah.mehdoini

  2 replies

  2 days, 19 hours ago

  By: Abhinav

• Question about updating statistics

  We have very large tables in our database, some even more 1 B records, so updating statistics will …

  SQL Guy 1

  3 replies

  2 days, 19 hours ago

  By: Abhinav

• Creating Maintenance plan to run annually

  What is the best way to set the schedule of a maintenance plan or a SQL Agent job to run annually. …

  Andre 425568

  2 replies

  6 days, 20 hours ago

  By: Andre 425568

• disable remote access

  If I configure remote access to 0 on my servers, am I right in saying that the only things that wou…

  goodtimecharlie

  2 replies

  6 days, 22 hours ago

  By: goodtimecharlie

• Best/easiest way to import an SSIS package...

  Folks, Looking for advice on the best way to import a package. I hope I'm in the right location! Ap…

  jellybean

  2 replies

  1 week, 1 day ago

  By: WirkKarl

• balancing numa nodes

  Can anybody advise on how i go about balancing threads to each node. As you can see from the below …

  PearlJammer1

  3 replies

  2 weeks ago

  By: PearlJammer1

• Urgent, Please Help. Named Instance Question

  Hello all, I just installed a new named instance on SQL Server 2019 RTM-CU32.  The installation was…

  brettwalker42

  2 replies

  2 weeks, 1 day ago

  By: Emperor100

• Deadlocks and Backups - Need help

  Hey everyone, please excuse my ignorance, I'm just .NET developer and have used SQL for years, but …

  Mike-342950

  10 replies

  1 month ago

  By: Mike-342950

• Building Flame Diagram for MSSQL stored procedures

  I wanted to share with you tools from my personal toolbox. If your code has many nested executions …

  tzimie

  1 replies

  1 month ago

  By: tzimie

• SQL Server - Log file not getting smaller on Log backup

  I have a database that is in full backup recovery model. When the log file is backed up the usage s…

  matt019

  6 replies

  1 month ago

  By: tzimie

• SSPI handshake failed error code 0x80090311

  Hi, I have a workstation with SQL Express 2019 installed and I have a PC with a .NET application bu…

  jamesstirling01

  1 replies

  1 month, 1 week ago

  By: Johan Bijnens

• Somebody realized to configure Cluster-Aware updating on VMWare nodes

  Creating an Windows Server Fail-over Clusters with two SQL server 2022 and a File server. All serve…

  boskabouter 007

  2 replies

  1 month, 2 weeks ago

  By: boskabouter 007

• SSIS Won't Create Log Entries

  Hi everyone My SSIS package will not log to sysssislog.  I am not sure what to do to troubleshoot. …

  water490

  4 replies

  1 month, 3 weeks ago

  By: water490

• SQL Server is terminating in response to a 'stop' request from Service error

  Dear All, In one of the server its repeatedly restarting sqlserver services and not found any thing…

  naga.rohitkumar

  3 replies

  1 month, 4 weeks ago

  By: rothj

• Size of DB on physical disk doesn't match Disk Usage by Table report

  Hi everyone I am looking at the size of my db on disk (ie c-drive) and comparing it against SS repo…

  water490

  7 replies

  2 months ago

  By: Ant-Green