Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• shrink huge datafile

  after a huge data purging i've to shrink 1 datafile from 2tb to 100gb, but in this file there is an…

  sgt500

  3 replies

  11 years ago

  By: Jeff Moden

• SQL Nexux

  Hello, I am trying to use SQL Nexus but getting an error on .TRC file while importing. The error i…

  workaholic78

  3 replies

  11 years ago

  By: workaholic78

• Third party tools to compare data in SQL Server 2014 and Oracle 10g/11g

  Trying to find out some tools that would allow a comparison of data in SQL Server and Oracle. Pleas…

  HookSQLDBA7

  3 replies

  11 years ago

  By: Lowell

• Kerberos target resolution error

  Hello all, I have 2 server running 1 standalone instance of SQL Server 2014 each. I am using Allway…

  Arestas

  1 replies

  11 years ago

  By: Arestas

• Installation Directories Folder

  Just a question on an installation as I need to split out the binaries and system databases. I am r…

  DA777

  5 replies

  11 years ago

  By: spaghettidba

• What can I do to speed up my production daily full-backup?

  Current backup plan is a full backup every night, starting at 2am. Starts with system database back…

  csheldon

  18 replies

  11 years ago

  By: sgt500

• Can we install SQL server 2012/2014 in VM without purchasing SA ?

  Hi All, Anyone is aware, if we need to have Software Assurance (SA) purchased to install SQL server…

  Joy Smith San

  5 replies

  11 years ago

  By: Joy Smith San

• SQL Server database in Dropbox sync folder accessing from multiple computers?

  Hello I am a complete novice on SQL Server. I currently use Access and have found that I need to m…

  biocentrism

  7 replies

  11 years ago

  By: Gail Shaw

• Error when trying to use @query parameter with sp_send_dbmail

  Hi, I don't understand why I am getting an error when I try to run the following statement. I am a…

  lmacdonald

  6 replies

  11 years ago

  By: JakDBA

• AlwaysOn failover cluster session failover

  Hi Expert, I need a advice. 1. Once fail over to secondary replica, what will happen to connected s…

  ashwan

  5 replies

  11 years ago

  By: Perry Whittle

• Can I use different index on main DB and mirror Database?

  Hi all, We use SQL server always on feather on my database and we distribute statement on main data…

  ram1447

  3 replies

  11 years ago

  By: Perry Whittle

• Check if UNC path exists (It is folder, not file)

  usual way to check if file exists DECLARE @File_Exists INT EXEC Master.dbo.xp_fileexist '\\serverB…

  i1888

  6 replies

  11 years ago

  By: johnwalker10

• Cursor stop query at specific time

  This store procedure will get some executable queries from the select statement, the cursor will fe…

  ypeng5

  8 replies

  11 years ago

  By: ypeng5

• SQL Agent Jobs and Availability Groups

  So this is my first foray into setting up AG on 2014, which will contain about 100 + SQL Agent jobs…

  ManicStar

  2 replies

  11 years ago

  By: ManicStar

• Drop database on secondary node after removed from Availability Group on primary node

  Hi all, I have an environment with MS-SQL Server 2014 and always-on availability group configured (…

  daniel.readyforspam

  4 replies

  11 years ago

  By: Perry Whittle