SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• AlwaysOn Availabilty Group listener connection issues

  Hi, I'm hoping someone can offer some suggestions on what to look at here as we're getting a little…

  andrew 13724

  5 replies

  8 years, 10 months ago

  By: sspsanz01

• Having trouble installing AdventureWorksDW2012 in SQL 2012

  Hello,  I believe this has been discussed before but I am a bit confused now: I have a local S…

  halifaxdal

  5 replies

  8 years, 10 months ago

  By: Sue_H

• PowerShell script to Automate monitor SQL Server error log

  Hello Friends, I hope everyone doing well JJ Anyone can please provide me the PowerShell script &nb…

  Database admin(DBA)

  6 replies

  8 years, 10 months ago

  By: Sue_H

• 3 node windows cluster support two separate 2 replica AG's?

  Is there any reason why a 3 node windows cluster would not be able to support two separate two repl…

  Jeff Shurak

  1 replies

  8 years, 10 months ago

  By: Joie Andrew

• Latency issues in Transactional Replication

  Hi, We have two SQL server 2012 bidirectional transactional replications working correctly.Instance…

  rogelio.vidaurri

  43 replies

  8 years, 10 months ago

  By: rogelio.vidaurri

• Issue with linked server access for SQL authenticated users

  Hi All, So we have 2 instances of SQL Server on the same machine. One is installed to another drive…

  Kazmerelda

  2 replies

  8 years, 10 months ago

  By: Kazmerelda

• Licensing types

  Would like to know what type of license this is SQL Server Enterprise Core ALNG LicSAPk MVL 2Lic C…

  Crown Clit

  1 replies

  8 years, 10 months ago

  By: Gail Shaw

• It's about encryption key

  Hi All,In know it's irrelevant to sql server but, hope somebody can help or let me know the steps.Q…

  p.shabbir

  4 replies

  8 years, 10 months ago

  By: p.shabbir

• Why is restoring a system database cross server a bad idea?

  Hi all, I made a post a while ago in regards to an update to our DR process we currently have. In t…

  Thom A

  7 replies

  8 years, 10 months ago

  By: Thom A

• What is perfect way to declare variable data type in asp.net to match SQL data type?

  From asp.net project I need to insert data into one table in SQL server which has a lot of data typ…

  adonetok

  8 replies

  8 years, 10 months ago

  By: Ed Wagner

• All disk space used, after deleting rows the table has 6GB "unused"space but I cannot release it or shrink the mdf.

  Dear, We have a table with 100 million rows and 1 clustered index (primary key).The hard disk is fu…

  syen.j

  28 replies

  8 years, 10 months ago

  By: Jeff Moden

• Is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause

  I have this sql statement where I'm attempting to join several tables. But I also need to find the …

  walter.dziuba

  5 replies

  8 years, 10 months ago

  By: DesNorton

• Using Count to compile for each unique CustomerID

  I want to create a column whereas I will count each instance a customerid has an orderid AND does n…

  Zososql

  2 replies

  8 years, 10 months ago

  By: drew.allen

• Transactional Replication Question

  Good morning all.... I have not had to do a lot of replication work - once its setup it just runs f…

  steven.johnson 49708

  1 replies

  8 years, 10 months ago

  By: WolfgangE

• How to get the count of distinct value from my resulted Query

  Hi ,Below is my query, --===== If the test table already exists, drop it  IF OBJECT_ID('TempD…

  poornima.s_pdi

  5 replies

  8 years, 10 months ago

  By: Eirikur Eiriksson