SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• SSIS: Asynchronous and parallel execution level, for whole pack or just component

  Hi, all it's kind of academic question, which I can't get as a novice, can this Asynch and Parallel…

  mario17

  1 replies

  11 years, 5 months ago

  By: Koen Verbeeck

• BEGIN TRAN with SELECT statements

  Hello, Short question... Should BEGIN TRAN ...COMMIT be used in a procedure body if I have only sel…

  maieras.andrei

  2 replies

  11 years, 5 months ago

  By: maieras.andrei

• SSRS data shared data source connection login

  Was wondering if there was a best practice minimum permissions for creating a SQL login to use when…

  rob.lewis 86087

  1 replies

  11 years, 5 months ago

  By: lmarkum

• AlwayOn 2012 Avaiability Group Listener DNS resolving to DR Node

  Hi, We are rolling out the use of Availability Group listeners to our SQL Server 2012 Environment w…

  JayK

  3 replies

  11 years, 5 months ago

  By: JayK

• Insert Statement with IF Statement

  Is it possible to have an Insert Statement with an IF? For example I want to check the value of a f…

  Meatloaf

  7 replies

  11 years, 5 months ago

  By: TheSQLGuru

• Auditing SQL Server 2012

  I work for the State of California. I am working on a project setting up a Data Warehouse sharing d…

  bmanning20

  2 replies

  11 years, 5 months ago

  By: bmanning20

• Problem with the back up script on SQL Server 2012 Express

  Hello All, I've script that backs up SQL database every morning at 7AM. After, I installed new micr…

  SSRS Newbie

  4 replies

  11 years, 5 months ago

  By: TheSQLGuru

• Management Studio - Graphical Execution Plan Oddity

  Just looking through some rogue queries on an optimisation exercise; one of them has some rather od…

  david.alcock

  1 replies

  11 years, 5 months ago

  By: TheSQLGuru

• Length of columns in a table.

  Hello, I am working on a migration project and need to derive the total length of the columns for …

  indrajit.gaikwad

  2 replies

  11 years, 5 months ago

  By: indrajit.gaikwad

• SQL AG + FCI

  Hi all We are looking at implementing AlwaysOn AG combined with a Failover Clustered Instance of SQ…

  SQLSACT

  1 replies

  11 years, 5 months ago

  By: Perry Whittle

• SQL 2012 - Import/Add packages from MSDB to DataTools/BIDS

  I have a bunch of packages in msdb. Is there any easier way to move those packages from msdb to Dat…

  balasach82

  13 replies

  11 years, 5 months ago

  By: PB_BI

• Mutex in SQL

  Hi, I have the same application on multiple servers, I used application locks as mutex to serialize…

  kjed

  2 replies

  11 years, 5 months ago

  By: kjed

• SQL bonuses from being a MS partner?

  Hi guys, Just wondering if there are any advantages from becoming a Microsoft silver partner for a …

  rob.lewis 86087

  2 replies

  11 years, 5 months ago

  By: rob.lewis 86087

• Generating date range values (start/end dates) from month columns with boolean values

  I've got some records like this: ID_________Jan Feb...........................Dec 0000030257 0 0…

  DSNOSPAM

  8 replies

  11 years, 5 months ago

  By: Dwain Camps

• Index creation on predicates

  I was reading this blog below about Indexed Views and needed some clarification. When the author ch…

  smitty-1088185

  2 replies

  11 years, 5 months ago

  By: gulema.gerressu