Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• use excel to update backend SQL Table

  Is there an efficient way to update backend SQL table through Excel?I tried in Excel using a SQL co…

  sqlfriend

  20 replies

  9 years ago

  By: Phil Parkin

• SQL Maintainance plan - what do you use ? (check db integrity + update statistics)

  Hi all, I am setting up monthly maintenance plan for my sql server. So far i have only setup clean …

  szejiekoh

  3 replies

  9 years ago

  By: szejiekoh

• Secondary Replica Suspended

  Morning Guys, I have a secondary replica that has to date been working fine and then I think a SAN&…

  alex.sqldba

  11 replies

  9 years ago

  By: alex.sqldba

• Unable to change SQL Server 2014 Listening Port

  I have got SQL Server installed and working fine. In order to allow firewalls, I went in to see tha…

  sarath.tata

  5 replies

  9 years ago

  By: K. Brian Kelley

• False password mismatch error

  Hello all! First post, and I'm *not* a SQL admin (but I have experience as a regular WinServ admin)…

  shane.a.johnson22.civ

  3 replies

  9 years ago

  By: K. Brian Kelley

• Rename instance from default (MSSQLSERVER) to named (e.g., DOCSHARE)

  Hi, For SQL Server 2014, for a standalone instance, can we change the instance name from default (M…

  ash304

  5 replies

  9 years ago

  By: K. Brian Kelley

• SQL Server Book

  Hi! What book would you recommend for SQL Server troubleshooting CPU, memory, replication etc issue…

  BiboKid

  2 replies

  9 years ago

  By: Gail Shaw

• included Column & Clustering Key

  I have observed that for a query when the PK is in select list and if we create a NC index with co…

  Rechana Rajan

  7 replies

  9 years ago

  By: Sergiy

• Estimating backup size

  how do i get run query against all databases , I tried following but it does not seems to be workin…

  goher2000

  5 replies

  9 years ago

  By: goher2000

• SQL SERVER 2014 Memory values

  I ran the following query while investigating some memory issues. select (physical_memory_in_use_kb…

  ganci.mark

  1 replies

  9 years ago

  By: ganci.mark

• What changed 'sp_configure' settings

  Hi, I'm hoping to find out what or when sp_configure 'default trace enabled' was changed on multipl…

  A3Paper

  3 replies

  9 years ago

  By: Sue_H

• Data Archive

  Hi Experts, We have a job in place to Insert data older than a year from Prod table to an archive d…

  VastSQL

  14 replies

  9 years ago

  By: VastSQL

• MSSQLSERVER service terminated unexpectedly

  HiSQL Service went down on production server. Below is the only error message on event logs. There …

  Admingod

  2 replies

  9 years ago

  By: johnwalker10

• You do not have permission to use the bulk load statement.

  Hi, I have a strange issue.I created a procedure on my local SQL instance usingWITH EXEC AS SELF In…

  Sergiy

  7 replies

  9 years ago

  By: Sergiy

• Manual Cleanup of Change Tracking in SQL Server 2014

  My company uses change tracking for our data warehouse incremental loads, as described here by Tim …

  chris.o.smith

  3 replies

  9 years ago

  By: chris.o.smith