SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• tempdb IO Problem !

  I have a database which has high temp table usage. Recently, I'm facing to tempdb's raid high IO us…

  farax_x

  1 replies

  11 years, 5 months ago

  By: lmarkum

• Edition Upgrade from MS SQL 2012 C0 to MS SQL 2012 Enterprise

  I have attempted an Edition upgrade from MS SQL Server 2012 C0 to MS SQL Server Enteprise on two oc…

  Kenneth Igiri

  7 replies

  11 years, 5 months ago

  By: maliqiakbar

• SSMS - Import Package Error

  SQL 2012 - While Importing a package to msdb, i am getting below error. SQL is in cluster. I tried …

  balasach82

  3 replies

  11 years, 5 months ago

  By: balasach82

• which option is best??

  hello, we have a number of possibilities but wanted to know peoples thoughts or stories: we have a …

  lilywhites

  9 replies

  11 years, 5 months ago

  By: lilywhites

• SQL linked server

  I am trying to create a linked server from SQL 2012 to 2008 by using a domain account. This domain …

  will75

  2 replies

  11 years, 5 months ago

  By: will75

• Maintenance Plan modify to a script?

  I have created a maintenance plan using the wizard in SSMS. It creates a full backup on my DB 4 tim…

  cbernardes

  3 replies

  11 years, 5 months ago

  By: cbernardes

• Backup to clear the transaction log

  Hi, quick dba question if anyone can help. Looking at the recovery model on MSDN - was under the be…

  rob.lewis 86087

  7 replies

  11 years, 5 months ago

  By: rob.lewis 86087

• Bizarre Transaction Replication Issue Subscription Status 3(!?!)

  Hello. Right, I really hope there is someone out there can explain this to me. First, the details..…

  Duran

  2 replies

  11 years, 5 months ago

  By: Duran

• When do you use CREATE DATABASE ... WITH FOR ATTACH_REBUILD_LOG?

  So I'm brushing up on my T-SQL and came across the ever forgettable "FOR ATTACH_REBUILD_LOG" option…

  Brandie Tarvin

  9 replies

  11 years, 5 months ago

  By: Charles Kincaid

• Extended Events capturing info on Dev environment but not on PRO

  I do have the following Extended Event session on my Dev box; CREATE EVENT SESSION [sp_showplan] O…

  sql-lover

  5 replies

  11 years, 5 months ago

  By: S. Kusen

• Function with 2nd part working on results 1st part

  Hi all, I have made the following Scalar-valued function: CREATE FUNCTION [dbo].[TimeCalc] ( @O…

  SpeedSkaterFan

  9 replies

  11 years, 5 months ago

  By: Luis Cazares

• I have just started maintaining someone elses server and am waiting on training

  Hi Recently the data type for 2 columns in my external report that is schedule every week to come i…

  Phen

  4 replies

  11 years, 5 months ago

  By: S. Kusen

• queries

  What are the basic queries to trouble shoot the always on in sql 2012 ?

  ramyours2003

  1 replies

  11 years, 5 months ago

  By: Sean Lange

• Switching from one database to another within the same script.

  I would like to know how I can switch from one database to another within the same script. I have …

  RayMan007

  2 replies

  11 years, 5 months ago

  By: RayMan007

• Deadlock issue

  Hi, I'm having a deadlock issue that has me a little stumped. Here is the XML: <deadlock> &…

  Chris-475469

  7 replies

  11 years, 5 months ago

  By: Chris-475469