SQL Server 2017 - Administration

• Topics

  Started by

  Posts

  Last post

• Send email

  I am getting 2 outputs from this 2 select statement. Issue is Either one of the select has No recor…

  Nita Reddy

  2 replies

  6 years ago

  By: Nita Reddy

• SQL Server Performance Monitoring (CPU)

  I'm working on trying to gather performance monitoring statistics for all my servers and generating…

  oogibah

  9 replies

  6 years ago

  By: lmarkum

• Migration to SQL Server

  I am working on migration project and doing the conversion using SSMA. Checking to see if anyone ha…

  Admingod

  12 replies

  6 years ago

  By: Admingod

• Downgrade sql 2017 to 2014

  Hi, I got a requirement to downgrade Standard 2017 to SQL 2014. What is the procedure to downgrade?…

  pols

  4 replies

  6 years ago

  By: Joie Andrew

• Restore database on Azure VM fails

  I'm trying to restore a database containing memory optimized tables to a standard edition of SQL Se…

  pooyan_pdm

  5 replies

  6 years ago

  By: Joie Andrew

• msdb.dbo.sysmanagement_shared_registered_servers_internal is empty

  Good morning all , Who has an idea how I can feed the two system tables select * from msdb.dbo.sys…

  samirca007

  1 replies

  6 years ago

  By: samirca007

• AlwaysOn Clusterless

  Hi All I'm hoping I can get something cleared up regarding AlwaysOn without an underlying Windows C…

  SQLSACT

  3 replies

  6 years ago

  By: MVDBA (Mike Vessey)

• Share DB Resources

  I have prod sql server which is hosting vendor application database, however, our company is a sist…

  Admingod

  2 replies

  6 years ago

  By: frederico_fonseca

• Generate Index only Script for Whole db

  Is there a way to generate only the indexes for an entire DB. If I right click the DB and go to tas…

  Admingod

  9 replies

  6 years ago

  By: Jeff Moden

• Cannot connect to local instance

  Here's a strange one that I just cannot figure out. I have SQL Server 2017 installed on ServerONE w…

  TWF_SQL

  2 replies

  6 years ago

  By: TWF_SQL

• Cursor inside a Stored procedure

  Hi all, I have a stored Procedure that uses a cursor and inside that cursor it kicks of a another s…

  smoham22

  3 replies

  6 years ago

  By: Jeff Moden

• SQL patching solution and automation

  Hi All, Would like to get some suggestion of SQL patching solution and automation for multiple serv…

  Saran

  11 replies

  6 years ago

  By: Saran

• Partitioned data files growing 5x after SQL 2017 Upgrade

  Hi All, We recently upgraded one of our OLTP systems from SQL 2014 to SQL 2017, and after the upgra…

  DataGuy

  2 replies

  6 years ago

  By: DataGuy

• Missing dumps during unexpected server reboot

  One of my critical database server had an unexpected reboot followed by server hung issue but sadly…

  Abhishek

  3 replies

  6 years ago

  By: Steve Jones - SSC Editor

• AG Listeners - multiple instances

  Hi, I'm looking after a cluster that has 2 instances; one for 2016 and one for 2017. The AG listene…

  lanky_doodle

  9 replies

  6 years ago

  By: lanky_doodle