SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• Query is filling Tempdb

  I have query which is filling TEMPDB I need suggestion how to modify this query to which can minimi…

  Nita Reddy

  2 replies

  3 months, 3 weeks ago

  By: Jonathan AC Roberts

• NC index creation duration question

  Hey All, My setup is as follows: Table with Clustered Index on ID col. Size 13 GB.  200+ fields, m…

  Coffee_&_SQL

  6 replies

  3 months, 3 weeks ago

  By: EdVassie

• Active and Active Cluster

  Hi Team, I am planning to apply security updates for SQL Server 2016 on Active/Active Cluster serve…

  shiv-356842

  2 replies

  3 months, 4 weeks ago

  By: Steve Jones - SSC Editor

• Tracing a performance issue

  Edit: This is a duplicate of another post. This topic was modified 4 months ago by  as…

  as_1234

  1 replies

  4 months ago

  By: Jeff Moden

• Issue with DBMail

  Hi all   We've got 3 servers with the same setup for dbmail. They use the same account (just w…

  richardmgreen1

  4 replies

  4 months, 1 week ago

  By: richardmgreen1

• Grant user read-write permission to a single database

  Hello! How do I grant a user to read-write to a single database and deny viewing rest of the databa…

  PJ_SQL

  2 replies

  4 months, 2 weeks ago

  By: frederico_fonseca

• Data cleansing/conversion tool HPE

  Hello.   I am looking for a tool Data cleansing/conversion, was recommended HPE any recommenda…

  juliava

  1 replies

  5 months ago

  By: Alan Burstein

• One Schema Not Restoring

  We are restoring a database from a full backup file of a database with two schemas.  The tables on…

  RonKyle

  1 replies

  5 months, 1 week ago

  By: ScottPletcher

• SSRS SSL cert renewal automation?

  I don't know if you are aware, but now Apple is requesting SSL certs only be valid for 45 days.  A…

  Sailor

  2 replies

  5 months, 1 week ago

  By: Sailor

• Adding SSISDB to AlwaysOn Availability group is not working

  Hi there I have an AlwaysOn Availability Group and am trying to add the SSISDB to it. I am followin…

  doodlingdba

  6 replies

  5 months, 3 weeks ago

  By: samcorneliusch

• configure always on in sql server 2016 with cross domain

  Hi All, I have 2 SQL Server 2016 EE one is in my local data center and another one is on the c…

  raguyazhin

  8 replies

  5 months, 3 weeks ago

  By: Perry Whittle

• application not connecting to secondary

    Hi the application which  has the connection string of the listener configured connects to …

  atulyan.aries

  2 replies

  6 months, 1 week ago

  By: Johan Bijnens

• roles needed to execute Stored procedures/function in SQL server

  Hi Could anyone please help to figure out which roles/rights needed in SQL server so that user can …

  leo_dec

  6 replies

  6 months, 3 weeks ago

  By: aaron_combs

• Download the MS SQL Server ODBC for Ubuntu

  Hi Friends, I have a need to setup MS SQL Server ODBC driver msodbcsql18_18.4.1.1-1_$architecture.a…

  Arsh

  1 replies

  7 months, 1 week ago

  By: Arsh

• SSAS, parallel instances problem

  Hi All, I have managed to install 5 SSAS (2016) named instances on one virtual Windows Server 2012 …

  My_Sky

  3 replies

  7 months, 2 weeks ago

  By: jvivasz99