SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• SQL Server Feature Pack for 2016, DB2 OLE DB Drivers

  Where can I find good documentation about the DB2 OLE DB version 5 driver? Is there a compatibility…

  mharding 65939

  2 replies

  7 years ago

  By: mharding 65939

• Restore 2008R2 DB w/ NORECOVERY

  Hi Guys, I have two questions. I just restored a full backup into norecovery from a SQL Server 2008…

  alex.sqldba

  3 replies

  7 years ago

  By: alex.sqldba

• Issues trying to set up linked server from SQL 2012 to SQL 2016

  Hello experts, I need to create a linked server from a SQL 2012 server to a SQL 2016 server and I a…

  webrunner

  1 replies

  7 years ago

  By: Mr. Brian Gale

• Create full text index

  I have table with huge amount of records (about 1 bilion records)Is it possible to create full text…

  farax_x

  1 replies

  7 years ago

  By: Sue_H

• SSRS 2012 to 2016 Upgrade - Recreating Subscriptions

  I'm planning a 2012 - 2016 SSRS Upgrade (Native to Native), and there's no issue doing a backu…

  Leo.Miller

  2 replies

  7 years ago

  By: SQLRNNR

• Statistics with NORECOMPUTE

  Evening All, When would one typically specify NORECOMPUTE  on Statistics? Presumably when the …

  alex.sqldba

  12 replies

  7 years ago

  By: SQLRNNR

• "Cloning" a New SQL Server. Restore MSDB ?

  I am migrating from a SQL 2008 server to a SQL 2016 server. This is an important server for reporti…

  homebrew01

  1 replies

  7 years ago

  By: SQLRNNR

• Applying SP2 to SQL Server 2014 Best Practices

  Do we need to stop the SQL Server service before applying SP2 for a SQL Server 2014 Production Inst…

  sqlguy80

  3 replies

  7 years ago

  By: Perry Whittle

• Recompiling all objects , stored procedures after moving to new server

  Hi, We just moved from SQL Server 2008 R2 32 bit to SQL Server 2014 64 Bit Ent ( no SP just RTM rel…

  sqlguy80

  7 replies

  7 years, 1 month ago

  By: Gail Shaw

• SQL 2016 security - sp_rename

  Hi everyone,We have a newly installed SQL 2016 instance (SP1).We've created a new user - windows au…

  Wandrag

  8 replies

  7 years, 1 month ago

  By: Perry Whittle

• Upgrading to SQL 2016 - Failures in SSRS

  Good day,We've upgraded our SQL 2014 instance to a SQL 2016 enterprise edition (SP1,Cu1).All of our…

  Wandrag

  6 replies

  7 years, 1 month ago

  By: Wandrag

• Increasing Buffer Pool

  Good afternoon. Recently read an article Increasing Buffer Pool, and can not understand how I can d…

  ISuleymanovH

  4 replies

  7 years, 1 month ago

  By: ISuleymanovH

• Question about AlwaysOn Availability Groups

  I understand it like this: Secundary databases in the group are syncronized either synchronous or a…

  larsp777se

  1 replies

  7 years, 1 month ago

  By: rvsc48

• Insufficient memory in internal resource error with moving table to in memory

  Trying some tests in moving a table from disk to in memory.  Using script or GUI I get an erro…

  tcronin 95651

  7 replies

  7 years, 1 month ago

  By: Mr. Brian Gale

• Production Database - Apply table partition also database is accessible.

  Hi I have a Production Database on my VMM. I have to partition a huge table (billions of rows)…

  vineet_dubey1975

  7 replies

  7 years, 1 month ago

  By: frederico_fonseca