Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Multiple Executions of a Scalar Function in a single call of stored procedure

  Hi Guys, There is a scalar function inside a stored procedure. When the proc is called once, this f…

  SQL!$@w$0ME

  9 replies

  10 years ago

  By: MadAdmin

• Refresh few instances from backup file

  Hi, What is the best way to refresh a few tables in the database using source as a .bak file or ma…

  PSB

  2 replies

  10 years ago

  By: Ant-Green

• Benchmarking new SAN with HammerDB. How many DW for TCP-H ?

  However, I do not fully understand the concept of DW in HammerDB. Does it mean that it mimics or cr…

  sql-lover

  3 replies

  10 years ago

  By: curious_sqldba

• Windows Server Core & SQL Server

  A network Type installed Windows Server Core on a Server for security reasons. There is in GUI. Ho…

  Welsh Corgi

  13 replies

  10 years ago

  By: Steve Jones - SSC Editor

• issue on AG

  one of the database in secondary is in not synchronizing /recovery pending status how can we re…

  ramyours2003

  1 replies

  10 years ago

  By: Grant Fritchey

• Difference between Runnable, Running, Conditional

  Hi all, Would you plz, let me know difference between Runnable, Running, Conditional while query i…

  farax_x

  4 replies

  10 years ago

  By: JimmyJones

• Normal locking threshold?

  Hello! I recently started at a new company, and they are having a few issues with locking and block…

  jevitts

  7 replies

  10 years ago

  By: MadAdmin

• Backup from a different server

  Hi Experts, This backup is part of BizTalk Server and i am trying to backup database A from Instan…

  VastSQL

  2 replies

  10 years ago

  By: VastSQL

• What are your five most common T-SQL commands

  I'm working on an article and would appreciate some input. There are a few T-SQL commands that just…

  Grant Fritchey

  63 replies

  10 years ago

  By: johnwalker10

• SSRS Set up and architecture questions

  So i met with the Dev team yesterday to gather requirements for the SSRS installation on 2014. Ri…

  ManicStar

  3 replies

  10 years ago

  By: Brad Feaker-195979

• SQL Server ODS setup

  Hi Guys, I have a requirement to setup/build sql server instance for ODS (operational data store). …

  SQL!$@w$0ME

  4 replies

  10 years ago

  By: SQL!$@w$0ME

• High Amount of Page Level Locking Disabled

  We recently migrated a database from SQL 2012 Standard Edition to SQL 2014 Enterprise Edition. Sinc…

  mceventphoto

  8 replies

  10 years ago

  By: mceventphoto

• .LDF vs .ldf

  run this statement CREATE DATABASE NEwDB2 SELECT physical_name FROM sys.master_files WHERE name ='…

  fawuahgyasi

  4 replies

  10 years ago

  By: fawuahgyasi

• Avaialability group Setup question

  We are looking into the possibility of using AlwaysOn Availability Groups in SQL 2014, if it works …

  David Graham

  3 replies

  10 years ago

  By: David Graham

• Availability groups and large batch operations

  We just switched over to 2014 with AG, from SQL 2008. So far, its wonderful, things are running al…

  ManicStar

  3 replies

  10 years ago

  By: ManicStar