SQL Server 2017 - Administration

• Topics

  Started by

  Posts

  Last post

• AlwaysOn Availability Groups in 2 Data Centers

  I have a 2 node AlwaysOn Availability group I want to create. One node will be in one data center a…

  SlickRick9

  5 replies

  5 years, 10 months ago

  By: quackhandle1975

• Separate query duration into SQL processing time and network transmission time to client?

  Hi all, i'm having trouble separating the total query duration into SQL processing time and network…

  Theo Ekelmans

  4 replies

  5 years, 10 months ago

  By: Grant Fritchey

• SQL Server express 2017 Limitaions

  Hi, What are the limitations of SQL Server express 2017 Limitations.How to enable Sql Server Agent …

  binutb

  8 replies

  5 years, 10 months ago

  By: Henrico Bekker

• SSRS Failed to connect to SSRS Web Api ReportservicesTools ( Migrate SSRS 2016 to 2017 )

  Getting an error "failed to establish proxy connection"Trying to migrate reports to locally ho…

  Jo Pattyn

  2 replies

  5 years, 10 months ago

  By: johnzabroski

• How to delete physical file associated with File stream

  Hi How to delete physical file associated with File stream.ie: we are using file stream for storing…

  binutb

  4 replies

  5 years, 10 months ago

  By: binutb

• SQL server 2017 always On and quorum settings

  Hi,We have node cluster with no shared drives. SQL server is installed as standalone on both the se…

  Ryan007

  2 replies

  5 years, 10 months ago

  By: Beatrix Kiddo

• Different results with procedure and query

  I have a very odd issue, when a procedure runs it leaves off a specific set of rows.  When I r…

  SQLHeap

  2 replies

  5 years, 10 months ago

  By: Grant Fritchey

• Sql server express 2017 sa default password

  Hi, What is the sa default password in sql server express 2017? RegardsBinu

  binutb

  1 replies

  5 years, 10 months ago

  By: Thom A

• configuration.ini settings for system database ldf files

  Hi I'm creating a configuration.ini file for installing SQL 2017. We use a D: drive for data and L:…

  alex.palmer

  1 replies

  5 years, 10 months ago

  By: robnsilver

• How to create maintenance plan using script

  Hi, How to create maintenance plan using script for Update Statistics task, Rebuild index task etc.…

  binutb

  3 replies

  5 years, 10 months ago

  By: binutb

• how to call execution of SQL Job using windows task sheuler

  Hi, i have task assigned that is how to call sql agent job through task sheduler.can i write bat fi…

  Diyas

  2 replies

  5 years, 10 months ago

  By: Chris Harshman

• Take Backup from SS 2017 to Older Version

  I support a production database that was recently migrated to SS 2017. For years I have taken backu…

  George Hepworth

  7 replies

  5 years, 10 months ago

  By: George Hepworth

• Best method to reorganize sql server database

  Hi, Which is the best method to reorganize sql server database.The purpose is to reduce the size of…

  binutb

  4 replies

  5 years, 10 months ago

  By: Jeff Moden

• Maintenance plan task - Update statistics advantage

  Hi, What are the "Maintenance plan task -> Update statistics" advantages/advantages. What change…

  binutb

  3 replies

  5 years, 10 months ago

  By: dropsa999

• Need to get alert

  Hi, i am trying to a alert  when ever  fail over is happened on my always servers like ch…

  Diyas

  2 replies

  5 years, 10 months ago

  By: Diyas