SQL Server 2017 - Administration

• Topics

  Started by

  Posts

  Last post

• Alias of a SQL Server

  Was hoping to get some help on setting up our SQL Server with an alias.  Currently, we run reports …

  AMCity

  3 replies

  2 days, 4 hours ago

  By: Ken McKelvey

• Modifying the fetch size for Linked Server

  Hi, Problem: Pulling several million row table from Oracle DB into SQL server via a Linked Server t…

  Ram

  1 replies

  3 days ago

  By: frederico_fonseca

• Manual AG Alter problems

  All, We have an environment where connecting to servers in SSMS requires an extra domain specificat…

  Brandie Tarvin

  3 replies

  1 month, 4 weeks ago

  By: Brandie Tarvin

• Index Fragmentation

  I am looking into fragmentation in one of my databases and ran across these stats - should I be reb…

  stevec883

  18 replies

  2 months, 1 week ago

  By: MMartin1

• Log Shipping Not Able to Restore Log Files in Secondary

  I'm attempting to set up log shipping from SQL Server 2005 Standard to SQL Server 2017 Standard. I …

  regnar

  1 replies

  2 months, 3 weeks ago

  By: regnar

• auto-generate-sql-server-restore-script-from-backup-files (bak + trn) -in-a-directory for multi databases

  Hello everyoneI am looking to generate a restoration script for hundreds of databases with their ba…

  abdalah.mehdoini

  9 replies

  3 months, 2 weeks ago

  By: Srinivas Merugu

• Proc cache slowly decreasing in size until restart is required

  In SQL 2017 (14.0.3475.1) the size of the proc cache is slowly decreasing. The workload on the inst…

  Bouke Bruinsma

  4 replies

  3 months, 3 weeks ago

  By: Bouke Bruinsma

• Proc cache slowly decreasing in size until restart is required

  In SQL 2017 (14.0.3475.1) the size of the proc cache is slowly decreasing. The workload on the inst…

  Bouke Bruinsma

  3 replies

  4 months, 3 weeks ago

  By: Jeff Moden

• Events of System_health extended event serious or not

  I have listed the event names present in my system_health extended event report. Based on these gro…

  IT researcher

  1 replies

  5 months, 2 weeks ago

  By: IT researcher

• % processor Time in Activity monitor is greyed out

  When I connect to my SQL Server using SQL Server Management Studio (SSMS) from a remote computer, t…

  IT researcher

  1 replies

  6 months, 2 weeks ago

  By: IT researcher

• Microsoft Recommendations for Update Stats?

  I have an application team that is insisting on daily (and for some, weekly) jobs for UPDATE STATIS…

  Brandie Tarvin

  17 replies

  6 months, 2 weeks ago

  By: Jeff Moden

• Vulnerability Assessment removed?

  In Brent Ozar's list of links today, I learned that Microsoft has removed the Vulnerability Assessm…

  cgumprich

  4 replies

  6 months, 3 weeks ago

  By: Anja

• Manual Distribution Database Cleanup

  Hi All. I have a reasonably straightforward transactional replication setup. I had two databases on…

  five_ten_fiftyfold

  2 replies

  7 months ago

  By: five_ten_fiftyfold

• Indexing Recommendation Tools for SQL Server

  I'm looking for indexing recommendations for the entire SQL Server database, not just for individua…

  IT researcher

  3 replies

  7 months, 3 weeks ago

  By: Jeff Moden

• Log Backup failed on Secondary Replica

  I have a scenario where log backup is getting failed in Secondary replica on AlwaysOn availability …

  aroojsql

  2 replies

  7 months, 4 weeks ago

  By: keyurinbox