Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• 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, 2 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, 2 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, 2 months ago

  By: Anonymous

• security

  what is the difference between reconfigure and reconfigure override

  arjun22011992

  3 replies

  11 years, 2 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, 2 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, 2 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, 2 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, 2 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, 2 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, 2 months ago

  By: seaport

• SSL ceriticate problems during install

  Hi All, I'll be honest, it's the first time I've tried MSSQL and have far more experience of MySQL …

  jpb 60964

  1 replies

  11 years, 2 months ago

  By: jpb 60964

• 4 Virtual CPU's or 2 CPU's with Dual Cores

  I inherited a Database Server which I do not kn ow the history of. It has an Intel(R) Xeon (R) CPU …

  Welsh Corgi

  3 replies

  11 years, 2 months ago

  By: Welsh Corgi

• SELECT Operation with SNAPSHOT ISOLATION failed due to REBUILD INDEX and UPDATE STATISTICS job at sametime, On week-End

  Hi, We have used "SNAPSHOT ISOLATION LEVEL" and we have REBUILD INDEX and UPDATE STATISTICS job on …

  patelchandresh330 80387

  6 replies

  11 years, 2 months ago

  By: patelchandresh330 80387

• Multiple database-collation running on one SQL server (2014)

  Gents, Can someone shed a light on the following; We are consolidating some old SQL server-environm…

  gkramer 23701

  5 replies

  11 years, 2 months ago

  By: Arthur Kirchner

• Migrate SSRS from 2008 R2 to SQL Server 2014

  I need to Migrate SSRS from 2008 R2 to SQL Server 2014. What is the best method? I understand that …

  Welsh Corgi

  4 replies

  11 years, 2 months ago

  By: Welsh Corgi