Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Design a AlwaysOn cluster

  Hi! I got 5 SQL Servers 2008R2 (2x CPUs with 96-384Gb of RAM) with total 1500DBs and around 10Tb of…

  magnus.tengmo

  1 replies

  11 years ago

  By: Perry Whittle

• Report Server Database name

  Hi, Is there any way to find Report server database name using T-SQL? I have SQL server report serv…

  UmaShankar Patel

  2 replies

  11 years ago

  By: UmaShankar Patel

• Storage question

  I have SSD storage of size 1TB, if I partition into multiple disks for tempdb, data, logs does it …

  mxy

  3 replies

  11 years ago

  By: mxy

• Transactional Replication - How to purge data from Publisher but not Subscriber

  Hi Experts, We have a transactional replication between OLTP and RPT. Every quarter, we need to arc…

  Thanh Ngay Nguyen

  2 replies

  11 years ago

  By: mxy

• Need help finding Microsoft application compatibilty with SQL Server 2014

  We are running a several Microsoft applications (ForeFront, SCOM, SharePoint and Citrix). I have be…

  rummings

  4 replies

  11 years ago

  By: mxy

• How a new partition Function apply for Current Data

  I have a heavy database , More than 100 GB only for six month . every Query on it takes me along ti…

  MotivateMan1394

  25 replies

  11 years ago

  By: Gail Shaw

• How can i learn SQL Server 2014

  How can i learn SQL Server 2014

  preethy06

  2 replies

  11 years ago

  By: Grant Fritchey

• upgrade from 2008 to 2014

  Hello, 1- is it possible to install 2014 while 2008 is installed. And then restore the 2008 databas…

  arkiboys

  5 replies

  11 years ago

  By: Anonymous

• SQL Server 2016 public preview coming this summer

  http://www.sqlserverbox.com/official-news-about-sql-server-2016.html

  SQListic

  1 replies

  11 years ago

  By: Anonymous

• Reducing Index Fragmentaion during Inserts

  Hi Folks, This is my problem. We have a database with a table that contains around 180m records. E…

  kevaburg

  14 replies

  11 years ago

  By: RonKyle

• Uninstall SQL Server 2012 without uninstalling SQL 2014

  Hi I have SQL Server 2012 and 2014 on the same machine , how can I uninstall SQL Server 2012 withou…

  sriravio_nbn

  1 replies

  11 years ago

  By: spaghettidba

• what happens if i shrink the database with Truncate only and take a transaction log back up or full backup

  Hi , I would like to know what happens if i shrink the database with truncate only option and do a …

  Steve Dell

  9 replies

  11 years ago

  By: Grant Fritchey

• SQL server 2014 pricing for standard edition

  Hello All, I have a virtual server with 4 cores. We are planning to install SQL server 2014 Standar…

  SSRS Newbie

  3 replies

  11 years ago

  By: Lynn Pettis

• To get the average of two largest number amount three column for particular identity.

  ID A B C AVG ------------------------ 1 08 09 10 - ------------------------ 2 …

  Uday3421

  11 replies

  11 years ago

  By: Jeff Moden

• Cannot Open Datafile when running Agent Job

  Hello, I recently installed standalone version of SQL 2014 Standard on my work computer. I used Acc…

  xddevv

  10 replies

  11 years ago

  By: ZZartin