SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• The value returned from sys.sysindexes in the rowmodctr column for HEAPS.

  Hi, Just wondering if anyone can clarify the value that is returned from sys.sysindexes in the rowm…

  JayK

  2 replies

  11 years, 5 months ago

  By: JayK

• SQL 2012 cluster downgrade to 2008 R2

  Ok I'm new, but not new enough not to have seen many of the complete uninstall advice out there. W…

  DB the DBA

  3 replies

  11 years, 5 months ago

  By: Perry Whittle

• Which Version of SQL Server should I Study?

  Hello Everyone, I decided to become an SQL Server DBA and wanted to know which version of SQL Serve…

  jeffgonzalez007

  12 replies

  11 years, 5 months ago

  By: Koen Verbeeck

• SQL server 2012 Express Install errot

  Hi all, I had downloaded SQL Server 2012 Express from http://www.microsoft.com/en-in/download/detai…

  GuruGPrasad

  1 replies

  11 years, 5 months ago

  By: Robert Klimes

• Merge statement when matched then update, I would like to use the OUTPUT.

  Hello all, We are importing data (parent/childrows) from another database. Problem as always is the…

  ben.brugman

  5 replies

  11 years, 5 months ago

  By: spaghettidba

• IDENT_CURRENT question

  I ran some codes below. SELECT count(*) FROM Member // result: 1106 select Max(ID) FROM Member …

  adonetok

  1 replies

  11 years, 5 months ago

  By: Grant Fritchey

• Performance issue on 2012

  Hi , In past we have SQL Server 2008 R2 stand alone server which is running very fast and no perfor…

  venkat5677

  5 replies

  11 years, 5 months ago

  By: TheSQLGuru

• SSIS 2012 script task giving an error:DTS Script Task Runtime Error

  I am using script task for assigning variables values etc. I am using external dll's which are in G…

  t.pratiksha

  1 replies

  11 years, 5 months ago

  By: SoHelpMeCodd

• SSIS Configuration

  HI, I am unable to find Configuration button in SSIS menu in SSIS 2012. In 2008 , i have Configurat…

  PRAMANA.DBA

  2 replies

  11 years, 5 months ago

  By: s_osborne2

• Failover clustered instance with availbility groups

  This question is just a sanity check approach 1: Prod - shared storage between server 1 and 2 Serve…

  SQLAssAS

  4 replies

  11 years, 5 months ago

  By: Perry Whittle

• Availability Group Listener Port

  Hi, So I have Availability groups configured as well as the Availability Group Listener, what I wou…

  Ford Fairlane

  5 replies

  11 years, 5 months ago

  By: Perry Whittle

• AlwaysOn - Is a fileshare witness really needed?

  I have seen many recommendations stating that if you have an even number of nodes, then you should …

  bbcolo22

  3 replies

  11 years, 5 months ago

  By: Perry Whittle

• Cluster Windows Server 2012R2 + SQL Server 2012

  I have 2 servers in the array (SRV and SRV-001-002) with SQL Server 2012 SP2 and Windows Server 201…

  dbtask.sqlserver

  3 replies

  11 years, 5 months ago

  By: EdVassie

• Same SQL Server Instance name on two different Windows 2008 R2 servers

  Hi, We have two different Windows 2008 R2 servers (Server1 and Server2) on the same domain. The…

  raghusg

  7 replies

  11 years, 5 months ago

  By: Steve Jones - SSC Editor

• Is there a way to monitor the network traffic - Dynamic SQL vs Stored procedures

  Dear All There are lots of opinions and debate regarding the following topic. Performance under exe…

  Marimuthu Sakthivel

  2 replies

  11 years, 5 months ago

  By: Marimuthu Sakthivel