SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Trying to determine the permissions some users have between 2 tables

  We've got a legacy MS Access application which is the front-end to a SQL Server 2012 database. Our …

  Rod at work

  2 replies

  9 years ago

  By: Rod at work

• Migrating from old AO nodes to new AO nodes

  Hi, We are going to migrate our two node AO cluster to some new hardware in the coming weeks. And w…

  otm

  10 replies

  9 years ago

  By: Perry Whittle

• Logshipping job is not running every 15 mins even though it is scheduldled

  Hi ,Log shipping job is not running every 15 mins even though it is scheduldled. Please see the scr…

  gary1

  3 replies

  9 years ago

  By: gary1

• DB mail configuration ... setting retry attempts to zero

  I set the retry to zero  like this :Can anyone confirm that this look ok ?someone said it will…

  dvprao

  3 replies

  9 years ago

  By: Sue_H

• case when statement not displaying derived column data

  I am able to compare two dates in my recordset and subtract one from the other (eventadded and even…

  Zososql

  3 replies

  9 years ago

  By: drew.allen

• Always ON AG with FCI for Reporting with resilience (HA).

  Has anybody added a FCI to an Always ON AG? I was wondering if there were any do's and don'ts.…

  kkanaya

  3 replies

  9 years ago

  By: kkanaya

• sql server audit .trc pipe to Arcsight

  Hi All,just inherited a system where Arcsight is involved. Anybody have any experience to help me t…

  flaskvacuum

  2 replies

  9 years ago

  By: flaskvacuum

• TempDB on RAM Drive ?

  Our vendor application database is very tempdb intensive. TempDB (and all databases) are on Tier 1 …

  sqld-_-ba

  7 replies

  9 years ago

  By: EdVassie

• Extended events

  Hi! Can someone please explain me the following in the most understandable way?🙂 DBA newbie hereI'm…

  BiboKid

  2 replies

  9 years ago

  By: Eirikur Eiriksson

• 70-463 and 70-466 pre-requisit

  Hi All, could any one suggest is there any prerequisite exam I need to give before 70-463  : I…

  Virender Sihag

  2 replies

  9 years ago

  By: Virender Sihag

• Creating a derived column by subtracting a later date from a former date

  I need to calculate two date fields in the same recordset with DATEDIFF function (could be DATEPART…

  Zososql

  9 replies

  9 years ago

  By: Zososql

• How do I add an SUBSCRIPTION to a SSRS Report ?

  Please see attached ( Even if I click on MySubscription Link it does not have a button or link that…

  mw_sql_developer

  2 replies

  9 years ago

  By: Thom A

• The semaphore timeout period has expired while attempting 'FlushFileBuffers'

  Hi All, I'm having an issue with a SQL maintenance plan during the DB backup step. All of the DBs i…

  phil_mw60

  2 replies

  9 years ago

  By: phil_mw60

• combining three tables

  We have a 3 tables (1st with 12 cols, 2nd with 20 cols, and 3rd with 14 columns) from different sou…

  cabo 84147

  1 replies

  9 years ago

  By: sgmunson

• ReportServer/Subscriptions tbl - What does this value mean ?

  See attached. You will see a GUID value highlighted. What does this value represent. It only appear…

  mw_sql_developer

  1 replies

  9 years ago

  By: Sue_H