Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Most unhelpful error message?

  Anyone else have a story about unhelpful error messages? Got an error message "an invalid director…

  Carl Federl

  4 replies

  10 years ago

  By: Alan Burstein

• Limited Objects in drop down list for 'SQL Server Performance Condition Alert'

  Hi I am running sql2014 version 12.0.4100 (SP1). When I add a new alert, then choose type 'Sql serv…

  PearlJammer1

  2 replies

  10 years ago

  By: PearlJammer1

• Not able to configure SQL Server database mail using TLS port 587 using Gmail. Gmail is blocking attempts with SSL port 465.

  Hi, I am using SQL Server 2008 and configuring database mail using a Gmail account. Gmail is blocki…

  Amar009

  4 replies

  10 years ago

  By: Amar009

• Why can't you install all components of SQL Server in more than one instance?

  Hi, I saw the following statements in a SQL DBA 2008 R2 and 2012 class text, and wondered why you c…

  RickNPHX

  2 replies

  10 years ago

  By: Grant Fritchey

• Big difference of SP execution on two servers

  Hi All, Server 1 (cluster) Microsoft SQL Server 2014 (SP1-CU3) (KB3094221) - 12.0.4427.24 (X64) Oc…

  Igor Micev

  6 replies

  10 years ago

  By: Igor Micev

• FK and Index

  Hi Experts, We have more than 100 Foreign Keys with no supporting index. Do we need to add index on…

  VastSQL

  14 replies

  10 years ago

  By: Chinnappan Balan

• SQL Server Memory is Full (Urgent help!)

  We have production SQL Server 2012, where we had allocated Max memory of ~60 GB and Min Memory of 4…

  info.sqldbamail

  21 replies

  10 years ago

  By: Grant Fritchey

• Database Backup Terminating Abnormally (Disaster) :(

  Backup Error Error:3203, Severity 16, state 1 Read on "D:\MSSQL\DATA\database.mdf" failed: 1(Incorr…

  elie.etaxpoint

  15 replies

  10 years ago

  By: Gail Shaw

• grant administer bulk ops is being ignored?

  I have an error - "You do not have permission to use the bulk load statement", so i open up SSMS an…

  david mclaughlin

  1 replies

  10 years ago

  By: VastSQL

• SSIS Packages Job fails no information in Job History

  I have two SSIS Package in which the Job fails and there is no information in Job History other the…

  Welsh Corgi

  14 replies

  10 years ago

  By: Welsh Corgi

• SSIS Package logging error - SSIS

  We are using project deployment model for SSIS. For one of the packages, which writes the log to a …

  SQL!$@w$0ME

  10 replies

  10 years ago

  By: SQL!$@w$0ME

• Stored Procedure Slow

  hello, I have a stored procedure that it's slow, somebody can help me to optimize this stored proce…

  jeank007

  2 replies

  10 years ago

  By: Luis Cazares

• More AlwaysOn Availability Woes :)

  Evening All, Thanks to all the help from here earlier, I have a fairly successful 3-Node/Replica Al…

  alex.sqldba

  26 replies

  10 years ago

  By: alex.sqldba

• Tier 1 database experiencing accelerated growth after conversion

  Greetings all; Not sure if anyone else has experienced this but this past March I moved a tier 1 …

  Kurt W. Zimmerman

  3 replies

  10 years ago

  By: Kurt W. Zimmerman

• Lock Escalation: 5000 to 1?

  If a row lock hits its memory threshold for locks, lets say in this case it is exactly 5000, and a …

  Firemander

  3 replies

  10 years ago

  By: Chinnappan Balan