SQL Server 2019 - Administration

• Topics

  Started by

  Posts

  Last post

• seeding mode always on

  Good morning all Does activating the TF9567 seeding mode trace flag speed up the synchronization pr…

  abdalah.mehdoini

  1 replies

  5 years ago

  By: abdalah.mehdoini

• Numerous IF and Else clauses & its execution time in sys.dm_exec_procedure_stat

  Hey SSC, Please if we have a stored procedure in which at a time only a single code segment of IF i…

  Abrar Ahmad_

  7 replies

  5 years ago

  By: Abrar Ahmad_

• Key locks on ghosted records

  We're curious about locks that might revolve around ghost records that have been deleted.  Does any…

  rwest 44523

  14 replies

  5 years ago

  By: Latigo

• A read operation on a large object failed

  I got an alert every day recently at different time on SQL server box DESCRIPTION:   A read operati…

  sqlfriend

  1 replies

  5 years ago

  By: sqlfriend

• Azure Data Studio and Jupyter Notebooks

  Trying to install the PowerShell Kernel for ADS and it wont complete the download, this I am guessi…

  Ant-Green

  4 replies

  5 years ago

  By: verone.lazio

• How do i find who has connected to my SQL Instance in Past 6 Months.

  Team, How do i find who has connected to my SQL Instance in Past 6 Months. With Thanks    

  satnam.singh 44358

  1 replies

  5 years ago

  By: Jeff Moden

• Always On Read-only routing

  I was working on with requirement to load balance the traffic coming from application to secondary …

  Admingod

  5 replies

  5 years ago

  By: jcarranza 23978

• How to deal with SqlServer PS module

  I understand that SqlServer has replaced SQLPS.  I experienced this with SQL 2017.  I'm now putting…

  NotBob

  3 replies

  5 years ago

  By: yonny24

• SQL 2019 FCI in Azure - Unable to Connect on Secondary Node

  Hi - I setup a new SQL FCI in Azure.  Two newly created VMs with SQL 2019 installed.  Cluster valid…

  DjH

  5 replies

  5 years ago

  By: ali-khawaja

• Migrate or upgrade SSIS to another sever

  What is the best way to move all SSIS  projects  in SSIS catalog to another server This is when we …

  sqlfriend

  4 replies

  5 years ago

  By: sterling3721

• Import/export

  I am looking to export data from SQL 2019 to sql 2017. What if the tables have primary key and fore…

  Admingod

  7 replies

  5 years ago

  By: jcarranza 23978

• Find (Count) Joins inside Views

  Good Afternoon All, I want to be able to count the number of joins used in views. We have a lot of …

  alex.sqldba

  10 replies

  5 years ago

  By: ScottPletcher

• SQL Server data file distribution

  I am a newbie to SQL Server administration and config. Apologies if I appear to confuse/mix termino…

  soumyarani0317

  3 replies

  5 years ago

  By: VastSQL

• Failover Clustering IP's

  For a 2 node active/passive cluster on Physical servers with shared storage. I am trying to setup F…

  Admingod

  3 replies

  5 years ago

  By: VastSQL

• cpu and memory connection in sql server

  Hello, DBA Gurus, so we have a prod SQL Server VM instance. I noticed that when CPU is high, >95…

  sqlguy80

  2 replies

  5 years ago

  By: Grant Fritchey