SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• 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, 8 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, 8 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, 8 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, 8 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, 8 months ago

  By: SoHelpMeCodd

• SSRS Security setting, can't get them on Report level

  Hi, I work on test SSRS setup and trying to give one user enough rights so she can download RDLs fr…

  mario17

  3 replies

  11 years, 8 months ago

  By: Nadrek

• SSIS set stored procedure parameter dates via SQL agent

  Hi All, I am new to SSIS and have been trying to work out how to do the following: To set the scene…

  acrutchley

  4 replies

  11 years, 8 months ago

  By: acrutchley

• Bulk Loading in Availability Groups

  I have several 2012 availability groups running on a cluster. I have one database that is bulk loa…

  Thor Bev

  2 replies

  11 years, 8 months ago

  By: Thor Bev

• Tools for report of SQL server 'Health'

  Hi all! Recently I found out, that the CPU utilisation from the sqlserver.exe had grown from app. 2…

  Edvard Korsbæk

  1 replies

  11 years, 8 months ago

  By: TheSQLGuru

• Convert sql to sqlsrv code

  Hi All Can anyone assist in me converting this snippet of code from mysql to ms sql. I am using the…

  allanstarr023

  7 replies

  11 years, 8 months ago

  By: Andrew Kernodle

• SQL 2012 Always on

  Hi, We are planning to implement always on one of our production environment. I know we need sql en…

  Robin35

  3 replies

  11 years, 8 months ago

  By: Perry Whittle

• creating a SQL View with calculations

  hi, I apologize in advance for not following "Forum Etiquette: How to post data/code on a forum to …

  tnthunder

  8 replies

  11 years, 8 months ago

  By: tnthunder

• Incorrect table size being reported... possibly

  Hi, I have a table that contains 1.6 million rows, and is about 2.6GB in size One of the columns is…

  Steve Smith-163358

  12 replies

  11 years, 8 months ago

  By: Perry Whittle

• Do not understand 'delete from [table] From [table]' syntax

  Hi all! I have inherited a query, which does exactly what i want. Only problem is, that I really do…

  Edvard Korsbæk

  5 replies

  11 years, 8 months ago

  By: Eric M Russell

• Alerting when tempdb files have X% free space

  I have a tempdb split into 4 files (5 if you include the log). Autogrowth is disabled on the mdf/nd…

  Jay@Work

  11 replies

  11 years, 8 months ago

  By: Jay@Work