SQL Server 2019 - Administration

• Topics

  Started by

  Posts

  Last post

• File date from Extended Event .xel files

  I know this, but I do not remember it. I have scoured by saved scripts as well a lot of google-fu. …

  Michael L John

  3 replies

  11 months, 4 weeks ago

  By: Jeff Moden

• restore db as db_copy. resolve hardcoded references within procedures to db.

  So I backup & restore db as db_copy. within both there is a proc that does: update [db]..[colum…

  goodtimecharlie

  5 replies

  11 months, 4 weeks ago

  By: Eric M Russell

• Creating a new SQL Server Instance in a Failover environment

  I am having a real hard time trying to create a new instance for a database using SQL Server 2019 F…

  Papote

  7 replies

  11 months, 4 weeks ago

  By: Michael L John

• PK violation in replication but only one subscriber

  We have a publication with three subscribers; it's basically a part list with around 1.2 million ro…

  cphite

  1 replies

  12 months ago

  By: VastSQL

• orphaned users in sys.sysusers

  Hi everybody, we got 2 entries in this table [myDatabase].[sys].[sysusers] Is there a possibility t…

  andreas.kreuzberg

  9 replies

  12 months ago

  By: Perry Whittle

• SQL Server Setup

  We don't have an IT department that can help us. We have our SQL server on a laptop that an employe…

  JP789

  9 replies

  1 years ago

  By: ATepes

• EXTENDED EVENTS Track What's Logging In

  Simple one looking for a script that can track what's logging in from where for UPGRADE discovery. …

  Super Cat

  1 replies

  1 years ago

  By: Grant Fritchey

• WHERE condition using ='value' returns different results that using IN('value')

  Have an interesting scenario - user found a discrepancy with rows returned when running the 2 below…

  MyDoggieJessie

  7 replies

  1 years ago

  By: Jeffrey Williams

• Moving DB to new drive

  Hi everyone I am planning on buying a new SSD to store my SS DB.  I plan to leave the actual SS on …

  water490

  11 replies

  1 years ago

  By: Johan Bijnens

• Vendor claims unused table space impacts performance

  Hello experts, I got a report from an application owner of degraded performance for an application.…

  webrunner

  4 replies

  1 years ago

  By: webrunner

• Migrated to new server, 2019 enterprise, jobs taking 300% longer to run. Ideas?

  Hi all, So here's the situation. We migrated to a new server as our old hardware fell out of warran…

  Mognar

  2 replies

  1 years ago

  By: Johan Bijnens

• SQL Server migration using replication

  I've set up replication in my SQL 2019 environment in attempt to migrate SQL databases individually…

  brianbilow

  4 replies

  1 years, 1 months ago

  By: micherve

• Filter a SQL Server Audit with a predicate

  Hi Gents, Silly question, but it's been a long time since I've done this. I need an audit of all su…

  michal.lisinski

  1 replies

  1 years, 1 months ago

  By: michal.lisinski

• Copy a large table from one table to another

  Hi, I have large table with 75 columns and 1.1 billion rows. Want to know the fastest way to copy f…

  shivaji

  1 replies

  1 years, 1 months ago

  By: Ken McKelvey

• Query Network Protocols from T-SQL or PowerShell

  Hello experts, I want to be more organized about the SSL certificates we have bound to SQL Servers.…

  webrunner

  3 replies

  1 years, 1 months ago

  By: henrykangg