SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• How to change the sql service passwords on a SQL 2012 cluster - thanks

  Hi, How to change the sql service passwords on a SQL 2012 cluster - thanks Thanks

  APA0876

  3 replies

  11 years, 11 months ago

  By: lkennedy76

• Information Architects vs DBA : roles and responbilities

  I am having a lively debate at my company on the roles and responsibilities of DBA vs Information A…

  joseph.devereaux

  3 replies

  11 years, 11 months ago

  By: Grant Fritchey

• Sum in tricky way, how to make it beautiful??

  Hi, all I preparing ds for my report and need some intelligent summation, every monthID will go int…

  mario17

  2 replies

  11 years, 11 months ago

  By: mario17

• create a table using the value of a variable

  create a table using the value of a variable example: create uspCreateTable @ NameTable varchar (1…

  laercionb

  13 replies

  11 years, 11 months ago

  By: Sean Lange

• Drop Large Table causes AlwaysON AG Latency

  We are running SQL Server 2012 with an asynchronous READ ONLY AlwaysON Availability Group with two …

  BrerSQL

  1 replies

  11 years, 11 months ago

  By: TheSQLGuru

• SQL 2012 Partitioning Large Table on Nullable Date

  I have a very large table that I need to partition. Ideally the table will write to three filegroup…

  Ben Burrus

  2 replies

  11 years, 11 months ago

  By: Ben Burrus

• Connection issue from application

  We are having connection issue, while the application from IIS server connects to the SQL server 20…

  Eshika

  2 replies

  11 years, 11 months ago

  By: lkennedy76

• List of sql statements that makes dml or ddl to particular table. How to know ?

  Hi All, I have a question. Let's say I have a table TABLE_1. Is it possible to know which sql state…

  Akayisi

  3 replies

  11 years, 11 months ago

  By: Akayisi

• Query performance (Avoid Cluster index scan and Lazy spool)

  I'm trying to lookup the country of an ip address. Therefor I'm using the table IP2COUNTRY_LOOKUP. …

  bas_vdl

  21 replies

  11 years, 11 months ago

  By: ChrisM@Work

• Transaction Logs not being backed up on Availability Groups although flagged as successful

  Hello, Just wondering if someone can help me here, we use AlwaysOn availability groups, which has 2…

  marcus.dempsey 85650

  2 replies

  11 years, 11 months ago

  By: Beatrix Kiddo

• Always on HA On Windows Azure - Best Practice

  I'm currently setting up a 2012 AoHA cluster in Windows Azure and looking for advice/recommendation…

  Leo.Miller

  2 replies

  11 years, 11 months ago

  By: Leo.Miller

• Does anyone care that I passed 70-461?

  Hey all, I decided to do a serious career turn about and get back into Comp Sci (which I started in…

  j.b.shteyn

  29 replies

  11 years, 11 months ago

  By: Eric M Russell

• SELECT @@version and Windows Server 2012 R2

  Anyone else getting the wrong value returned when running SELECT @@version on a SQL 2012 instance i…

  Jared

  1 replies

  11 years, 11 months ago

  By: Jared

• Source Control

  Hello, We are in the process of migrating from SQL 2008 to 2012 (can't go to 2014 since two of our …

  Jim

  2 replies

  11 years, 11 months ago

  By: TheSQLGuru

• difference between '‚' and ','

  Hi, can anyone please explain me why i am getting 'no' as answer for below query, instead of 'yes'.…

  madhu.palakurthi

  8 replies

  11 years, 11 months ago

  By: Greg Edwards-268690