SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• the owner of BAK files

  Hi All, How do I find out the owner of bak files ? There are some old bak files in D:\ that I want …

  WhiteLotus

  2 replies

  4 years ago

  By: homebrew01

• Sql dialog box is so small

  Hi All , Using SQL Management Studio , When I right click on server name , properties .. the box op…

  WhiteLotus

  1 replies

  4 years ago

  By: Ant-Green

• sql server and when adding files and capping space

  so I inherited a mess of a sql server 12 drives on primary file group, last 2 that looks like they …

  tcroninlifepoint

  4 replies

  4 years ago

  By: Johan Bijnens

• CREATE and INSERT permissions to User_X on DB_Z without DROP or DELETE

  [grant CREATE and INSERT permissions to User_X on all tables in DB_Z BUT Avoid granting DROP or DEL…

  VoldemarG

  1 replies

  4 years ago

  By: ScottPletcher

• Resource Monitor - Performance Issues

  Hi. Last Weekend I have migrate a server with SQL Server 2016 ENT to another machine, and since the…

  brunoperroni87

  4 replies

  4 years ago

  By: brunoperroni87

• How to get a SQL/CSV list of SCOM alerts and rules

  Hello experts, I've been tasked with tuning SCOM alerts for our database environment. Getting the a…

  webrunner

  1 replies

  4 years ago

  By: webrunner

• Bulk Copy Program (BCP) from the ODBC layer

  I am trying to locate some documentation, some where, any where, about ASYNC_NETWORK_IO with BCP in…

  evansdennis

  1 replies

  4 years ago

  By: evansdennis

• AG Redo Log Performance

  Friends and fellow DBAs, I'd appreciate your help, any help in this perplexing issue. I have a clus…

  shawn

  10 replies

  4 years ago

  By: shawn

• FORCED PARAMETERIZATION for syntactically similar but not precisely same query.

  Should it be done one time only as shown here or should plan guide for adhoc query be dropped /recr…

  VoldemarG

  2 replies

  4 years ago

  By: VoldemarG

• HOW DO I KNOW THE SQL SERVER WAS BUSY FOR A PARTICULAR TIME

  Hi Experts,   yesterday their was a problem at my server , the transaction was paused for arou…

  patelmohamad

  2 replies

  4 years ago

  By: Mr. Brian Gale

• CU-17 installation issue

  Hello! We have 2 Node active\active cluster SQL Server 2016 (SP2), when trying to install CU-17 it …

  PJ_SQL

  1 replies

  4 years ago

  By: PJ_SQL

• Is there a Snasphot limit

  I am trying to create the snapshot for the 70th database on my server.  However whenever I try snap…

  David Paskiet

  1 replies

  4 years ago

  By: Site Owners

• Publication Snasphot limit?

  I am trying to create the snapshot for the 70th database on my server.  However whenever I try snap…

  David Paskiet

  1 replies

  4 years ago

  By: David Paskiet

• Ola Hallengren's Index script

  So I tried Ola Hallengren's Index on one of the DB with parameters mentioned below. After running t…

  Chitown

  2 replies

  4 years ago

  By: Grant Fritchey

• How to determine whether SSIS is being used?

  Hello I've inherited some dev environment which looks like was abandoned, but I'd like to make sure…

  jankovic

  3 replies

  4 years ago

  By: jankovic