Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Confusion about the schema owner and table owner

  Everyone, I am wondering if I can get some help. I created a schema 'gb' schema and then changed th…

  NewBornDBA2017

  1 replies

  8 years, 3 months ago

  By: Sue_H

• Is there a way to free up memory during the day?

  We have a server with 512G of memory. We have a process that runs every night that loads millions o…

  krypto69

  7 replies

  8 years, 3 months ago

  By: krypto69

• Adding a 2nd AG to AlwaysOn failing on Listener setup

  Using SQL 2014 Enterprise, for my AlwaysOn Availability Group -- I have everything setup and runnin…

  Express12

  2 replies

  8 years, 3 months ago

  By: Express12

• How to find if someone ran SQL profiler 2 days back

  Hi Is there a way we can find if someone ran SQL profiler 2 days back?

  gary1

  9 replies

  8 years, 3 months ago

  By: Jeff Moden

• Moving or adding tempdb files best practice

  On some database server VMs, I'm seeing regular messages about tempdb data files such as the one be…

  bwelch42

  6 replies

  8 years, 3 months ago

  By: Jeff Moden

• Always On Availability Group Listener

  I've been working on setting up a development environment to test out Always On Availability Groups…

  Samwell

  1 replies

  8 years, 3 months ago

  By: VastSQL

• Migrating a SQL Server 2008(Publisher and Subscriber) to SQL 2014, retaining Server Name

  Hello Experts, I have a production SQL Server of version 2008 running on a cluster which is propose…

  chandan_jha18

  3 replies

  8 years, 3 months ago

  By: Sue_H

• SQL Server Management Studio not starting

  Good day, All of a sudden my SSMS is giving me an error " The operation could not be completed'' I …

  tmmutsetse

  4 replies

  8 years, 3 months ago

  By: Sanz

• Trouble Enabling SQL Audits

  Trouble Enabling SQL Audits   I am running SQL Server 2014 SP2 CU8 on Windows Server2012 I …

  jayoub

  6 replies

  8 years, 3 months ago

  By: jayoub

• License dev server

  We have our prod server where our we have SSIS installed. Our development team creates packages and…

  NewBornDBA2017

  8 replies

  8 years, 3 months ago

  By: frederico_fonseca

• DATALENGTH function

  I have 149 tables in our DBs with State column. Values I see in that State column are like MI, Mich…

  NewBornDBA2017

  3 replies

  8 years, 3 months ago

  By: Luis Cazares

• What Extended Events should I use?

  I have a scenario where a production SQL server appears to be completely clearing both the plan and…

  Steven Gore

  5 replies

  8 years, 3 months ago

  By: Steven Gore

• Mount Point & FileStream

  Hi Experts, Will Filestream works with Mount Point? After enabling filestream and restarting the se…

  VastSQL

  3 replies

  8 years, 3 months ago

  By: VastSQL

• Backups, Backups, Backups.......

  I work as a DBA for a medium size municipal government organization. I work together with another …

  jackimo

  8 replies

  8 years, 3 months ago

  By: Jeff Moden

• Invalid Column __$command_id issue during CDC implementation in SSIS package

  In our development SQL Server I just upgraded to sql server 2014 cu10. Our SSIS Packages are now no…

  ericwenger1

  1 replies

  8 years, 3 months ago

  By: Sue_H