SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Use the same execution account for SSAS and SQL DB 2012

  Hello, When I installed my SQL 2012 instance I was asked to choose a service account for SSAS, SSIS…

  Lord Slaagh

  1 replies

  11 years, 10 months ago

  By: Lord Slaagh

• General practice for MAXDOP setting

  Hi DBA's, I was looking for a general practice you follow in order to set MAXDOP setting on a SQL i…

  RPSQL

  10 replies

  11 years, 10 months ago

  By: SQLRNNR

• Bulk insert

  "The SQL login requires 'DBowner' rights to temptb to allow Bulk Insert. The way that SQL works mea…

  SQLAssAS

  3 replies

  11 years, 10 months ago

  By: Gail Shaw

• Ignore ANSI Characters in data comparison

  I am comparing two fields one from our legacy table and one in our new table structure that should …

  caippers

  4 replies

  11 years, 10 months ago

  By: caippers

• I need a Query for this (Bit Urgent)

  Hi, I need a Query for calculating the fiscal_week based on the input dates (start_date and end_da…

  prabhu.st

  4 replies

  11 years, 10 months ago

  By: prabhu.st

• Availability Groups - Missing Objects

  I would like some help/assistance in synchronizing all the missing objects (logins, agent jobs, SSI…

  exoracle123

  2 replies

  11 years, 10 months ago

  By: exoracle123

• how to uninstall sql server

  Hi all, Last week I have installed SQLServer 2012 Enterprise. Prior to that, last year I have insta…

  SpeedSkaterFan

  17 replies

  11 years, 10 months ago

  By: SpeedSkaterFan

• Filtered indexes in sql server 2012

  Hi, What are driving criteria for creating filtered indexes on SQL server. I am trying to analyze t…

  Sindhu Ravi

  8 replies

  11 years, 10 months ago

  By: Sindhu Ravi

• Establishing Guidelines for Testing/Deploying SSIS Packages

  We are running SQL Server 2012 on Windows 2008 Server using Visual Studio 2010/2012 and SSDT. We ar…

  HookSQLDBA7

  4 replies

  11 years, 10 months ago

  By: HookSQLDBA7

• Uninstall SSAS on SQL 2012

  Hello, I am trying to uninstall/reinstall my SSAS instance on a SQL 2012 box, but I am not sure how…

  Lord Slaagh

  1 replies

  11 years, 10 months ago

  By: Lord Slaagh

• Tables on seperate filegroups.

  Hi All We have a large Datawarehouse and the size is 50TB.. The tables are placed in filegroups bas…

  senthil kumar d

  11 replies

  11 years, 10 months ago

  By: SQLRNNR

• After install of SQL 2012 SP2 on Server 2012, the SQL disks now say access denied

  Hi All Strange one that I have never seen before. Just installed SQL 2012 SP2 on a fresh install of…

  Ant-Green

  4 replies

  11 years, 10 months ago

  By: Ant-Green

• SQL 2012, DB backup failed because of error 9002

  SQL server 2012, SP1 DB is in SIMPLE recovery mode (total size 124 GB). Log file Initial size is 65…

  - Win

  19 replies

  11 years, 10 months ago

  By: Beatrix Kiddo

• Unable to connect to redirector

  I use SQL Server 2012 Management Studio, SQL Server Data Tools and Visual Studio 2012 to deploy a d…

  nirmalkumarg3

  2 replies

  11 years, 10 months ago

  By: nirmalkumarg3

• change readonly and readwrite

  Can a user of db owner role of a database change the databse option to read only and read-write? I…

  sqlfriend

  1 replies

  11 years, 10 months ago

  By: SoHelpMeCodd