SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• After group, which one option in SQL should be selected to match Access "First" option?

  I have a project to convert query in Access to SQL views.In Access query, once adding a group, ther…

  adonetok

  3 replies

  8 years, 7 months ago

  By: John Mitchell-245523

• TEMPDB log growing HUGE

  Running SQL 2012 SP3 CU6 AlwaysOn.... we had an issue two nights ago with the tempdb log filling th…

  jsqldba

  12 replies

  8 years, 7 months ago

  By: jsqldba

• Single Node MSSQL 2012 cluster to Always on

  We need to migrate one of our MSSQL instances in Production . The outgoing replication is to Inform…

  Abhishek

  9 replies

  8 years, 7 months ago

  By: Perry Whittle

• File server as a part of SQL cluster resource

  I want to know what is the purpose of File server as a part of SQL cluster resource .I have quorum …

  Abhishek

  3 replies

  8 years, 7 months ago

  By: Perry Whittle

• SQL version not getting updated after applying service packs and cumulative update

  there is an unexpected mismatch in SQL versionafter the update SSMS version \ TSQL : 11.0.5582.…

  Abhishek

  2 replies

  8 years, 7 months ago

  By: Abhishek

• Best practice

  I am looking for advice on what is the best and most efficient way to pull data out of Access, woul…

  cbrammer1219

  3 replies

  8 years, 7 months ago

  By: Alan Burstein

• Downgrading database from SQL Server 2016 to SQL Server 2012

  I have found myself in a situation where I need to downgrade a database from SQL Server 2016 to SQL…

  dirk.dromgoole 30656

  13 replies

  8 years, 7 months ago

  By: dirk.dromgoole 30656

• Help needed with configuring sp_rename ( Works well but how do we include the schema name )

  The following works well as it is...( if you enter the name of the object without the schema name i…

  mw_sql_developer

  8 replies

  8 years, 7 months ago

  By: Ed Wagner

• SSIS Data Flow vs SQL Stored Procedure Loop

  Hii have a stage table with lots of records and need to move to the final table.  When moving …

  ShuaibV

  6 replies

  8 years, 7 months ago

  By: frederico_fonseca

• SSIS Script Transformation

  I have flat file source and redirecting the error rows.  Using the script transformation to co…

  ShuaibV

  4 replies

  8 years, 7 months ago

  By: ShuaibV

• I want to develop a tool to do following analysis with SQL. How to write the code for the same?

  Company Y is a manufacturer of consumer products and engages directly with the customers. Customers…

  vibhoryadav23

  1 replies

  8 years, 7 months ago

  By: Eirikur Eiriksson

• COMPUTED COLUMN needing to retain value

  I need to restore a value in my travellog table by adding a computed column called confirmDate: TAB…

  Zososql

  8 replies

  8 years, 7 months ago

  By: Sergiy

• OutFile in SQL Agent

  Is there possibility for a SQL job to output file to two different paths in Advanced Option in the …

  PJ_SQL

  3 replies

  8 years, 7 months ago

  By: PJ_SQL

• Why can't I put database in READ_ONLY using SQLCMD from a remote Server?

  Hi Everyone, I'm using MS SQL 2005 - sqlcmd on a windows 2003 box (yes not complaint!!)   &nbs…

  sqlsurfing

  3 replies

  8 years, 7 months ago

  By: Gail Shaw

• how to change floor function to Round

  Here is the FLOOR function I am using , as I know FLOOR will take one paramter but I want…

  mcfarlandparkway

  5 replies

  8 years, 7 months ago

  By: Luis Cazares