SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• xml render from SSRS 2012 returning an empty document

  Afternoon all, I have an SSRS report that is designed to query data from a database and produce an …

  Jessica_ST

  2 replies

  11 years, 10 months ago

  By: Jessica_ST

• tabular model cube

  Is it OK to call tabular model database as tabular cube? Pramod SQL Server DBA | MCSE SQL Server 20…

  psingla

  6 replies

  11 years, 10 months ago

  By: Koen Verbeeck

• Permissions for read only replica?

  I have an availability group with read only replicas, readable secondary set to yes and allow all i…

  dbassassin

  4 replies

  11 years, 10 months ago

  By: dbassassin

• Performance Tuning Methodology

  Hi all I was wondering where people start when tuning their SQL Servers, do people start by looking…

  Kwisatz78

  19 replies

  11 years, 10 months ago

  By: TheSQLGuru

• MSDB Access

  Hi, I'm having a strange issue on sql server 2012. Every time i create a new user which uses SQL Se…

  DBANewbie

  2 replies

  11 years, 10 months ago

  By: Matt Crowley

• Access rights to execute a stored procedure if there is no DML involved

  I would like to provide the db_datareader and db_executor role to a particular SQL Server Login in …

  Kingston Dhasian

  7 replies

  11 years, 10 months ago

  By: Sean Lange

• Recovery Advisor won't open or start for specific database

  Greetings - Today we were trying to use restore wizard (recovery advisor) to restore a database whi…

  lsalih

  1 replies

  11 years, 10 months ago

  By: lsalih

• dbcc checkdb is running automatically at MS SQL 2012

  Hi Why "DBCC CHECKDB WITH physical_only executed" run across my instance for every database althoug…

  adzuanamir

  5 replies

  11 years, 10 months ago

  By: adzuanamir

• Index rebuild maintenance plan

  Hi, when we execute maintenance plan for index rebuild, does SQL server rebuild indexes in any orde…

  @Murali

  11 replies

  11 years, 10 months ago

  By: TheSQLGuru

• SSAS Upgrade from 2005-2012

  Hello all, Quick question... I am in the process of moving my 2005 SSAS cubes to 2012. From what I …

  Lord Slaagh

  2 replies

  11 years, 10 months ago

  By: Lord Slaagh

• Job fails on first Wednesday of every month

  Morning all Got a job here that fails on the first Wednesday of every month. It's a complex job (6…

  peter.cox

  17 replies

  11 years, 10 months ago

  By: Greg Edwards-268690

• SQL 2012 Memory Leak?

  We have a SQL 2012 SP1 running 64bit in Window 2008. We are reviewing a possible memory leak in the…

  jol1185

  4 replies

  11 years, 10 months ago

  By: TheSQLGuru

• Fast in SQL 2008 and slow in SQL 2012

  I have a statement like: SELECT * FROM MyTable WHERE NOT PrimaryKey IN (SELECT Keys FROM #MyTempTab…

  cmartel 20772

  3 replies

  11 years, 10 months ago

  By: TheSQLGuru

• Possible to utilize something similar to a linked server login on the same server?

  We have a database that houses student data for 20+ school districts. The designers opted to put a…

  trek2120

  2 replies

  11 years, 10 months ago

  By: EdVassie

• Linked Server to SQL 2000 from SQL 2012

  Hi Guys, I am able to create linked server to SQL 2008 from SQL 2012 and it works fine; however, I …

  Laura_SqlNovice

  8 replies

  11 years, 10 months ago

  By: Martin Stephenson