SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• SQL 2008 SSIS Package error

  HI Experts, I am getting below error when ran an SSIS package as job Source: ABC_2 5_DCC_3 0_Sync v…

  VastSQL

  12 replies

  11 years, 10 months ago

  By: Umer Akram

• Always on pending changes

  Hi Experts, How to find the pending transactions to be applied on secondary in Always On? Can i get…

  VastSQL

  2 replies

  11 years, 10 months ago

  By: VastSQL

• Instance crash and memory leak

  Hello, Since about 2 months (in fact, since these databases are in production mode), we encounter a…

  cedric.carbier 89918

  5 replies

  11 years, 10 months ago

  By: cedric.carbier 89918

• Fixing Idx from Varchar to INT, why became slower !!!?

  Hi, I have an indexed view and i can't get why after "fixing" one of index it became slower then be…

  mario17

  3 replies

  11 years, 10 months ago

  By: Grant Fritchey

• sql server performance issue

  Hello, I am running into some sqlserver performance issues. I have a table in (sqlserver 2008 R2) o…

  subramanyam.mekala

  1 replies

  11 years, 10 months ago

  By: Grant Fritchey

• Error processing cubes

  Hello, I just finished migrating SQL 2005 - 2012 and I am having issues processing my cubes. I incl…

  Lord Slaagh

  1 replies

  11 years, 10 months ago

  By: barsuk

• Hide databases that don't have access to them SQL

  Is there a way to hide databases that users don't have access to? I read articles on denying the p…

  bucknick

  5 replies

  11 years, 10 months ago

  By: Sean Lange

• Allow for User Provided Number of Columns in Select Statement

  Hi, I am currently trying to write a query that pulls a summation of item specific data from sales…

  o103452@rtrtr.com

  1 replies

  11 years, 10 months ago

  By: Jack Corbett

• Same database on multiple cluster nodes for performance?

  Hello, is it possible to create a cluster configuration, where 2 (or more) SQL Server instances run…

  protix

  15 replies

  11 years, 10 months ago

  By: Gail Shaw

• Slowness in 2012 iwth W authenication

  Hi, all I have W authentication on 2012, when I do connect my engine it takes 5+ seconds, when I do…

  mario17

  1 replies

  11 years, 10 months ago

  By: Eirikur Eiriksson

• present yyyymm in format good for calcuation

  HI, all I'm working on setup where we have period like 201401 ( jan 2014), etc... And it'ts INT, h…

  mario17

  9 replies

  11 years, 10 months ago

  By: Jeff Moden

• filter persist - not

  I set up filters on my tables and views stored procedures what not. Next time I fire up Managemen…

  bogusemail28

  3 replies

  11 years, 10 months ago

  By: david.john.gilligan

• Single Multi-Tenancy DB with 100K concurrent connections

  I have a DB that is currently not normalized and will be getting about 100K concurrent users that w…

  eazarela

  1 replies

  11 years, 10 months ago

  By: x

• CTE ignores the data in the second join

  Hi, I have created a common table expression. The first query is meant to select a particular month…

  mic.con87

  9 replies

  11 years, 10 months ago

  By: Lynn Pettis

• MDS, Domain Attributes, and the Excel Add-In

  Can you separate a domain attribute into two columns in the Excel Add-In? We are using the Excel Ad…

  acapone

  2 replies

  11 years, 10 months ago

  By: acapone