Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Cannot remove growth restriction from log files

  I have an instance where I have sysadmins. There a number of databases created by users and also ms…

  Lippy

  2 replies

  4 years, 11 months ago

  By: Lippy

• Need to create a job for dynamic execution on another server

  Hi all, I need to create a job to dynamically script out indexes and some other objects from Server…

  SQL Guy 1

  4 replies

  4 years, 11 months ago

  By: VastSQL

• Cannot connect from passive node to SQL Server Cluster

  Hi All, I've made a sql server cluster environment with two nodes Node1 and Node2. Both nodes are U…

  Igor Micev

  10 replies

  4 years, 11 months ago

  By: VastSQL

• Sudden PLE drop

  Hi Experts,   We are observing sudden drop in PLE. Buffer cache rit hatio, check point pages/s…

  VastSQL

  11 replies

  4 years, 11 months ago

  By: VastSQL

• Can TVF have a PK or there is a bug in my query?

  While debugging something, I came across a problem that  Table-valued-function allegedly has primar…

  SQL Guy 1

  5 replies

  4 years, 11 months ago

  By: Jeffrey Williams

• FCI

  I have two standalone SQL Server instances. Planning to configure SQL Server FCI between those two …

  Admingod

  12 replies

  4 years, 11 months ago

  By: Admingod

• JOIN to a remote table... easy but...

  So I have a linked server that works fine. I then created a join to the remote table as part of my …

  Jay@Work

  1 replies

  4 years, 11 months ago

  By: Sergiy

• PBM - result_detail column in syspolicy_policy_execution_history_details

  Hello, we use PBM to monitor last full and last log backup. PBM created, nothing special so far. We…

  deubel_m

  1 replies

  4 years, 12 months ago

  By: deubel_m

• BCP Login timeout when running on a 2014 "Always on Availability groups" with multisubnets

  Hi Experts, I've encountered a login timeout issue when running a BCP command on a SQL 2014 "AOAG"&…

  John G.

  2 replies

  4 years, 12 months ago

  By: John G.

• Alwayson

  Failed to update Replica status within the local Windows Server Failover Clustering (WSFC) due to e…

  goher2000

  2 replies

  5 years ago

  By: vamshichiranjeevi.g

• Table Partitions

  Not sure I'm going to explain this clearly by I'll give it a try. I have a table that has thousands…

  Kris-155042

  6 replies

  5 years ago

  By: Kris-155042

• trigger on a Large 5 billion row table

  Hello, So we have noticed our trigger that does insert from one table to another if there is an upd…

  Siten0308

  5 replies

  5 years ago

  By: Jeff Moden

• Error - The conversion of a varchar data type to a datetime data

  Hi Error -  Error - The conversion of a varchar data type to a datetime data type resulted in an ou…

  jsshivalik

  2 replies

  5 years ago

  By: ScottPletcher

• update country information based on the address + city for 5000 contacts.

  Can someone please share their thoughts on how to best update the country information if I have the…

  NewBornDBA2017

  4 replies

  5 years ago

  By: Jeff Moden

• Transaction log used space

  It's a little weird for me. I have a database (AdventureWorks2014; SQL Server 2014) in full recover…

  everand

  3 replies

  5 years ago

  By: everand