Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• SQL 2014 AlwaysOn Hadr_Sync_Commit wait is worse when adding ASYNC nodes

  We have 3 replica setup in a single datacenter with one primary replica and one sync secondary and …

  craig.fullen

  2 replies

  10 years, 5 months ago

  By: craig.fullen

• 3 Node 2014 AlwaysOn - Automatic Failover?

  I have a 3 node 2014 AlwaysOn setup. The primary and secondary are set for automatic failover. Th…

  ItsDaveTime

  3 replies

  10 years, 5 months ago

  By: Perry Whittle

• Columstore index on large tables

  I created columnstore index on the table with 20 columns and about 1000 000 000 rows every day adde…

  alexmpd

  3 replies

  10 years, 5 months ago

  By: alexmpd

• mdf full

  if mdf get full by data then how to make free space without adding disk.

  giri10488

  3 replies

  10 years, 5 months ago

  By: Justin Manning SA

• sp_rename and transactional replication

  Hey all I am in need of some help.i need to rename a replicated table columns.will this affect my …

  hiMz

  1 replies

  10 years, 5 months ago

  By: Graeme100

• Using Column encryption with symmetric keys

  Hello All, I am trying to implement the column encryption on one of the tables, have used the below…

  BoobyB

  9 replies

  10 years, 5 months ago

  By: crmitchell

• Cannot Decrypt the encrypted columns from the database backup on local machine

  Hello All, I've a SQL server 2014 running on one of our server. We're in the process of implementin…

  SSRS Newbie

  3 replies

  10 years, 5 months ago

  By: SSRS Newbie

• DW and TLog.

  We are developing a Data Warehouse. The original instructions were to include HA into the solution …

  aido-1116077

  9 replies

  10 years, 5 months ago

  By: aido-1116077

• Replication Remove artilce that failed to publish - 2012 to 2014

  I have a table with Time Data Type Fields. If I try to remove the failed article I get a message th…

  Welsh Corgi

  3 replies

  10 years, 5 months ago

  By: free_mascot

• SQL Server installation problem

  While SQL server installation, following message is displayed "The specified user 'MASB\keshabraj' …

  keshab.basnet

  2 replies

  10 years, 6 months ago

  By: JManuelN

• Disconnected From Listener in Availability Group (When Primary Failed)

  Hi I setup an availability Group. (Only 2 servers - Primary And secondary) -- 21 , 22 I also define…

  MotivateMan1394

  2 replies

  10 years, 6 months ago

  By: MotivateMan1394

• can please help me towrite better than this query

  can please help me to write better than this query but i want same output ... select a. emp_id,a.ui…

  rajadadi

  1 replies

  10 years, 6 months ago

  By: Grant Fritchey

• Do we need to update stats after we rebuild index and reorganize index

  We face slow performance issue for like taking long time for same query execution after We apply in…

  keshab.basnet

  2 replies

  10 years, 6 months ago

  By: keshab.basnet

• Problem of executing T-SQL Stored procedure with Parameter NULL

  ALTER PROCEDURE [dbo].[p_sub_agent_Grp_report] @parent_pay_agent_cd VARCHAR(25) , @tagno …

  keshab.basnet

  2 replies

  10 years, 6 months ago

  By: keshab.basnet

• Scheduled Job runs successfully, but table does not update

  Hello, I have a job scheduled that imports a table from a Oracle database. The job runs at 3am and …

  xddevv

  7 replies

  10 years, 6 months ago

  By: Ozzmodiar