SQL Server 2019 - Administration

• Topics

  Started by

  Posts

  Last post

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

  1 day, 2 hours ago

  By: Emperor100

• 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

  1 replies

  4 days, 20 hours ago

  By: Ed B

• 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

  1 replies

  1 week ago

  By: Site Owners

• 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

  2 weeks, 4 days 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

  2 weeks, 5 days 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

  2 weeks, 5 days 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

  3 weeks, 6 days 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 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, 1 week 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, 2 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

  1 month, 2 weeks ago

  By: Ant-Green

• Installing SQL Instance on a Clustered Virtual Disk

  Hi Everyone, I have a question, I am trying to setup a Lab environment with 1 DC and 2 SQL Nodes , …

  bokswager

  4 replies

  1 month, 2 weeks ago

  By: WirkKarl

• Error - Invalid Number when i use String_Agg

  Hi Select T1."transType", WHEN T1."TransType" = '46' THEN (SELECT STRING_AGG (A0."LocCode", ',') fr…

  jagjitsingh

  1 replies

  1 month, 3 weeks ago

  By: jagjitsingh

• Distinct values using string_agg

  Hi Is it possible to get distinct values using string_agg Select T1."transType", WHEN T1."TransType…

  jagjitsingh

  1 replies

  1 month, 3 weeks ago

  By: frederico_fonseca