SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• 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

  8 years, 5 months 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

  8 years, 5 months 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

  8 years, 5 months 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

  8 years, 5 months 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

  8 years, 5 months 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

  8 years, 5 months 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

  8 years, 5 months ago

  By: frederico_fonseca

• Dacpac - SQL Server error 1222 lock request time out period exceeded

  Hi, I am using dacpac for database upgrade.When applying dacpac in database , below error is raised…

  binutb

  5 replies

  8 years, 5 months ago

  By: Phil Parkin

• EXEC OPENDATASOURCE - security from within a job step

  Hey all, is this working as expected? I have a job step performing an EXEC OPENDATASOURCE to remot…

  Adam Bean

  5 replies

  8 years, 5 months ago

  By: Sue_H

• How to send mail from a contained database is SQL Server using Database Mail?

  How can I send mail with a user within a contained database is SQL Server using Database Mail? I tr…

  gemisigo

  2 replies

  8 years, 5 months ago

  By: gemisigo

• SSMS - Central Management Server - SQL Auth?

  Hey all, Is it me, or did they remove SQL auth from SSMS 2016 CMS? Authentication drop down only sh…

  Adam Bean

  1 replies

  8 years, 5 months ago

  By: Lowell

• Secondary replica database issue

  Last Friday, we had an issue with our production SQL cluster that uses AlwaysOn Availability Groups…

  mattwilson247

  1 replies

  8 years, 5 months ago

  By: Beatrix Kiddo

• ERROR:the log or differential backup cannot be restored because no files are ready to rollforward

  Hi All,A-->prod, B-->DR (LS configured)after failover B becomes the prod and A becomes the DR…

  21.naved

  1 replies

  8 years, 5 months ago

  By: Johan Bijnens

• SQL Server 2014 CPU Pegged at 100%

  Hi, We have a Virtual Machine on VMWare which is a core production DB server and the IT guy allocat…

  sqlguy80

  1 replies

  8 years, 5 months ago

  By: Gail Shaw

• Is full backup enough

  For the same migration project of moving 2 TB and 500 databases If I feel Data doesn't change and t…

  sqlguy80

  8 replies

  8 years, 5 months ago

  By: Jeff Moden