SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Adding YYYYMMDD and HHMMSS to get mm/dd/yyyy HH:MM:SS

  I am writing some reporting queries to show execution start and end times of my SQL jobs. I need to…

  SQLCurious

  10 replies

  11 years, 10 months ago

  By: Jeff Moden

• Strange backups in sql server logs

  I have an sql 2012 express server. Just checked the server logs and found that every day ~1PM ever…

  stmarti

  11 replies

  11 years, 10 months ago

  By: Ed Wagner

• SQL Backups versus TSM TDP SQL (Tivoly Storage Manager)

  Hi Everyone, I have a big dilemma I have to decide between a Traditional SQL Backups and Restores a…

  APA0876

  2 replies

  11 years, 10 months ago

  By: APA0876

• Help needed on Sybase to Sql 2012 migration

  Hi All, I have recently joined to Sybase to sql server 2012 migration team. Sybase source has close…

  Suresh Arumugam

  9 replies

  11 years, 10 months ago

  By: Suresh Arumugam

• Specify SQL Server Installation location when Adding second node to Cluster

  When adding a node to a SQL Server 2012 Standard edition cluster, how I do I identify the location …

  David Bird

  3 replies

  11 years, 10 months ago

  By: EdVassie

• 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months ago

  By: BenWard