Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Can't see "AlwaysOn High Availability" when connecting to SSMS via the Listener

  All, I have installed two standalone SQL 2014 Ent Edition instances. I have check that both "Always…

  cavazos_luis

  1 replies

  10 years ago

  By: Lawrage

• Voute Count Not Available - ( Warning in Clustring & Problem With Alwayson AV)

  Hi oldHands I still Get stock on Clustring for Alwayson-AvailabilityGroup. We want to setup an avai…

  MotivateMan1394

  2 replies

  10 years ago

  By: subramanian.esakkimuthu 40485

• SSRS Report Samples

  Are there any available SSRS 2016 Report samples out there? I'd like to introduce our BI/Reporting…

  ImYourDBA

  1 replies

  10 years ago

  By: ImYourDBA

• AlwaysOn transaction error 9002: the transaction log for database '' is full due to 'AVAILABILITY_REPLICA'

  I have proper full and trans backup jobs set for both AlwaysOn Availability Group replicas. The is…

  chrisph

  21 replies

  10 years ago

  By: babo

• why planner is shorting in group by , can i elemenate sorting.

  hi, CREATE TABLE [dbo].[T2]( [A1] [bigint] NULL, [D1] [bigint] NULL ) ON [PRIMARY] SELECT d…

  rajemessage 14195

  4 replies

  10 years ago

  By: Phil Parkin

• SQL Agent service is no longer showing in Configuration Manager

  Microsoft SQL Server 2012 (SP3-CU1) (KB3123299) - 11.0.6518.0 (X64) Jan 7 2016 14:39:01 Copyrigh…

  WHug

  2 replies

  10 years ago

  By: WHug

• When does locking START?

  Morning All, Hope you're all well and had good weekends. Quick question regards locking, particular…

  alex.sqldba

  4 replies

  10 years ago

  By: Gail Shaw

• install standalone instance on cluster shared disks

  Hi, I looking for documentation how bypass limitation of installation of standalone instance(s) on…

  ebooklub

  4 replies

  10 years ago

  By: Joie Andrew

• Who is successfully running VSS snapshots with any third party Backup software without any collisions?

  I am currently using RedGate Backup Pro 7, which I love, no complains. But since Nimble VSS backups…

  sql-lover

  14 replies

  10 years ago

  By: Lynn Pettis

• More than a two-part column name - Depricated Features

  Was looking at deprecated features in future versions of SQL in the sys.dm_os_performance_counters …

  gideon_king

  6 replies

  10 years ago

  By: Jeff Moden

• Read and write block sizes of SQL server

  Hi Experts, The data which are stored in pages are of 8 KB. When SQL server writes, does the block …

  Ravid_ds

  1 replies

  10 years ago

  By: subramanian.esakkimuthu 40485

• Adventureworks database for SQL Server 2016

  On Microsoft's website https://msdn.microsoft.com/en-us/library/hh231699.aspx they point to AW of …

  curious_sqldba

  8 replies

  10 years ago

  By: Gareth Swan

• Blocking Writes while creating non clustered index

  Hi, I am trying to create a non clustered index with ONLINE on a table(say tableA), I am having a h…

  SQLFreak12

  7 replies

  10 years ago

  By: SQLFreak12

• Import millions row data from MySQL to MS SQL

  Hi All, I am very new to learning SQL Server, now I have to project to import data from MySql to Sq…

  henrywinata

  7 replies

  10 years ago

  By: subramanian.esakkimuthu 40485

• Performance / Query Tuning Question Regarding Missing Indices

  Evening All, I am using some of the DMV's to identify missing indices on tables and their potential…

  alex.sqldba

  8 replies

  10 years ago

  By: alex.sqldba