Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Upgrade database version to management studio version

  I have a database that is showing as SQL Server 11.0.6248 which is SQL Server 2012 minus a few CU u…

  mouse51180

  4 replies

  8 years, 8 months ago

  By: mouse51180

• Permissions 'disappearing' from service account

  We have had a situation where the permissions from an account disappeared. I have managed to use th…

  SQLAssAS

  1 replies

  8 years, 8 months ago

  By: Grant Fritchey

• Index Usage prior to 2014 Upfrade from 2008R2

  Hello All,We recently upgraded (Side by Side) our oldest SQL Server box from  2008R2 to 2014 S…

  chris_barnhart

  5 replies

  8 years, 8 months ago

  By: frederico_fonseca

• Always on Node requirements

  Can Always on be configured between SQL 2014 RTM on Node 1 and SQL 2014 SP2 node 2. so here the SQL…

  psred

  2 replies

  8 years, 8 months ago

  By: Perry Whittle

• Always On FCI vs Normal SQL Cluster

  Hi I'm trying to know the difference between Normal SQL Cluster (i have installed this on sql 2008)…

  alexdantepabilo 22561

  3 replies

  8 years, 8 months ago

  By: Perry Whittle

• Cluster network name resource 'AG-listener1' failed registration of one or more associated DNS name(s) for the following reason:DNS request not supported by name server.

  Hello Folks, I see the following error in failover cluster manager for an AlwaysOn setup(2 secondar…

  SQL!$@w$0ME

  1 replies

  8 years, 8 months ago

  By: andreas.kreuzberg

• Client Upgrde

  I need to upgrade SQL 2008 client to SQL 2016. How to do it?? do I need to uninstall SQL 2008?

  Nita Reddy

  11 replies

  8 years, 8 months ago

  By: DeWayne_McCallie

• sys.dm_db_index_operational_stats

  Hello.I have 4 instalations:10.50.6220.0 (2008R2)11.0.5556.0 (2012)12.0.4100.0 (2012)12.0.5000.0 (2…

  msimone

  3 replies

  8 years, 8 months ago

  By: Sue_H

• Unable to uninstall an instance | media location issues?

  Hey all, Attempting to clean up some old environments. They were cloned + saw in place upgrades. Tw…

  Adam Bean

  1 replies

  8 years, 8 months ago

  By: Adam Bean

• Deadlock with two update statements

  Hi Guys, I am getting a deadlocks recently on one of my instance of SQL Server. Below are the two s…

  Dj463

  12 replies

  8 years, 8 months ago

  By: Sergiy

• Redgate SQL Compare

  Hello all, I frequently use Redgate SQL Compare for DB comparisons in my client's environment.…

  SQLPRODDBA

  2 replies

  8 years, 8 months ago

  By: SQLPRODDBA

• Update two table the instacian different in sql server 2014

  Good afternoon, I have a server named sqlexpress with a user table and another cpa server with a ta…

  bfmpinto

  3 replies

  8 years, 8 months ago

  By: bfmpinto

• SQL Server 2014 Express Reporting Services Password?

  I have recently installed the Express version of Reporting Services 21014.  SQL Server Managem…

  bob-848438

  3 replies

  8 years, 8 months ago

  By: bob-848438

• Query Performance Standards - Overall Per DB

  Good morning fellow SQL server folks! I have a general question regarding Query Performance standa…

  chris.munsell

  10 replies

  8 years, 8 months ago

  By: TheSQLGuru

• Sync Prod to Non-Prod

  Our Production sits in a very strict environment and different subnet from Non-Prod environment and…

  Rechana Rajan

  7 replies

  8 years, 8 months ago

  By: Jeff Moden