SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• Import question

  I am importing data from a 3rd party system into a DB that I am going to use for reporting.  I…

  jeremy.schillinger

  5 replies

  8 years ago

  By: Thom A

• Can't Shrink TEMPDB

  Hi All, I am getting an odd error when trying to shrink tempdb a little bit DBCC SHRINKFILE: Page 7…

  alex.sqldba

  14 replies

  8 years ago

  By: alex.sqldba

• How to delete clear space on the drive that DB's and Cubes are being backuped up to?

  Hello, Is there something in SSMS that I can use to clean up the backup directories? Like the way I…

  quinn.jay

  1 replies

  8 years ago

  By: gerald72

• CPU,Memory,IO,disk usage according to Database montly or weekly or daily report in sql server 2016

  hi all,how to get the usage of CPU,Memory,IO,disk usage according to Database montly or weekly…

  Ivan Mohapatra

  2 replies

  8 years ago

  By: Chris Harshman

• SQL 2016 link server

  Our environment requires that I create a link server from SQL to Oracle. The current production sys…

  shusta

  7 replies

  8 years ago

  By: shusta

• Error moving log.ldf

  Hi all, Tried moving log.ldf to another drive but hit error. Script and error as below... ALTER DAT…

  Riic

  17 replies

  8 years ago

  By: gerald72

• Scripting out schema permissions

  Hi all Help please!   Why does it seem so complicated to script out schema permissions i…

  doodlingdba

  7 replies

  8 years ago

  By: Perry Whittle

• How to go about testing your network for an AlwaysOn implementation

  Hi allSo i'm taking my first steps into deploying an AlwaysOn solution at my company. I've set it u…

  doodlingdba

  5 replies

  8 years ago

  By: Perry Whittle

• Installing SQL Server 2016 Fail-over Cluster

  Hi, We have 2 node fail-over cluster of SQL Server 2012 in our production environment.   Now w…

  arifulhaq

  1 replies

  8 years ago

  By: Perry Whittle

• Upgrade to 2016 questions

  All, Unfortunately we are still running a SQL server 2000 server. I've got provisional approval to …

  as_1234

  18 replies

  8 years ago

  By: Eirikur Eiriksson

• SSMS 17.2 connecting to Sql 2016 Integration Services

  I am having a problem that looks like a bug in this version of SSMS, and so am trying to find a dow…

  ManicStar

  3 replies

  8 years ago

  By: Beatrix Kiddo

• Permission issue with BAG 2016

  We have setup Basic Availability Group for SQL server 2016 for two node. But, it seems like wheneve…

  EasyBoy

  2 replies

  8 years ago

  By: EasyBoy

• Best way to keep users/logins/mappings syncrhronized in HAG between primary and secondary replicas?

  We recently had a network issue and the availability groups failed over from the primary to the sec…

  WebTechie

  19 replies

  8 years ago

  By: Johan Bijnens

• Linked server to an Excel file located on a Sharepoint folder

  Hi all, Is it possible to import data from an Excel file located on a SharePoint folder through a l…

  Henk West

  2 replies

  8 years ago

  By: Henk West

• Partitioning Data on First Character

  Evening Guys, Let's say I have a table with a couple of billion rows of data. That I want to partit…

  alex.sqldba

  13 replies

  8 years ago

  By: stewd