SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• AVG Disk Transfer goes out of scale randomly

  Hi there guys. I bring to you this strange situation where a Disk D would go out of scale (AVG DIS…

  agustingarzon

  4 replies

  8 years, 2 months ago

  By: TheSQLGuru

• Data file directory appears to be using loads of space after instance restart, but data files don't appear to be getting any larger

  Hi, I was wondering if someone could give me pointers on the issue I'm experiencing.  I'm an a…

  kcorbett 90007

  3 replies

  8 years, 2 months ago

  By: Arsh

• Queries taking longer than usual time for a subset of inputs when reaching the end

  Hi all,I would explain my problem in detail.We have a c# code that calls a sql query viz. a T.Sql q…

  er.mayankshukla

  8 replies

  8 years, 2 months ago

  By: er.mayankshukla

• Calculating averages

  I have the following sql code that gets me Total no of days taken for each workflow step to process…

  SQLPain

  9 replies

  8 years, 2 months ago

  By: Ed Wagner

• Does HIPAA require that test data not have any real data?

  This is a question that I'd ask in a free form forum, but I couldn't find one. If I've missed it, p…

  Doctor Who 2

  9 replies

  8 years, 2 months ago

  By: Avi1

• Select queries deadlocking each other??

  I have run into something strange. I have a SQL Server database up in Amazon RDS. It is on a 2012 S…

  Subhrochit

  4 replies

  8 years, 2 months ago

  By: Subhrochit

• Left outer join make duplicate column name

  I used code below to select 10 temp tables as one row table.All 10 tables has the same column [File…

  adonetok

  9 replies

  8 years, 2 months ago

  By: jcelko212 32090

• Help me with the SQL syntax

  Good Day!What I need is a SQL syntax that will display the start and end date for each time span wh…

  mw_sql_developer

  1 replies

  8 years, 2 months ago

  By: Luis Cazares

• When you migrate a database to the same SQL build, but a new environment, post migration tasks?

  Hello everyone, I was curious as to peoples take on the following... Lets say you have to move a da…

  Duran

  4 replies

  8 years, 2 months ago

  By: Duran

• SSIS issues after changing servers with character sets or code page or whatever its called

  I am having my ssis package fail when converting characters not supported by our iseries.  Thi…

  Dave C.

  5 replies

  8 years, 2 months ago

  By: Sue_H

• DBCC CHECKDB - Offload to another server.

  Hello, Like many organisations, we run DBCC CHECKDB on a weekly basis. However it is such a resouce…

  SQL_Cat

  6 replies

  8 years, 2 months ago

  By: Arsh

• question on clustering and standard edition in sqlserver 2012

  Does SQLServer 2012 SE support clustering between an A-P cluster (SE) and another A-P cluster(SE). …

  Pyman

  6 replies

  8 years, 2 months ago

  By: Pyman

• Transaction Logs in Status 2 for no apparent reason

  I've got a SQL 2012 Server in a 3 Node Always On Configuration. Version: 11.0.5058, so SP2. We are …

  Leo.Miller

  6 replies

  8 years, 2 months ago

  By: Beatrix Kiddo

• SQL 2012 AlwaysOn - Secondary/DR replica on different domain

  Hello Folks, Is it possible to enable AlwaysOn secondary replica hosting on a different domain. Any…

  SQL!$@w$0ME

  4 replies

  8 years, 2 months ago

  By: Sue_H

• Append variable to query

  Hi, declare @Value varchar (20)SELECT @Value = case when @status = 'Y' then '' else 'top 500 ' en…

  vigneshlagoons 51204

  8 replies

  8 years, 2 months ago

  By: Avi1