SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• SQL Server 2016 Always Availability Group Secondary Database Update.

  hi all in Sql Server 2016 EE always availability groups can be perform write operations in secondar…

  raguyazhin

  1 replies

  8 years, 12 months ago

  By: Beatrix Kiddo

• SQL SERVER Services stopped automatically

  Hello Everyone, I came across an issue today. Issue is My Sql services had stopp…

  sanjaydut26

  5 replies

  8 years, 12 months ago

  By: sanjaydut26

• SQL anaylsis

  Kindly give the queries for below, 1.Query for List of tables of top and bottom accessed in last 3…

  Bharat21

  11 replies

  8 years, 12 months ago

  By: MMartin1

• Latest SSMS Bug

  Starting with SSMS release 16 I have a bug where Security, Logins, User Mapping will not display th…

  DeWayne_McCallie

  3 replies

  9 years ago

  By: DeWayne_McCallie

• Insufficient memory error when executing the script.

  Hello Everyone, I am getting this error when I try to execute the script - insuf…

  sanjaydut26

  4 replies

  9 years ago

  By: sanjaydut26

• SQL 2016 Benchmarks

  I am setting up new SQL2016 Failover Clusters and I have noticed something that concerns me. I am …

  JeepHound

  3 replies

  9 years ago

  By: ESAT ERKEC

• Job creation for killing another job

  Hi All, My client has come up with a requirement wherein we need to monitor a job(XYZ), and in case…

  Stripathydba

  2 replies

  9 years ago

  By: ESAT ERKEC

• Sql Server error log growing out of control

  Hello Everyone, I have come across an issue where my sql server error log is grow…

  sanjaydut26

  11 replies

  9 years ago

  By: Gazareth

• avoid install localdb through SSDT installer

  I am trying to download and install SQL 2016 Data tools on a development server which we have alrea…

  sqlfriend

  7 replies

  9 years ago

  By: sqlfriend

• SQL 2016 Replication

  I think this should be a new forum. I have a Project and would like advice from anyone who has expe…

  Budd

  3 replies

  9 years ago

  By: Alan Burstein

• Database Mail not working

  Hi all, I have just did a new/clean installation of the SQL Server 2016 (standard edition) on a Wi…

  donstarter

  9 replies

  9 years ago

  By: bugg

• Splitting out System DB data and log files?

  Setting up a new server , should I split out system DB data and log files to different drives like …

  bugg

  8 replies

  9 years ago

  By: Gail Shaw

• SQL 2008 to 2016 inplace vs side by side upgrade

  Hi Folks, Deciding whether to do an in place upgrade or side by side (named instance) on same serve…

  bugg

  2 replies

  9 years ago

  By: bugg

• How to fine tune cursor by rewrote the code

  I have a stored procedure, inside that SP I am using below cursor with Temp tables. Currently it i…

  kiran08.bi

  9 replies

  9 years ago

  By: DesNorton

• RAID DISK SETUP ON NEW SERVER WITH MSSQL 2016

  Any thoughts on this setup for disks Total disks: 6 Std HD + 6 SSD OS - HD - RAID 1 SQL SERVER - H…

  bugg

  9 replies

  9 years ago

  By: Perry Whittle