SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• SQL Memory Consumption

  I am looking for a way to easily explain SQL memory consumption to an Oracle DBA. I am also looking…

  mceventphoto

  3 replies

  10 years ago

  By: mceventphoto

• Create SP to add new column based on other table data.

  I have One Metadata table, which has got all tablenames, column names and their datatypes. we are c…

  Sangeeth Raj

  4 replies

  10 years ago

  By: Steve Jones - SSC Editor

• Email Notification Help using: sp_Send_dbmail, EXISTS statement, and data query

  Hello, I would like to use sp_Send_dbmail to send an email notification if specific data exists. I…

  rjjh78

  1 replies

  10 years ago

  By: Lowell

• SSMS Confusion

  Morning all Got a slightly unusual one here - we have a server in Russia that the outsourced IT Sup…

  peter.cox

  2 replies

  10 years ago

  By: peter.cox

• replication failure offset is not in the range of available lob data

  How to find what is causing the issue?

  PJ_SQL

  3 replies

  10 years ago

  By: PJ_SQL

• Aliasing Tables

  Hi Is there a way of aliasing tables at database level? so every time you need the table you can j…

  erics44

  2 replies

  10 years ago

  By: DouglasH

• Replication question

  I have server A with two publisher to server B and server C. When I reinitialize the publisher I ne…

  PJ_SQL

  1 replies

  10 years ago

  By: kreuzer

• Commonly used DMVS in sql server

  hi everyone, what are the most commonly used DMV's in sqlserver as a DBA.

  naveenareddy

  1 replies

  10 years ago

  By: Jeff Moden

• Simple Store Procedure for delete rows in a SQL 2012 table

  Hello, I want to create a store procedure, which I have never done before and intimidating. I want…

  alex_martinez

  8 replies

  10 years ago

  By: alex_martinez

• Recovering a table from TB database

  Hi, I have a 5TB database and one of my customer accidentally deleted a table. I have EMC backup ru…

  narayanamoorthy.a

  4 replies

  10 years ago

  By: Thomas Rushton

• Database Compare / Collation issues

  Hi I am trying to update a much out of date UAT database from the current production. There are how…

  erics44

  9 replies

  10 years ago

  By: erics44

• MDS - Audit

  Hi, I was wondering if anyone had a method for auditing changes in an MDS entity member. For exampl…

  NicHopper

  3 replies

  10 years ago

  By: NicHopper

• Find the long running query and kill it

  All, wondering if I can get some help? I am trying to find a script which can help me accomplish th…

  Chitown

  11 replies

  10 years ago

  By: Michael L John

• Availability Group Errors

  I've set up a test availability group with a test db. there's no app that connects to the db. I rec…

  stiej1977

  1 replies

  10 years ago

  By: Perry Whittle

• Always On, as a DR site.

  Hi, We have set up an Always On, SQL Server 2012, as a proof of concept. What we want to do, is use…

  Leonard Rutkowski

  11 replies

  10 years ago

  By: Perry Whittle