Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Restore Fails on Standard Edition - statistics

  Hi, I have an Enterprise edition of SQL2014 that is production. I try and restore my bak file to a …

  krypto69

  10 replies

  11 years, 1 months ago

  By: krypto69

• Guideline for picking a static port number for a named instance

  Basically the question is, which number should I pick?

  seaport

  4 replies

  11 years, 1 months ago

  By: seaport

• sys.dm_os_performance_counters

  Hi All, There is no data in sys.dm_os_performance_counters on an instance. I was facing this issue …

  Igor Micev

  2 replies

  11 years, 1 months ago

  By: free_mascot

• Inserts causing locking - HELP!

  Hi, I have a production DB that all of a sudden it seems that any and every insert causes massive l…

  krypto69

  7 replies

  11 years, 1 months ago

  By: Eirikur Eiriksson

• Traditional Indexes Vs Clustered Columnstore Index

  I've been asked to look at using Clustered Columnstore indexes for one of my tables. The table cont…

  joshdbguy

  3 replies

  11 years, 1 months ago

  By: Grant Fritchey

• CDC and AlwaysOn Availability Groups - anyone using this?

  I saw another post touching on this, and it sort of sounded like people just stayed away from the "…

  Maxer

  1 replies

  11 years, 1 months ago

  By: joshdbguy

• ArcGIS server 10.3 and sqlserver 2014

  I am planning on upgrading to ArcGIS server 10.3. We are currently at sqlserver 2008 and and want t…

  Quinn-793124

  4 replies

  11 years, 1 months ago

  By: Quinn-793124

• Port blocked, causes SQL Server to not start

  I have changed SQL Server from default port to another port number. All appears fine. If SQL Serv…

  Anonymous

  4 replies

  11 years, 1 months ago

  By: Anonymous

• security

  what is the difference between reconfigure and reconfigure override

  arjun22011992

  3 replies

  11 years, 1 months ago

  By: spaghettidba

• SQL Server Migration from 2012 to 2014 is degrading the query performance

  We are trying to migrate from sql server 2012 to sql server 2014 on windows 2000 R2 OS. After the u…

  gopisrinivas.t

  26 replies

  11 years, 1 months ago

  By: Phil Parkin

• Backup: Primary Full Backup vs. Secondary Copy-Only

  Hey, I have a brand new SQL 2014 AAG server (pair of servers actually). What is the best thing to d…

  Raymond van Laake

  5 replies

  11 years, 1 months ago

  By: Grant Fritchey

• Unable to Connect To SQL Server DB Instance if Port Number is not Included

  Hi If I try to connect to ServerName\I01, I get the error below. "A network-related or instance-sp…

  Ricky Valencia

  7 replies

  11 years, 1 months ago

  By: Perry Whittle

• DBCC CHECKDB WITH DATA_PURITY

  Hi, We are currently planning a side-by-side SQL Upgrade from 2008r2 to 2014. One of the post-Upgra…

  gs1975

  9 replies

  11 years, 1 months ago

  By: Perry Whittle

• Set up PerfMon collector on my workstation collecting remote server data

  I set up the collector, and specify the RunAs as my AD account in the Collector Set - Properties - …

  seaport

  1 replies

  11 years, 1 months ago

  By: seaport

• Job History Filter by Run Date

  I have this script that I'm trying to filter the results of the Job History to the day prior at 180…

  Welsh Corgi

  1 replies

  11 years, 1 months ago

  By: seaport