SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• SSRS folder permissions do not propagate

  Hey everyone, I've come across something very strange that I cannot explain in the SSRS web page fo…

  ragnarok89

  1 replies

  1 year, 10 months ago

  By: Michael L John

• TempDB and FileSystem Space

  First disclaimer, I'm not a full-time DBA. I didn't initially set this configuration up, but it's b…

  wright.randall.k@gmail.com

  4 replies

  1 year, 10 months ago

  By: ScottPletcher

• Change logfile extension and reduce its size

  Hi – I’ve inherited a server where the database file name and log file name are the same, both …

  potatan

  5 replies

  1 year, 10 months ago

  By: ScottPletcher

• Dealing with super huge table which is partially partitioned.

  I'm dealing with 1 production database which is very large, roughly about 17TB in size. The problem…

  JasonO

  17 replies

  1 year, 10 months ago

  By: Johan Bijnens

• Extended Events shows each SQL command in one long line

  Hi all, I created Extended Events session to capture sql_batch_completed for duration>5 sec send…

  SQL Guy 1

  3 replies

  1 year, 10 months ago

  By: SQL Guy 1

• Extended Events to capture query causing tempdb log to get full

  Hi! How\Steps to setup Extended events to capture query causing tempdb log getting full? Can Query …

  PJ_SQL

  2 replies

  1 year, 10 months ago

  By: Grant Fritchey

• Query Store SQL 2016

  Hello! I am new to Query Store feature, once this is enabled it stores data captured in the databas…

  PJ_SQL

  5 replies

  1 year, 10 months ago

  By: PJ_SQL

• Single index reorg took 2 full days or more to complete

  I'm running an index maintenance job on 1 of my large database as the users recently perform massiv…

  JasonO

  3 replies

  1 year, 11 months ago

  By: Grant Fritchey

• Roles in cluster

  Hello! When we failover one node from another, does the roles from the node failover to another nod…

  PJ_SQL

  1 replies

  1 year, 11 months ago

  By: Jeff Moden

• Change the exsisting WSFC to a new WSFC in AG Configuration.

  Hi; We have a production SQL Server setup with AG configuration. The WSFC is not configured properl…

  vishwaa

  2 replies

  1 year, 11 months ago

  By: EdVassie

• Job History says running, but Job Activity says idle

  Hello experts, I'm hoping to get help with a strange issue. I got a request to stop a long-running …

  webrunner

  11 replies

  1 year, 11 months ago

  By: webrunner

• Server IP change

  We are planning to change the server IP of normal SQL Server instance, not a cluster. My understand…

  sqlguru

  7 replies

  1 year, 11 months ago

  By: Steve Jones - SSC Editor

• Change Data Capture

  We performed a drop on one of our CDC Tables when we should have performed a sp_cdc_disable_table .…

  ericwenger1

  1 replies

  1 year, 11 months ago

  By: ericwenger1

• Can log backups cause Operating system error 32?

  Hello experts, I am seeing sporadic (every other day or every few days) errors like this one for a …

  webrunner

  3 replies

  1 year, 11 months ago

  By: EdVassie

• SQL Agent Job Notification

  Hi - I have maintenance plan that rebuilds indexes nightly on a specific database. In its related S…

  SpartanDBA

  1 replies

  1 year, 11 months ago

  By: Ant-Green