SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• dbcc checktable bombs on large tables

  I’m running into issues checking integrity on large tables. ( e.g. over 100 million records and gr…

  Indianrock

  1 replies

  5 years, 2 months ago

  By: vitaminxu

• How to write dynamic statement with way do it run quickly?

  I work on SQL server 2012 I face Issue I implement dynamic SQL it very slow so I need to enhance st…

  ahmed_elbarbary.2010

  6 replies

  5 years, 2 months ago

  By: Jonathan AC Roberts

• Can't start SQL Server Agent

  I'm having enormous trouble starting SQL Server Agent. I have one server that is running two instan…

  DaveBriCam

  3 replies

  5 years, 2 months ago

  By: Mr. Brian Gale

• How to do User Defined Function take input as text and output text and numbers ?

  problem How to make UserDefinedFunction on sql server 2012 split column text to two columns . first…

  ahmed_elbarbary.2010

  5 replies

  5 years, 2 months ago

  By: Chris Wooding

• value separate to text and unit not working when value have comma separated mult

  I work on SQL server 2012 I face issue : I can't split Value column to Text Unit and Value Unit in …

  ahmed_elbarbary.2010

  4 replies

  5 years, 2 months ago

  By: pietlinden

• Remove TempDB ndf file

  Hi, I have added ndf to tempdb for checking performance improvement.... Now i want to remove the nd…

  Pulivarthi Sasidhar

  8 replies

  5 years, 2 months ago

  By: onetsql

• 2012 Cluster Failures

  Hi, We are relatively new to clustering. We are experience a lot of failovers and was wondering if…

  lmacdonald

  5 replies

  5 years, 2 months ago

  By: king

• How to add column columnunit dynamically when FlagAllow is 1?

  How to add column column unit dynamically when Flag Allow is 1 on table #nonparametric table ? I wo…

  ahmed_elbarbary.2010

  2 replies

  5 years, 2 months ago

  By: as_1234

• SSAS 2012: Processing Pool Job Queue length exceeded

  Hello, I have an alert from SCOM. Alert: SSAS 2012: Processing Pool Job Queue length exceeded. Sour…

  KireLaw

  2 replies

  5 years, 2 months ago

  By: KireLaw

• T-sql Syntax help needed

  Question: I want to create a sequential rank. Run the code and you will understand what I mean. I n…

  mw_sql_developer

  3 replies

  5 years, 2 months ago

  By: Jeff Moden

• 512e (Advanced Format) Drives

  I have an 2 node, AlwaysOn deployment on Windows 2012 R2 and SQL Server 2012 SP2. Both replicas are…

  David Lafayette

  9 replies

  5 years, 2 months ago

  By: angelinemarren

• Date conversion in ssis

  Hi Team, I am trying to convert this date format "11-APR-2016 11:24:36.000000" in derived column in…

  Charmer

  9 replies

  5 years, 2 months ago

  By: corey lawson

• Cluster IP address resource \'ClusterIP\' failed to come online

  We had recently numerous cluster issue. And our network team swap the cable last night and still we…

  EasyBoy

  1 replies

  5 years, 3 months ago

  By: EasyBoy

• how to access sql user in snapshots database

  Hi all, Created snapshot database. then this database need to access reporting application So how t…

  SQL Galaxy

  5 replies

  5 years, 3 months ago

  By: SQL Galaxy

• Parse XML field?

  Hi How would I parse out a value in an XML field Say in the XML field below I want to parse out cli…

  jbalbo

  1 replies

  5 years, 3 months ago

  By: jonathan.crawford