SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Numeric or Decimal Data Type in SQL 2012?

  Is there a preferred recommendation by database administrators of whether to use Decimal or Numeric…

  SilhouetteBS

  6 replies

  10 years ago

  By: Jon.Morisi

• Link Server with AS400 Data Issue

  Hi all, long time viewer, first time poster. My 2012 SQL Server has a linked connection with our le…

  eric_austin

  3 replies

  10 years ago

  By: Scott Mildenberger

• Asynchronous mirroring

  Hi Guys, We had an asynchronous mirror set up. When the link between the primary and mirror went do…

  crazy_new

  6 replies

  10 years ago

  By: crazy_new

• Multiple DataFiles on SAN disks?

  In the past, an i/o performance enhancing option was/is to split up your database into multiple dat…

  jsqldba

  12 replies

  10 years ago

  By: EdVassie

• Dealing with large tables (Financial transactions)

  Hi, We have in our production database a large table that is storing financial transactions, curren…

  Emil B

  26 replies

  10 years ago

  By: xsevensinzx

• SQL blocking sql_text

  I've got this query below to find the sql_text of the waiting process but how do I get the sql_text…

  smitty-1088185

  6 replies

  10 years ago

  By: Ricky Valencia

• INSERT failed because the following SET opitions have incorrect settings: 'ANSI_PADDING'

  I am in the process of moving a table of data that stores uploaded files. Within this table, I hav…

  James Parkhurst

  5 replies

  10 years ago

  By: Lynn Pettis

• How avoid to mention custom port number at destination server?

  Hi. SQL custom port number configured instead of default port 1433.. I need to mention custom port …

  SQL Galaxy

  2 replies

  10 years ago

  By: SQL Galaxy

• Monitoring Solution

  Hi, we have many server running mssql 2012. we have cluster, log shipping and mirroring setup on se…

  thbaig

  2 replies

  10 years ago

  By: thbaig

• error trying to shrink space out of database

  I have a new error today that i cant seem to find much information on.. I am trying to relase space…

  SQLAssAS

  7 replies

  10 years ago

  By: Sean Lange

• automate sql

  Does SQL Server Management Studio have the option to automate a query (and dump it in Excel) and em…

  cory.bullard76

  3 replies

  10 years ago

  By: Steve Jones - SSC Editor

• Automate stored procedure creation

  I have a Test database which is overwritten each week by a fresh new production copy. But we have c…

  ErickTreeTops

  7 replies

  10 years ago

  By: Jon.Morisi

• Merge replication using web synchronization

  I am trying to implement a merge replication using a web server. I have the publisher set up along …

  Srl832

  1 replies

  10 years ago

  By: Jon.Morisi

• SQL Server 2012 Witness server for SQL 2008 database mirroring

  Hello, I have quick question.. I have a database mirroring configured for two SQL Server 2008 R2 da…

  Robin35

  2 replies

  10 years ago

  By: Robin35

• Is this possible

  Here's what I'm trying to accomplish....I'm pulling week to date sales data (ex. if I were to run i…

  cory.bullard76

  9 replies

  10 years ago

  By: cory.bullard76