SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Concatenate variable values in the third variable in sqlcmd

  :setvar Instance SUBSTRING(@@SERVERNAME,7,3) :setvar FolderPath "\\Here\there\where" I have two sq…

  peacesells

  3 replies

  12 years ago

  By: Jeff Moden

• Load Balancing and fail over cluster

  Is there such a thing called 'Load balancing' on fail over cluster? any input helps

  Tac11

  2 replies

  12 years ago

  By: Tac11

• Server Performance Issue

  Hi Experts, We are seeing CPU spikes at a particular time everyday and it last for 15 minutes? How …

  VastSQL

  3 replies

  12 years ago

  By: Grant Fritchey

• Removing joins & Execution Time

  Hi, I do have a general question. I have a query which contains 12 left outer join. I remove some …

  ramana3327

  6 replies

  12 years ago

  By: Grant Fritchey

• Modifying SSIS package stored in File Systesm

  Hi, I have a ssis package stored in file system and I need to modify this package. How can I do thi…

  sql_novice_2007

  7 replies

  12 years ago

  By: Koen Verbeeck

• remove date constraint from a query

  I am trying to remove the dates from a query. my goal is to load it in ssas and add a time dimensio…

  tamzgha

  1 replies

  12 years ago

  By: pietlinden

• Query

  Hi All, I do have table Ex: customer. I do have some select statements based in where clause studen…

  ramana3327

  6 replies

  12 years ago

  By: Jeff Moden

• automatically create insert statements for table data

  Hi, How to create insert statements of the data from a table for top 'n' rows. I know we can create…

  SQListic

  4 replies

  12 years ago

  By: SQListic

• Shrink runs forever

  Hi all, We have dropped a huge table from one of our databases and I want to get some of that spac…

  shahgols

  16 replies

  12 years ago

  By: Jeff Moden

• SSIS stops with communication link failure if I lock my PC whilst it's running

  Hi Guys, I'm updating my dev server with data from a production environment via the SSIS Wizard out…

  BenWard

  4 replies

  12 years ago

  By: BenWard

• Slow SQL install on Windows 2012

  Hi, I've done a few SQL2012 on Windows 2012 installs. I've found that the install waits for up to …

  simon.letts

  4 replies

  12 years ago

  By: simon.letts

• Stored Procedure performane hit after migrating to 2012

  Hi All, Recently we have migrated sql server 2008R2 server to 2012, But after migration one of the…

  chinna1990

  3 replies

  12 years ago

  By: Grant Fritchey

• sql help

  how do i change connection database from master database to own database please

  sqladmin 33439

  3 replies

  12 years ago

  By: Eirikur Eiriksson

• SSMS 2012 Restarts Itself

  When I close SSMS 2012 it will restart. I can click the X or click File Exit; however, SSMS will r…

  DeWayne_McCallie

  10 replies

  12 years ago

  By: mister.magoo

• SQL Alis for application

  I have 3 instances dev,qa and uat of sql 2012 on one windows server. Here are names. 1) sql-001\dev…

  dallas13

  1 replies

  12 years ago

  By: Hema kumar-337490