SQL Server 2019 - Administration

• Topics

  Started by

  Posts

  Last post

• Update CR LF in the string as empty

  Hi All, I have table which has data with lot of CR LF, Is it possible to update that  string as emp…

  Saran

  9 replies

  2 years, 8 months ago

  By: Eirikur Eiriksson

• Resource Governor Max Memory settings

  Hi we've had a spate of Resource Semaphore issues. They're on large server with 500GB+ RAM. The iss…

  Alexp012

  1 replies

  2 years, 8 months ago

  By: Alexp012

• Always on SQL Managed Instance

    is Always on support for the SQL managed instance. Distributed Queries are supported for SQL…

  Diyas

  1 replies

  2 years, 8 months ago

  By: Michael L John

• insert/update against VIEW on linked server

  I can't find an answer on Google so I am hoping someone here knows... We have a linked server that …

  cphite

  4 replies

  2 years, 8 months ago

  By: cphite

• BCP OUT xp_cmdshell errors out maximum column

  Hi All, I am doing BCP out the table having 175 columns. For small table columns it works fine. It …

  Saran

  7 replies

  2 years, 8 months ago

  By: frederico_fonseca

• Static port in sql server

  I'm on sql 2019 and I want to use static port 50010. I already set up an incoming firewall rule for…

  murstfirst

  9 replies

  2 years, 8 months ago

  By: cyrusbaratt

• Perform volume maintenance tasks

  Fellow SQL people, I posted this in the 2019 bard, but as it relates to our environment, it's reall…

  mm

  3 replies

  2 years, 8 months ago

  By: Jeffrey Williams

• bcp out from sql table rows are breaking divided into rows two or three rows

  Hi All, I am doing BCP out to text file notepad, looks like some rows are getting divided into two …

  Saran

  14 replies

  2 years, 8 months ago

  By: frederico_fonseca

• Create a Job Schedule that runs on the 1st of month only if it falls on a Sunday

  This job already has one schedule that runs on the first of the month. However, we need to run the …

  HookSQLDBA7

  14 replies

  2 years, 8 months ago

  By: Ed B

• Execution of SP

  One of the store proc failed as part of schedule job which is not a SQL agent job it is a part of n…

  sqlguru

  8 replies

  2 years, 8 months ago

  By: Jeffrey Williams

• Request to Estimated time to apply these commands,

  Good morning all I am currently working on the development of an ssrs report to supervise a transac…

  abdalah.mehdoini

  4 replies

  2 years, 8 months ago

  By: Adi Cohn

• Database in "restoring" mode in secondary server

  Hi, We have a primary and secondary server where 'Always on' is set. We remove one DB from Availabi…

  haichells

  2 replies

  2 years, 8 months ago

  By: haichells

• Find out Client Access with servername or sql-listener

  Hi, we have an sql-2019-Always-On-Cluster.Normally the clients access via listener, e.g. sqlli9. To…

  ingmar_n

  5 replies

  2 years, 8 months ago

  By: cyrusbaratt

• Can we configure read scale between 2 fcis?

  Suppose I have 2 WSFC clusters, each having 1 FCI (2-node + 1 FileShare). Fci1 (node1 & node 2)…

  canga1

  7 replies

  2 years, 8 months ago

  By: cyrusbaratt

• Different Disc Cluster Size in HAG Group

  Hello SQL Administrators. For the purpose of better performance of my SQL server I must reformattin…

  alphanew

  2 replies

  2 years, 8 months ago

  By: alphanew